Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
bilionut
Contributor III
Contributor III

load csv file whith / " characters

Hi,

When I load from a csv file with a field containing this characters / " all the records are skipped until occurs a new appearance of /"

This is the contents of the csv file:

1,Item xx,33

2,Item AA,22

3,Item yy,5

4,Item  1 / " ,3

5,Item xx,7

6,Item ACB,1

7,Item xx,8

8,Item  7 / ",3

9,Item CC,4

10,Item xx,78

11,Item AA,5

12,Item xx,3

13,Item AA,2

14,Item yy,77

and this is the result of load

untitled.JPG

If I export the Table box to csv I get this:

1,Item xx,33

2,Item AA,22

3,Item yy,5

4,"Item  1 / ""","3

5"

9,Item CC,4

10,Item xx,78

11,Item AA,5

12,Item xx,3

13,Item AA,2

14,Item yy,77

There is a way to solve this without replace characters / " in field ?

Thanks for help,

Ionut

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Are you using msq as quoting? Try setting quoting to standard (removing  'msq' from your filter, like

LOAD @1,

     @2,

     @3

FROM

C:\Users\Stefan\Documents\Testcsv.txt

(txt, codepage is 1252, no labels, delimiter is ',');

instead of

...

(txt, codepage is 1252, no labels, delimiter is ',',msq);

View solution in original post

2 Replies
swuehl
MVP
MVP

Are you using msq as quoting? Try setting quoting to standard (removing  'msq' from your filter, like

LOAD @1,

     @2,

     @3

FROM

C:\Users\Stefan\Documents\Testcsv.txt

(txt, codepage is 1252, no labels, delimiter is ',');

instead of

...

(txt, codepage is 1252, no labels, delimiter is ',',msq);

bilionut
Contributor III
Contributor III
Author

It works fine,

Thanks swuehl