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 -

You have to be able to define something that indicates where the strings should be split.  Is it the occurence of a capital letter, based on your example data?

Without some rule, there is no way for a person, let alone a program, to know where to split.

Mark

[jrben]

The rule would be to read: comma, (no space) then uppercase letter

[Mchappell67 · Accepted solution]

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