NetXMS Support Forum

How do you specify a tab delimiter when using external table?
separator=\t
or
separator=\\t
or
separator=\\\t
or
other?
Nothing is working for me.

Hi,

it should be \t. Just checked on my system this configuration:

ExternalTable = TestTable:separator=\t;instanceColumn=COL1:cat /home/victor/test.csv

and got expected results:

victor@hp8570w ~ $ /opt/netxms/bin/nxget -T ::1 TestTable
| COL1 | COL2  | COL3  |
| 1    | test  | test  |
| 2    | test2 | test2 |
| 3    | test3 | test3 |

Best regards,
Victor

Victor,

Thank you for the reply and for making and releasing awesome software!

SOLVED:
The problem was a spelling error!

NOT with an "e":
seperator

Correct spelling:
separator

Ughh facepalm!
Sorry for the false alarm.

Thank you,
Ernest
https://www.linkedin.com/in/ernestgwilsonii/