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

Question

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

binu_acs · Answer

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

Pipe_Delimited_220223.yxzp

danilang · Answer

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