Skip to main content

How to use non-characters as custom delimiters

  • November 30, 2021
  • 0 replies
  • 104 views

Sami
StreamSets Employee
  • StreamSets Employee

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.

 

Did this topic help you find an answer to your question?
This topic has been closed for comments