Separating a long string in one colmun

Question

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 Answer

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 Answer

Hey thanks I will try, much appreciated

AkimasaKajitani · Accepted Answer

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]+