Apologies if this has been asked before....I cant seem to find what I am after.
I have a field where I want to select only 4 digits from text which is in the middle of the data. What formula/expression do I use for this?
Sample: L300033010101 (I need the numbers from 6-9, therefore L300033010101 )
Expected result: 3301
Many thanks.
Solved! Go to Solution.
Check out the substring() function within the formula tool.
In your instance something like
substring([field],6,4)
Should do the trick.
Ben
Thanks Ben......worked a treat.
Much appreciated.