How to use non-characters as custom delimiters

  • 30 November 2021
  • 0 replies
  • 93 views

Userlevel 3
  • StreamSets Employee
  • 0 replies

Question:

How to use a non-character as a delimiter for delimiter data format with a custom delimiter format type? 

Answer:

By using \u notation, you are able to use control characters(DC1, DLE, SUB) as delimiter characters. This allows you to free up other characters normally used as delimiters such as ",', |, etc.

In the below example, the quote character has been set to Control Character - Device Control 1(\u0011) which allows the " character to be freed.

 


This topic has been closed for comments