Extract 8 digit number from a string

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

Accepted answers

Jonathan-Sherman

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

20200326 - ParseOutNumber.yxmd

All comments

Jonathan-Sherman

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

20200326 - ParseOutNumber.yxmd

NotQuiteClueless

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

Many thanks

IsabelN

Hi @Jonathan-Sherman

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703