Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
patrickwirz
Contributor
Contributor

Loading data from CSV with '§' Delimiter

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

 

Labels (3)
1 Solution

Accepted Solutions
TimvB
Creator II
Creator II

Use the following script in the script editor:


TableName:

LOAD

*
FROM CSVFileName

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

 

Hope it helps!

View solution in original post

2 Replies
TimvB
Creator II
Creator II

Use the following script in the script editor:


TableName:

LOAD

*
FROM CSVFileName

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

 

Hope it helps!

patrickwirz
Contributor
Contributor
Author

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

Patrick