Regex Parse Help

al_sweets

I have some data which contains a field I would like to use to Parse Regex tool on but I can't quite figure it out. The column I am looking at parsing looks as follows:

Business

[["Services","Printing"]]

[["Sports and Leisure","Outdoors","Camping"]]

[["Retail","Fashion","Watches"]]

[["Services","Financial"]]

There are 800,000+ rows, so there are numerous combinations. I would like to separate these tags into separate fields, like follows.

Business	Cat1	Cat2	Cat3
[["Services","Printing"]]	Services	Printing	[Null]
[["Sports and Leisure","Outdoors","Camping"]]	Sports and Leisure	Outdoors	Camping
[["Retail","Fashion","Watches"]]	Retail	Fashion	Watches
[["Services","Financial"]]	Services	Financial	[Null]

Does anyone know the Regex pattern to parse this like above?

neilgallen

@al_sweets The solution above would work, but that presumes that you know the maximum number of values that will be in each field. in case you're not sure (and with 800,000 values I'm not confident you would be) then the attached solution would work.

Parsing to rows allows for a variable field length. The attached workflow would account for this. 

To answer your earlier question, a regex could be used, but isn't necessary.

Regex Parse Help.yxmd