Print Page - How to specify a tab delimiter when using external table?

Title: How to specify a tab delimiter when using external table?
Post by: ErnestGWilsonII on April 18, 2018, 07:29:45 PM

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.

Title: Re: How to specify a tab delimiter when using external table?
Post by: Victor Kirhenshtein on April 19, 2018, 04:55:45 PM

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

Title: Re: How to specify a tab delimiter when using external table?
Post by: ErnestGWilsonII on April 21, 2018, 02:17:40 PM

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/

NetXMS Support Forum

English Support => General Support => Topic started by: ErnestGWilsonII on April 18, 2018, 07:29:45 PM