topic Re: Loading data from CSV with '§' Delimiter in QlikView

Loading data from CSV with '§' Delimiter

patrickwirz — Sat, 16 Nov 2024 01:24:10 GMT

Hi everyone

I have a lot of csv files that I want to load into QlikView.
But I have a special "Delimiter" ---> "§"

How can I define such delimiters in the QV-Loading-Script?

(see also Printscreen)

Thanks in advance.

Patrick

TimvB — Tue, 28 Jan 2020 17:10:13 GMT

Use the following script in the script editor:

TableName:

LOAD

*
FROM CSVFileName

(txt, utf8, embedded labels, delimiter is '§', msq);

Hope it helps!

patrickwirz — Wed, 29 Jan 2020 22:52:01 GMT

Thank you - I will test it and get to you back again.

Patrick