Skip to main content
Question

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 could be used to identify the start of the string, but a formula that simply states "X characters" would be most straightforward. Is that an option in QB?

Thanks in advance!



------------------------------
Amy Christensen
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24

    I suggest making a native Quickbase formula field. 

    Right(Trim([my text field]),5)



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Forum|alt.badge.img+6

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

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



    ------------------------------
    Doug Henning
    ------------------------------
    Terms & ConditionsAccessibility statement