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
Solved! Go to 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 :
Hey thanks I will try, much appreciated
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]+
In the regex you were missing "s" for space.
This shall fix it.
Thanks again
GarMingle