topic Re: Space in CSV in Archived Groups

Space in CSV

Michiel_QV_Fan — Wed, 23 Jul 2025 14:48:52 GMT

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

Re: Space in CSV

rbecher — Fri, 25 Aug 2017 07:57:26 GMT

Hi Michiel,

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

- Ralf

Re: Space in CSV

Michiel_QV_Fan — Fri, 25 Aug 2017 08:26:21 GMT

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.

Re: Space in CSV

rbecher — Fri, 25 Aug 2017 08:28:22 GMT

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

Re: Space in CSV

Michiel_QV_Fan — Fri, 25 Aug 2017 08:36:37 GMT

No, file is too big

Re: Space in CSV

prieper — Fri, 25 Aug 2017 10:42:11 GMT

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