Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 (2)
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