Free Trial

Alteryx Designer Desktop Discussions

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

CSV Pipe Delimited file removing commas in record and putting following data in new column

baileetimm
5 - Atom

I am outputting a pipe delimited CSV file that is manipulating some of my records that have commas within them and putting the data following the comma into a new column. Any idea why this is happening? 

 

Ex.

 

222222 | MP Product, LLC | 000000

 

Current Output: 

 

222222 | MP ProductLLC | 000000

 

Desired Output:

 

222222 | MP Product, LLC | 000000
2 REPLIES 2
danilang
19 - Altair
19 - Altair

hi @baileetimm 

 

What's the configuration of your output tool?  Can you post a sample workflow with just enough anonymized data to demonstrate the issue?

 

Dan 

binuacs
21 - Polaris

@baileetimm I tried with your data and it is working fine for me. Can you try to run the workflow and see the result?

binuacs_0-1677098920110.png

 

Labels
Top Solution Authors