Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
chinnakatikisg
Specialist
Specialist

Create CSV file using custom delimiter in Qlikview store command

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

4 Replies
jagan
MVP
MVP

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

chinnakatikisg
Specialist
Specialist
Author

Hi Jagan,

It is not considering the delemiter '\x1e'

Br,

Chinna

jagan
MVP
MVP

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
Contributor
Contributor

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