No blanks in Listbox displayed

[wunderch]

I have the following problem:

I have an Excel where the text is with blanks.

When I load the Excel the blanks are not displayed in a listbox.

Is there a chance to display blanks in a listbox?

Regards

Chris

[sunny_talwar · Accepted solution]

Try this code:

SET Verbatim = 1;

LOAD Dim1

FROM

[TESTCW_EXCEL.xlsx]

(ooxml, embedded labels, table is Tabelle1);

[awhitfield]

Hi Christian,

see below:

Verbatim

Normally all field values are automatically stripped of preceding and succeeding blank characters (ASCII 32) before being loaded into the QlikView database. Setting this variable to 1 suspends the stripping of blank characters.

Example:

set Verbatim = 1;

HTH

Andy

[wunderch]

Thanks! It's so easy!