LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Got xx columns, but expected only xx

    Employee
    Posted 07-08-2015 07:09

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: lauraw_21

    Hi

    I am getting the error message, I am using ; as FieldDelimiter and \n as RecordDelimiter
    When I look at the file as a CSV it splits fine with ; as a the delimiter so I don't understand why Lavastorm is not treating it the same?

    I've noticed that although the field delimiter is ; there is a column that has an inappropriate ; which is splitting incorrectly into 2, it has " around the data, so in excel we would use the "Text Qualifier" field when you text to columns to inform excel not to split this field, does Lavastorm have a similar function?


    Laura


  • 2.  RE: Got xx columns, but expected only xx

    Employee
    Posted 07-09-2015 05:53

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: lnason

    Hi Laura - I think I understand the scenario you are describing, but could you send along a data sample that illustrates what you are seeing, so we can be sure we address your question correctly?

    Generally speaking, issues like this can be resolved by configuring one or more of the following node parameters in the "Optional" tab: EscapeCharacters, QuoteCharacters, QuotedDoubleQuotes.

    Luke