Skip to main content
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... 🙂