topic Re: How To Handle Apostrophe in Data File in QlikView

How To Handle Apostrophe in Data File

mohdhaniff — Wed, 25 Nov 2020 16:16:04 GMT

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:

Re: How To Handle Apostrophe in Data File

jonathandienst — Fri, 04 Nov 2016 06:36:45 GMT

Modify the file format specifier:

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

Re: How To Handle Apostrophe in Data File

mohdhaniff — Fri, 04 Nov 2016 06:53:02 GMT

Great!!!