4 Replies Latest reply on Aug 30, 2018 2:35 PM by Alexis Brown-Oracle

    Parsing/syntax validation of a CSV file

    3682593

      Hi,

       

      When I'm polling/reading a file in CSV format and the file content have some rows get null in end of the line.Then the file adapter throwing below error.

       

      Gives following error while polling:

       

      Error while translating.

      Translation exception.

      Error occurred while translating content from file /nonftp/DEV/FilePickTest/test.csv

      Please make sure that the file content conforms to the schema. Make necessary changes to the file content or the schema.

       

      Below is the sample format of file. If we mention some space at end it's working. In my case some records  receive qty as null.

      id,name,qty

      1,aaa,20

      2,bbb,

       

      can some one help on this scenario.

       

      Thanks,

      Phani