Using non-printable characters as field delimiter in a CSV file

  • 14 September 2023
  • 0 replies
  • 69 views

Badge

Sometimes the CSV connectors don’t parse the .csv files correctly due to the field delimiter used in the file. By default, the driver separates each field file by commas, however the field delimiter can be specified by setting the FMT connection property. The FMT can be set to one of the following values CsvDelimited (the default value), TabDelimited (the driver separates each field by tabs) or FixedLength (the driver counts a specified number of characters to separate each field). 

It is also possible to set any ASCII character represented by a hexadecimal string as field delimiter.  

Example: If the .csv file uses the SOH (Start of Header) character as field delimiter, try setting the FMT property to 0x01 (the hexadecimal representation of the SOH character). The same logic is also applied in the RowDelimiter property, which specifies the character that will be used to detect the end of a CSV row. 


This topic has been closed for comments