Skip to main content
Question

Pipeline formula to extract last 5 characters of text string

  • March 9, 2023
  • 0 replies
  • 560 views

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

Forum|alt.badge.img+6
  • Quickbase Staff
  • March 10, 2023

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

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



------------------------------
Doug Henning
------------------------------