topic Create CSV file using custom delimiter in Qlikview store command in QlikView

Create CSV file using custom delimiter in Qlikview store command

Anonymous — Tue, 18 Oct 2016 04:12:09 GMT

Dear Gurus,

I want to create a CSV file Qlikview script with a custom delimiter('-|-') using below script.

Test:

LOAD caseId,

description,

ticket_details

FROM

(ooxml, embedded labels, table is Sheet0);

STORE Test

INTO [S_OCT2016.csv](txt, delimiter is '-|-');

However, I observed that it is only considering 1st character(-) only as delimiter. Reason why I need custom delimiter is our ticket_details column contains all special characters. So when I give single delimter it is splitting the column when ever that special character found in ticket_details column.

Please share if you have any alternative to store the data into csv from xlsx.

Br,

Chinna

Re: Create CSV file using custom delimiter in Qlikview store command

jagan — Tue, 18 Oct 2016 06:13:00 GMT

Hi,

Try like this

Test:

LOAD caseId,

description,

ticket_details

INLINE [

caseId, description,ticket_details

a, b, c

d, e, f

];

STORE Test INTO [S_OCT2016.csv](txt, delimiter is '\x1e');

DROP TABLE Test;

Test:

LOAD *

FROM

(txt, utf8, embedded labels, delimiter is \x1e, msq);

Re: Create CSV file using custom delimiter in Qlikview store command

Anonymous — Tue, 18 Oct 2016 07:28:40 GMT

Hi Jagan,

It is not considering the delemiter '\x1e'

Br,

Chinna

Re: Create CSV file using custom delimiter in Qlikview store command

jagan — Tue, 18 Oct 2016 07:31:40 GMT

It is a single character, it is working for me and I am able to create QVD and able to load that QVD into qlikview.

Regarsd,

jagan.

Re: Create CSV file using custom delimiter in Qlikview store command

Sudharsan — Thu, 24 Jan 2019 06:48:13 GMT

Hello Chinna
Did you find solution for this. I'm facing the same issue. Delimiter in my source file is #|# whereas Qlik consider only first character as delimiter.

Thanks,
Sudharsan