223
Views
1
Comments
Solved
Functions - Last 6 characters of a string
Question

Hi 

Is there a function where I can get the last 6 characters of a string?

2018-10-29 08-31-03
João Marques
 
MVP
Solution

Hi Randall,


Yes, you can use the Substr function.


In case your variable is called Text, your expression would look like this:


The good practice is to check if the string has at least 6 characters (in my case, I am returning empty if it has less than 6),  otherwise use the Substr function to get the last 6 characters.


Kind Regards,
João

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.