Regex Tool data parsing

[Vaib]

Hello,

I am trying to parse the below text using the Regex tool but am kind of stuck:

Text to be parsed	Part 1	Part 2	Part 3	Part 4	Part 5	Part 6
35mvY5S1H3J2QZyna3TFe0,10/30/2020172*0.737*96[0]	35mvY5S1H3J2QZyna3TFe0	10/30/2020	172	0.737	96	0
47EiUVwUp4C9fGccaPuUCS,10/30/2020205*0.731*100[4]	47EiUVwUp4C9fGccaPuUCS	10/30/2020	205	0.731	100	4

Also, can you guide me as to how I can learn and understand regex better.

[atcodedog05 · Accepted solution]

Hi @Vaib 

Here is how you can do it.

Workflow:

Hope this helps : )

[binuacs · Accepted solution]

@Vaib Similar to @atcodedog05  approach

(.+?)\,(\d+\/\d+/\d{4})(\d{3})\*(.+?)\*(\d+)\[(\d+)\]

[Vaib]

Thank you! Both the solutions did work for me. Would you be able to guide me as to how I can learn regex. 

[atcodedog05]

Happy to help : ) @Vaib 

Here are some helpful resources 

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-RegEx/ta-p/37689

https://regexr.com/ 

Cheers and have a nice day!

[Christina_H]

@Vaib The interactive lessons are a good place to start, RegEx is in the Parsing Data section

https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Parsing%20...

[Vaib]

Thank you everyone!

[MartWClimber]

what also is a great source is https://github.com/ziishaned/learn-regex#learn-regex