Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Data input text to columns

FECL3
8 - Asteroid

Hi

 

I have a csv data input that has irregular delimiters. Most of them are separated by commas, however some cells include commas within themselves. As a result it splits the data out incorrectly. Please see sample data in spreadsheet attached and desired output. 

 

How do I solve this?

 

 

10 REPLIES 10
atcodedog05
22 - Nova
22 - Nova

Fun meme @StephaneP  🤣🤣🤣

Labels