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 🙂
Hi @soncokuÂ
You can use Regex tokenize mood
\d{9}_\d{9}_\d
Should workÂ
Config
Here is the workflow
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
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!
Happy to help 🙂 @soncokuÂ
Cheers and Happy Analyzing 😀
Wow. Thank you.
Much appreciated 🙂
