none
How to extract string with line feed

    Question

  • I'm trying to extract data from a tab-delimited text file. This text file contain a string with line feed character which encapsulated by double quote. I'm using Extractors.Text(delimiter : '\t', quoting : true, encoding : Encoding.UTF8, skipFirstNRows : 1) to extract the data but it returns error "Unexpected number of columns in input record at line 5232.
    Expected 7 columns, processed 5 columns out of 5.". Any suggestion?

    Here are the data in text file and error message.

    Monday, September 5, 2016 7:35 AM

All replies