Data360 Analyze

 View Only

  • 1.  double quotes issue in output text file

    Posted 09-28-2020 23:02

    I am creating an output file "XYZ.txt" based on some logic but double quotes are getting added in the final data. There are 3 inputs to a cat file (all string) but for the middle input double quotes are added. I have kept blank for all the properties option in the CSV/ Delimiter option. Can someone please suggest what can be an issue and how to remove them.



  • 2.  RE: double quotes issue in output text file

    Employee
    Posted 10-12-2020 08:33

    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.