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
------------------------------
Original Message:
Sent: 03-10-2023 10:53
From: Doug Henning
Subject: Pipeline formula to extract last 5 characters of text string
In Jinja you can use [-5:]
on a string to get the last 5 characters. Example:
{{ a.field_name[-5:] }}
------------------------------
Doug Henning
Original Message:
Sent: 03-09-2023 11:38
From: Amy Christensen
Subject: 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
------------------------------