View the original community article here
Last tested: Sep 19, 2017
You can take a substring from the end of a string by using the length
function to calculate the starting point. Let n
be the number of characters at the end you want to get:
substring(${field_name}, length(${field_name}) - (n-1), n)
If I want to get the last 4 digits of the license key for example:
substring(${license_key}, length(${license_key}) - 3, 4)
This works regardless of the length of the string.
Chat Tip: Many use cases for table calcs require multiple functions, combined in interesting ways. Think about how you can use the pieces you have to do what you want.
This content is subject to limited support.