Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiple characters as delimiter while storing a CSV file

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

1 Solution

Accepted Solutions
whiteline
Master II
Master II

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.

View solution in original post

4 Replies
Not applicable
Author

can you please post some sample data ?

Not applicable
Author

The delimiter is a single character (see helpfile)

You will NOT manage to write several characters

Fabrice

whiteline
Master II
Master II

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.

Not applicable
Author

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