Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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);
It works fine,
Thanks swuehl