topic STORE into CSV with ; at lineend in App Development

STORE into CSV with ; at lineend

pwagner — Wed, 22 Dec 2021 15:03:40 GMT

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

Re: STORE into CSV with ; at lineend

chris_djih — Wed, 19 Jan 2022 14:24:15 GMT

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 ';'

Re: STORE into CSV with ; at lineend

marcus_sommer — Wed, 19 Jan 2022 17:52:12 GMT

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

Re: STORE into CSV with ; at lineend

pwagner — Thu, 20 Jan 2022 08:47:56 GMT

Thank you for your feedback.

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