Create CSV file using custom delimiter in Qlikview store command

[Anonymous]

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

[jagan]

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);

[Anonymous]

Hi Jagan,

It is not considering the delemiter '\x1e'

Br,

Chinna

[jagan]

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.

[Sudharsan]

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