Create CSV file using custom delimiter in Qlikview store command
I want to create a CSV file Qlikview script with a custom delimiter('-|-') using below script.
(ooxml, embedded labels, table is Sheet0);
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.