RegEx formula to find a specific pattern

[soncoku]

Hey all.

I have a column of data from which I want to pull out only this pattern:

293847463_323847565_1

So 9numbers_9numbers_1number

but I'm not that fluent in regex

any help would be appreciated 🙂

[atcodedog05 · Accepted solution]

Hi @soncoku 

You can use Regex tokenize mood

\d{9}_\d{9}_\d

Should work 

Config

Here is the workflow

[Amarendra]

Hi @soncoku

@atcodedog05Solution works great!! To further help you, look at the lesson notes section in this article - https://regexone.com/ I hope this makes RegEx easy and fun for you!

[MarqueeCrew · Accepted solution]

Answer should be:

Regex_Match([your data],"\d{9}_\d{9}_\d")

true or false as a Boolean variable in your formula or filter. 

cheers,

 mark

[atcodedog05]

Happy to help 🙂 @soncoku 

Cheers and Happy Analyzing 😀

[soncoku]

Wow. Thank you.

Much appreciated 🙂