Trying to pull an 8 digit number from a description column using the RegEx tool

[F5_GL]

Hello,

I am completely new to regex syntax. Could anyone help me figure out how to parse out the 8 digit numbers from the data below. The numbers will always start with 81 and be 8 digits but could be anywhere within the string.

81036015 Talisen Construction Corporation

PO 81036666 Systems source, inc Task chairs

TIMBER IT Consulting inv 4418 PO 81033202

Thanks!

[cjaneczko · Accepted solution]

If there arent any other 8 character digit sets in the any of your strings you can use (\d{8}) or if they all start with 81 then ([81]+\d{6}).

[binuacs · Accepted solution]

@F5_GL One way of doing this with the regex tokenize method

[F5_GL]

Thanks so much - so cool!