STORE into CSV with ; at lineend

[pwagner]

Hello community,

we want to STORE a table in loading script into a CSV file with ; as delimiter.

So far so good, it is working to stroe the CSV with ; delimiter.

Unfortunately at lineend we find a line break (‚\r‘) but we need a ; at the end.

My question is, is it possible to change the '\r' to ;?

Thank you.

Best regards, Patrick

[chris_djih]

Speeking technically: this is a wrong formating of a .csv: it is specified, that each delimiter (;) is seperating  anew Field. In your desired screenshot there is technically an added field with all null values.

Why do you need this ';'

[marcus_sommer]

I think it's not possible to change the line-break by the storing of the file. Like above already mentioned you would with a replace to a ; create either an invalid file-structure or you would get a single record.

Now it's not quite clear what your intention is. If you need just more empty respectively NULL fields you may just add them within the load where your need them. If you instead want to get a single record you could concat your fields and records like:

load concat(F1 & ';' & F2 & ';' & F3, ';') as Fields from Source; 

- Marcus

[pwagner · Accepted solution]

Thank you for your feedback.

We found a solution via NPrinting using Qlik Entity and output format SKV.