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

double quotes issue in output text file

Comments

1 comment

  • Avatar
    Adrian Williams

    The default field separator for a CSV file is the comma character. If an input field value contains the field separator character (,) the node will surround the corresponding value written to the file with quotes (by default). If this was not done, the file format would be invalid. This action is performed even if the input data only comprises a single field.

    You may want to consider using a different file format for the delimited file, e.g. a Tab separated file. 

    The FieldDelimiter property specifies the field separator character that will be used by the node (\t will result in a Tab separated file)

    The QuoteCharacter property specifies the character used to encapsulate the values in the written file.

    0
    Comment actions Permalink

Please sign in to leave a comment.