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

Question

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!

Regex Question.jpg

cjaneczko · Accepted Answer

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}).

binu_acs · Accepted Answer

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