How To Handle Apostrophe in Data File

[mohdhaniff]

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. CUSTOMER_NAME - INCORRECT

2. JANN - INCORRECT

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

Expected Result:

[jonathandienst · Accepted solution]

Modify the file format specifier:

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

[mohdhaniff]

Great!!!