AnsweredAssumed Answered

Can we have | (pipe) as delimiter in CSV file ?

Question asked by Tushar Sutar on Aug 26, 2016
Latest reply on Aug 29, 2016 by Tushar Sutar

I am working on a CSV collector, the business people are sending file with delimiter as | pipe, as some the data values have comma in them already.


I tried with _CSV_Separator=| but not getting successful test.

What else I am missing or it won't work ?


Temporarily I am using notepad++ to search and replace with regular expressions.


Complete string



Sample data 


Miami, FL|0009432|Administrator|AFARIA0
SITEL Bogota|0007931|Administrator|APRAKAS
West Hills, CA Cellphone|0008388|Administrator|CKOKINE