CSV Pipe Delimited file removing commas in record and putting following data in new column
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
baileetimm
5 - Atom
‎02-22-2023
10:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 Product | LLC | 000000 |
Desired Output:
222222 | MP Product, LLC | 000000 |
Labels:
- Labels:
- Common Use Cases
2 REPLIES 2
19 - Altair
‎02-22-2023
10:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
‎02-22-2023
12:49 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@baileetimm I tried with your data and it is working fine for me. Can you try to run the workflow and see the result?
