Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser-ak
Contributor
Contributor

How to read csv file with special delimiter character ║

Hi,

Is there an option in Qlik Data load editor to read csv file with special character delimiters like  ║

For example this script is not working...

LOAD
id║email║last_name║first_name║create_date║update_date║is_deleted║phone║is_external║status_id
FROM [lib://Data/UserAction/]
(txt, utf8, embedded labels, delimiter is '║', msq)

Labels (1)
1 Solution

Accepted Solutions
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Have you tried this:

LOAD
               *

FROM [lib://Data/UserAction/]
(txt, utf8, embedded labels, delimiter is '║', msq)

View solution in original post

2 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Have you tried this:

LOAD
               *

FROM [lib://Data/UserAction/]
(txt, utf8, embedded labels, delimiter is '║', msq)

qlikuser-ak
Contributor
Contributor
Author

Thank you, that did the trick!