-e

Use character for C-style escaping instead of quoting.

Syntax

-e [ESCAPE_CHARACTER]

Description

Column separators that appear as a value will be preceded by the escape character specified in [ESCAPE_CHARACTER].

Example

In the following example, the delimiter character is changed to /. One of the values in the table, *o/23, uses the delimiter character. You can use the -e switch and an escape character (in this case $) to escape the / character:

$ tendo -u [USERNAME] -p [PASSWORD] -g [GATEWAY] pub.demo.baseball.batting . -n 1 -c / -e $

The result is the following:

hatfijo01/1871/mut/na/33/168/41/43/50/3/2/0/22///10/3/4///0/*o$/23/hatfield/john///7/20/1847/1871/30023

Note that the / in *o/23 is escaped by the character $ so that the value is not split up.