Parse through specific commas

jrben

Hi everyone,

I'm looking for a way to parse through one columns with N number of strings split by commas. This will ultimately be split up into rows. The part I'm stuck is that there are commas within the strings that should not be split up. Also, the commas are not constant nor are the number of outputted rows.

Data	Desired Output
The cat loves yarn, dolls, and food,The dog like walking	The cat loves yarn, dolls, and food
	The dog like walking

Mchappell67

Hi, @jrben -

Here's what I came up with:

Somebody that is better at regex than me can probably get rid of the trailing commas in the single formula, but I just added a formula at the end to get rid of them.

Hope this helps, at least as a starting point.

Mark

splitter.yxmd