Regex Parse Help
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.