โ11-22-2017 04:11 AM
Hi,
I have a csv file โ|โ separated which has records like below.
123456|61|eng |01|aabc|test|16|Long|,|01|aabc|test1|Regular|Short||
112569|61|eng |01|vfbc|test3|16|XL|
how to read both records as 1st record has 2 details in a single row separated by comma. CSV parser is giving below error-
โThe CSV record has more columns than data, Resolution: Please provide valid CSV data at line 7 or route it to the error viewโ
please suggest
โ11-22-2017 06:37 AM
โ11-23-2017 04:09 AM
Hi,
Thanks for providing the solution, the pipeline solves the concern of splitting a record of csv however my csv also has a single line record and the pipeline shared by you its giving error when trying to execute with that file.I have attached source file, kindly help in getting it resolved.
sample.txt (155 Bytes)
Error:
Failure: Error parsing at line 2, Reason: Cannot complete CSV data parsing, Resolution: Please provide valid CSV data at line 1 or route it to the error view
โ11-26-2017 11:20 PM
Hi,
Can anyone help on it , I need it badly to solve my pending issue.
โ11-28-2017 03:24 AM
if you observe, there is a blank line character in your file.
โ|01|aabc|test1|Regular|Short||112569|61|eng |01|vfbc|test3|16|XL|
\n9876540|51|en_in |51|Test2|size|minus|51|1X||||||||โ
What is your expectation?