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.
West Hills, CA Cellphone|0008388|Administrator|CKOKINE