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.  Delimiter Node - How to ignore a delimiter withing quote.

    Employee
    Posted 08-27-2014 03:03

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

    Originally posted by: abhisek

    Green,2,primary,7138,"""Let's Go"", he said"

    Here I am using delimiter comma(,) for separation, but the data within the quote also contain a character (,) which I want to ignore.
    I am getting error because of it.
    How to resolve it.


    Thanks


  • 2.  RE: Delimiter Node - How to ignore a delimiter withing quote.

    Employee
    Posted 08-27-2014 03:23

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

    Originally posted by: Tim Meagher

    Hi,

    On the Optional tab, you'll see a parameter where you can specify the "QuoteCharacters".
    If you set this to a double quote (") this will work in your scenario.
    Note that the CSV File node is preconfigured to handle this common case for you.

    Tim.


  • 3.  RE: Delimiter Node - How to ignore a delimiter withing quote.

    Employee
    Posted 08-27-2014 06:08

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

    Originally posted by: ejones

    When you have this type of data already in a field in BRE you can write this data to an output file and then read it back in. You should be able to use either the "Output Delimited" or the lal1 "Output Raw" to write the file. Then, as Tim describes above, use the "CSV File" node to read it back in.