Parsing to new column ever time a word occures

[lbolin]

I would like to parse the data every time displayText occurs. I can get it to do it once but i am not sure how to do it evetime it occurs

[{"displayText": "Offers Delivery", "alias": "RestaurantsDelivery", "isActive": true, "iconName": "24x24_order", "__typename": "BusinessProperty"}, {"displayText": "Offers Takeout", "alias": "RestaurantsTakeOut", "isActive": true, "iconName": "24x24_shopping", "__typename": "BusinessProperty"}, {"displayText": "Masks required", "alias": "customers_must_wear_masks", "isActive": false, "iconName": null, "__typename": "BusinessProperty"}, {"displayText": "Accepts Credit Cards", "alias": "accepts_credit_cards", "isActive": true, "iconName": null, "__typename": "BusinessProperty"}, {"displayText": "Free Wi-Fi", "alias": "wifi_options", "isActive": true, "iconName": "24x24_wifi", "__typename": "BusinessProperty"}, {"displayText": "Drive-Thru", "alias": "has_drive_thru", "isActive": true, "iconName": "24x24_drive_thru", "__typename": "BusinessProperty"}, {"displayText": "Open to All", "alias": "is_open_to_all", "isActive": true, "iconName": "24x24_open_to_all", "__typename": "BusinessProperty"}, {"displayText": "Dogs Not Allowed", "alias": "dogs_allowed", "isActive": false, "iconName": "24x24_bone", "__typename": "BusinessProperty"},

[dougperez]

This seems like a Json file to me. Try to parse with Json Parse tool and cross tab it

See the workflow attached

[lbolin]

That did not seem to work i get a jumbled mess. 

[dougperez]

Can you share your input? Because with your example, it worked well 

[lbolin]

i don't think i can this is for word and it is over 2 million records. 

[dougperez]

Try this one
I'm doing the Json Parse "by hand"

[lbolin]

yes it looked like it worked. 

[dougperez]

That's good news 
I think I know what gone wrong in my first example, but without the input file is very hard to guess 😅
If my answer helped, mark it as the solution!