9.3.2.3.28 delim.nullindicator.escaped
Specifies the value that will replace a null indicator when a null indicator occurs in the input data. The syntax is:
delim.nullindicator.escaped={value|\xhex_value}
For example, given the following property settings:
delim.fielddelim=, delim.nullindicator=NULL delim.nullindicator.escaped=$NULL$
When the input data does not contain a NULL
value or a NULL
indicator:
1 2 3 4 5
The result is
1,2,3,4,5
When the input data contains a NULL
value:
1 2 4 5
The result is
1,2,NULL,4,5
When the input data contains a NULL
indicator:
1 2 NULL 4 5
The result is:
1,2,$NULL$,4,5
Parent topic: Delimited Parser Properties