Skip to Content
avatar image
Former Member

Read the data from Flat file with Pipe Delimiter (|)

Hi,

My Data Services Job is reading data from Flat File. This Flat file contains Pipe Delimiter.For some records, DS job is not able to load and error is

"A row delimiter was seen for row number <13704> while processing Column Number <26> in file. Check the file for bad data".

But flat file contains data as expected.

Could you please let me know if you have any idea on this.

Regards.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 23, 2015 at 05:00 PM

    Open the file in notepad++ and see if you have any row delimiter issues. Also you can see the issue if you open in Excel.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 26, 2015 at 09:31 AM

    The message is very clear (for once 😉), isn't it? Column #26 of Row #13704 contains a Row Delimiter ( a carriage return). These things often happen with text fields.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 27, 2015 at 05:33 AM

    Hi All,

    I have enabled YES for Adaptable Schema while creating Flat File . Now all data is loading.

    Thanks for your inputs.

    Regards.

    Add comment
    10|10000 characters needed characters exceeded