How we can parse the Below Value through Regex Tool.

[Kaustubh17]

Hi Team,

Can someone help me with below value Regex expression I need the regular expression. Below is the attached data. help with the regex and the flow. how i can separate the all the value.

Thanks,

kaustubh

[Ben_H · Accepted solution]

Hi @Kaustubh17,

I've made you a sample that should work for you.

I'd recommend you have a go on a website like https://regexr.com/ to learn a bit more about how regex works.

Regards,

Ben

[atcodedog05 · Accepted solution]

Hi @Kaustubh17 

Here is my take. Its almost similar to @Ben_H. 

Going through https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-RegEx/ta-p/37689 might help you with regex.

Workflow:

Hope this helps : )

[Kaustubh17]

Hi @atcodedog05 

Regex is working for me. Thanks for your support.

Thanks,

Kaustubh

[Kaustubh17]

Hi @Ben_H 

Your Regex is working for me. Thanks for your support.

Thanks,

Kaustubh

[atcodedog05]

Happy to help : ) @Kaustubh17 

Cheers and have a nice day!