Space in CSV

[Michiel_QV_Fan]

I need to load a CSV supplied by a third party.

The following issue occurs:

Using the wizard a number of column names is defined like this:

[part.description ]

There is an extra space at the end of the column name.

This extra space is then a load error thus failing the load script.

Removing that extra space in the script (= [part.description]) then loads the script without errors.

After receiving an updated file this doesn't work anymore.

2 Off the fields are not loaded when the space is removed while the other 60 fields where the space is removed are loaded.

Any suggestions are welcome.

Or is this a Qlik bug?

QV version 11.20

[rbecher]

Hi Michiel,

can you attach the CSV header and some lines to try it out?

- Ralf

[Michiel_QV_Fan]

Ralf,

I used this to test myself.

ODBC is doing what is needed but that has a limitation of 255 columns (32 bit) but my file has 1.000 colunns.

[rbecher]

Can you not just use a text editor and cut out the first 10 rows?

[Michiel_QV_Fan]

No, file is too big

[prieper]

Encountered the problem with the blanks as well, guess that there is a difference in interpreting the headers in the wizard and then in the live-module. Trimming should work, do not understand, why this fails at yours.

You may also load the file without headers and add them manually.

Else load the file with fixed width and the option FIRST 100 LOAD and store the qvw here.

Peter