topic load csv file whith / " characters in QlikView

load csv file whith / " characters

bilionut — Sat, 12 May 2012 10:29:01 GMT

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

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

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

load csv file whith / " characters

swuehl — Sat, 12 May 2012 10:43:53 GMT

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

LOAD @1,

@2,

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);

load csv file whith / " characters

bilionut — Sat, 12 May 2012 11:23:11 GMT

It works fine,

Thanks swuehl