Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Tags (3)
1 Solution

Accepted Solutions
whiteline
Honored Contributor II

Re: Multiple characters as delimiter while storing a CSV file

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.

4 Replies
Not applicable

Re: Multiple characters as delimiter while storing a CSV file

can you please post some sample data ?

Not applicable

Re: Multiple characters as delimiter while storing a CSV file

The delimiter is a single character (see helpfile)

You will NOT manage to write several characters

Fabrice

whiteline
Honored Contributor II

Re: Multiple characters as delimiter while storing a CSV file

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

Re: Multiple characters as delimiter while storing a CSV file

Thank  you so much.. your idea works... :-)

Community Browser