Delimiter Issue

[jboschee]

Hi everyone,

I have an output csv file with a | as my delimiter.  I have one name with a comma in it that I need to keep in one column and not split into two. 

Smith, John vs Smith John

Anyone have an idea on how to do this?

Thanks!

[JohnJPS]

Hi @jboschee ... just curious: if your file is pipe delimited, isn't it retaining "Smith, John" as a single field already?

[BenMoss]

I'm not sure I understand what the problem is if you are using a PIPE (|) as your delimiter instead of a comma?

It should work fine.

Are you reading or writing the file?

Ben

[jboschee · Accepted solution]

I was able to fix it by exporting it as a txt file, then removing all delimiters when I open it in excel.