Forum Discussion

AmyChristensen's avatar
AmyChristensen
Qrew Member
2 years ago

Pipeline formula to extract last 5 characters of text string

Hello all, I have been trying to find any way to set up a pipeline that extracts the last 5 characters of a text string of varying length to copy to another field. There are some consistencies that...
DougHenning1's avatar
DougHenning1
Community Manager
2 years ago

In Jinja you can use [-5:] on a string to get the last 5 characters. Example:

{{ a.field_name[-5:] }}



------------------------------
Doug Henning
------------------------------
  • AmyChristensen1's avatar
    AmyChristensen1
    Qrew Trainee
    2 years ago

    This is the solution I tried first, but without the colon - which is probably why it only returned a single character! Mark's solution was more straightforward for this use case, but I'll keep this in my hip pocket for the future. Thanks!



    ------------------------------
    Amy Christensen
    ------------------------------