Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a field that varies each side of two '-'s, example:
ABC-12345678-XYZ
ABC1-12345678-ZZXXZZ
A1-12345678-09LP
What I need to do is get to that middle number of 8, that won't change, unlike the text / numbers either of this field.
My question is how can I pull this out the 8 numbers, when the numbers / letters can change and vary in length.
Thanks All.
Di
hi,
use
substring(yourfield,'-',2) as substring
regards
Use
SubField([debtor_number],'-',2) as debtor_number,