Forum Discussion

aanchalrajpal's avatar
aanchalrajpal
New Contributor
8 years ago

How to use CSV Parser to read multiple records in single row

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 reco...
aanchalrajpal's avatar
aanchalrajpal
New Contributor
8 years ago

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

  • aanchalrajpal's avatar
    aanchalrajpal
    New Contributor
    8 years ago

    Hi,

    Can anyone help on it , I need it badly to solve my pending issue.

    • nganapathiraju's avatar
      nganapathiraju
      Former Employee
      8 years ago

      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?

      • aanchalrajpal's avatar
        aanchalrajpal
        New Contributor
        8 years ago

        I want my pipeline to read both the records as that is how i will get my csv file.Yes their can be blank line character in file. But my concern here is m not able to read both the records as csv parser takes first line and set no of columns but when it comes to next row the columns get decreased and it failed. So is their any way we can read both the rows by any snap.