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

jdbc:csv:////home/oracle/database/SampleData/Sears/?_CSV_Header=true;maxScanRows=20000;charSet=ISO8859_1;tmpdir=/home/oracle;_CSV_Separator=|

 

Sample data 

 

Location|Unit_Number|Role|Username
Miami, FL|0009432|Administrator|AFARIA0
SITEL Bogota|0007931|Administrator|APRAKAS
West Hills, CA Cellphone|0008388|Administrator|CKOKINE
Bridgeview,IL|0009420|Administrator|DAGUIR3

Outcomes