delimiter is '|'

[deepakqlikview_123]

Hello All,

Please find attachment.

My  delimiter is '|' can you please suggest what to select in custom settings so that I will get each column separately in QVW file.

In file.Please share procedure

Thanks,

[Anonymous]

When you load the file, choose delimiter as custom. You will get a list of delimeters. Select '|' from this list. See attached.

[PrashantSangle]

Hi,

Use below code

LOAD @1,
@2,
@3,
@4,
@5,
@6,
@7,
@8,
@9,
@10,
@11,
@12,
@13,
@14
FROM test.txt
(txt, codepage is 1252, no labels, delimiter is '|', msq);

Regards

[senpradip007]

PFA. Hope it will help.

[amit_saini · Accepted solution]

Deepak,

Follow:

Thanks,
AS