Get a 17 digit numer from a messy row

[soncoku]

Super-Al(UK)-Beu1-823-99.1.20_1_21844503153780381_Facebook_Mobile_Feed

Any idea how to get that number in a new column?
I have many rows and they all have a different format but that number has always 17 numbers.

I need something that would work on all rows.

[JosephSerpis · Accepted solution]

Hi @soncoku I mocked up a workflow that showcases how to do that. Let me know what you think?

[atcodedog05 · Accepted solution]

Hi @soncoku 

Here is a workflow for the task.

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

Happy to help 🙂 @soncoku 

Cheers and Happy Analyzing 😀