topic Re: How to read csv file with special delimiter character ║ in Reporting Service & Alerting

How to read csv file with special delimiter character ║

qlikuser-ak — Fri, 15 Nov 2024 22:05:59 GMT

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)

Re: How to read csv file with special delimiter character ║

Oleg_Troyansky — Fri, 29 Jul 2022 19:20:01 GMT

Have you tried this:

LOAD
*

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

Re: How to read csv file with special delimiter character ║

qlikuser-ak — Fri, 29 Jul 2022 20:19:27 GMT

Thank you, that did the trick!