Parsing from long string of numbers

[samshem]

Does somebody know how I could parse a 12 digit number that starts 16 digits in and ends 4 digits before the end? For example the string of numbers 9761243631002561 724686727627 2019, the numbers that are in the middle are the ones that need to be parsed from the entire string. How would I specify that in a calculation? Thanks for the help.

[LaRetta]

If there will always be a space before and after the string you wish to extract, you can use this:

MiddleWords ( theField ; 2 ; 1 )

[Lee Smith]

Use the Middle ( text ; start ; numberOfCharacters ) and fill in the blanks

i.e.

Middle ( YourField ; 16 ; 12 )

[samshem]

Thank you again for your assistance, it works.