Extract 8 digit number from a string

[NotQuiteClueless]

Hi All, bit of a noob question but I've been battling RegEx and getting nowhere. My data looks like this

CHRIS: 1 30555364 CLARKE IF EAAG/010.01.RG79429.ADFA
Jnl 210: 1 57273055 SCOTT R SJAG/001.15.RG71146.ABAE

Transfer out staff costs for Burgess from SLAI/002 To SLAJ/018.

(80%) - CHRIS: 1 70472557 NIKOLIC B KKZA/153.01.RG88015.ADHA

I need to extract that 8 digit number from each line if it occurs so I initially tokenised the data and then I tried to parse the data using this (^\w*\)(s\d{8}\s)(\w*) but Alteryx isn't having it!

Thanks

Richard

[Jonathan-Sherman · Accepted solution]

Hi @NotQuiteClueless,

You could use a regex expression of (\d{8}) when parsing in the RegEx tool.

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[NotQuiteClueless]

I feel like such an idiot, over-complicating things as usual!

Many thanks

R

[IsabelN]

Hi @Jonathan-Sherman 

Is there a way to amend this if the 8 digits you are looking for always start with a 4?

[atcodedog05]

Sure @IsabelN 

change it to (4\d{7})