We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

cvs unescaped quote

Comments

3 comments

  • Avatar
    Gerry Mullin

    There's a couple of options that have worked for me:

    1. You can manually create the parameter on the node and ensure it has a Run Time Property Name of ls.brain.node.csv.unescapedQuoteHandling

    You can enter one of the following values:

    Error
    Skip Value
    Stop at Closing Quote
    Stop at Delimiter

    2. Enter a value in the EscapeCharacter property that is very unlikely to ever be in your file. I usually enter something like ÷ which is generally safe to assume you'll never see it in a file you're receiving.

    0
    Comment actions Permalink
  • Avatar
    Sarita Gerbig

    Second option didn't work for me.

    Not sure what you are describing in option 1.  Are you saying create a parameter named UnescapedQuoteHandling or ls.brain.node.csv.unescapedQuoteHandling? If the later - didn't work either.

     

    0
    Comment actions Permalink
  • Avatar
    Gerry Mullin

    You can name the property UnescapedQuoteHandling, click on the menu to the right and then select Edit Details -> Run Time Property Name = ls.brain.node.csv.unescapedQuoteHandling.

    Hope that works!

     

    Attached files

    runtimeproperty.png

     

    0
    Comment actions Permalink

Please sign in to leave a comment.