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

How To Handle Apostrophe in Data File

Hi

How to upload csv or txt data contains apostrophe? I always got incorrect result, whereby multiple fields value are gathered into 1 field in Qlik View.

Data File: refer to attachment data.csv

Sql command:

Test:

NoConcatenate

LOAD * FROM C:\Desktop\data.csv (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Result:

1.JPG

1. CUSTOMER_NAME - INCORRECT

2. JANN - INCORRECT

3. OTHER FIELDS value are missing/incorrect due to error in CUSTOMER_NAME or JANN fields)

Expected Result:

1.JPG

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

Modify the file format specifier:

LOAD * FROM C:\Desktop\data.csv (txt, codepage is 1252, embedded labels, delimiter is ',', no quotes);

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Modify the file format specifier:

LOAD * FROM C:\Desktop\data.csv (txt, codepage is 1252, embedded labels, delimiter is ',', no quotes);

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
mohdhaniff
Creator
Creator
Author

Great!!!