Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is my first question here, I hope anyone can help.
I have a problem creating a qvd-file based on a csv-file.
One of the fields in the csv is char-field, length=6. The second position is "J", all the others are blank.
Running my qvw, the result in the qvd is a field "J" with a length=1. All blanks are truncated.
I use the following script (maybe with wrong parameters?):
LOAD
@1 AS FIELD1,
@2 AS FIELD2,
@3 AS FIELD3, <= that’s the problem-field
@4 AS FIELD4,
@5 AS FIELD5
FROM Test.csv
(txt, codepage is 1252, no labels, delimiter is ';', msq)
;
The concerning part of the csv-file:
;" J "; …
The qvd looks this way:
Maybe someone has an idea?
Thanks a lot, Mike
this might be helpful:
Frank,
seems, it works
... with the little csv I tested with.
Next I will try it with the whole file (3,8 GB).
Thanx a lot!