Separating a long string in one colmun

[GarMIngle]

This is what I have in one column:

Office SuppliesFurnitureOffice SuppliesOffice Supplies

Office SuppliesTechnology

This what I would like:

Office Supplies,Furniture,Office Supplies,Office Supplies

Office Supplies,Technology

I want to parse with comas so I can write a function using a portion of the long string not the entire string

[AkimasaKajitani · Accepted solution]

Hi @GarMIngle 

Is this helpful?

RegEx Setting :

RegEx Regular Expression

[A-Z][a-z]+\s[A-Z][a-z]+|[A-Z][a-z]+

Do not check "Case Insensitive"

RegEx Output :

Summarize Setting : 

Final Output :

[GarMIngle · Accepted solution]

Hey thanks I will try, much appreciated

[GarMIngle]

Any thoughts, I ended up with Office Supplies in two rows not one, everything else work perfectly. Do not know what to do to fix. Limited skills

[AkimasaKajitani · Accepted solution]

Hi @GarMIngle 

Please find the difference.

My Expression:

[A-Z][a-z]+\s[A-Z][a-z]+|[A-Z][a-z]+

Your Expression:

[A-Z][a-z]+\[A-Z][a-z]+|[A-Z][a-z]+ 

[PraphulSamavedam]

In the regex you were missing "s" for space.

This shall fix it. 

[GarMIngle]

Thanks again

GarMingle