topic Multiple characters as delimiter while storing a CSV file in QlikView

Multiple characters as delimiter while storing a CSV file

Fri, 22 Nov 2013 05:48:10 GMT

Hi,

I want to store my data into a csv file using the delimiter , '####\t' --- Multiple characters in delimiter.

I tried this below code,

Store Final_Dump into final.csv(txt,delimiter is '####\t');

All the fields are getting concatenated and shown as below in a single field.

OFCCircuitId#LOCircuitId#LayerRate

Kindly help me to resolve this issue

Re: Multiple characters as delimiter while storing a CSV file

Fri, 22 Nov 2013 15:28:14 GMT

can you please post some sample data ?

Re: Multiple characters as delimiter while storing a CSV file

Fri, 22 Nov 2013 15:49:00 GMT

The delimiter is a single character (see helpfile)

You will NOT manage to write several characters

Fabrice

Re: Multiple characters as delimiter while storing a CSV file

whiteline — Fri, 22 Nov 2013 20:07:41 GMT

Hi.

Can't even guess why you need so, but I think you can do it.

Concatenate all you fields manually into one using additional load statement. Don't forget to name the field properly as a concatenation of all names. Then just store your one field table.

Re: Multiple characters as delimiter while storing a CSV file

Thu, 12 Dec 2013 06:55:24 GMT

Thank you so much.. your idea works... 🙂