Extract number from String

[daniele_zatti]

Hi - I'm looking to extract from a string any 7-digit number sequence using RegEx.

Here are two example:

TEST 1234567 1608-3108                       ==>          1234567

TEST22 MOD.6_7894561_JUNE 23'       ==>         7894561

Thanks,
Daniele

[caltang]

In case you need my workflow, PFA. Hope this helps @daniele_zatti 

[daniele_zatti]

Perfect, works smooth now!

[daniele_zatti]

---

@caltang ... see below... i would like to capture only the strings that have exactly 7 digits (no more and no less)... on line 1 it should take 1234567... ideas?

[caltang]

Can I have the data.... hard to extract from an image.

[caltang · Accepted solution]

Nevermind, I've thought of something that incorporates REGEX and other tools as well:

Basically, we use Data Cleasning and REGEX to standardize your data, then use a length as filter to get what you want. Hope this helps @daniele_zatti 

Kindly mark it as an accepted solution as well if it helped.

[Suzann_Pillion]

Thank you SO MUCH!  This was exactly the answer I needed to extract the first 5 digit number in a text string!  Very helpful!