Pipeline formula to extract last 5 characters of text string

Question

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------------------------------

markshnier__you · Answer

I suggest making a native Quickbase formula field.&nbsp;
Right(Trim([my text field]),5)------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

doughenning1 · Answer

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

amychristensen1 · Answer

Thank you, I had been searching and never found the RIGHT function. Easy enough!------------------------------Amy Christensen------------------------------

amychristensen1 · Answer

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
------------------------------

Forum Discussion

Pipeline formula to extract last 5 characters of text string

4 Replies

Related Content

Three Words of Advice on Pipelines

Three Words of Advice on Building Pipelines - Brittany Scheid

Pipeline Not Triggering

syntax help with formula

AI Smart Builder for Creating Apps and Streamlining Pipelines