load csv file whith / " characters

[bilionut]

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

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

[swuehl · Accepted solution]

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]

It works fine,

Thanks swuehl