How to pull a string of digits from a Text field using a substring Text Calculation
This is similiar to a split calculation, but you do not need a comma, or a space or a "|" to separate out the values. The substring calculation works for a string of characters.
To return a string of digits from a text field you can use the substring calculation
There is a new substring calculation that enables you to pull through specific characters from a Text field.
The example in the image here shows that we want to pull out characters in the string of letters between the 0 and 2nd position from the field "Text". The equation is written like this:
substring(Text,0,2)
The image in the step below shows the ouput of this calculation.
0 Comments
Add your comment