Preceding Load strips leading and trailing spaces

Fri, 28 May 2010 05:07:47 GMT

The following code results in leading and trailing spaces being removed from FieldB. Is this a bug or a 'feature'? I'm using QV9 SR2.

Test:
load
FieldA & '{Spaces Removed before and after dash}' as FieldB;
load
' TEST - ' as FieldA
autogenerate(1);

Preceding Load strips leading and trailing spaces

wizardo — Fri, 28 May 2010 07:26:38 GMT

hi there, take a look at this special variable

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;

hope this helps

Mansyno

topic Preceding Load strips leading and trailing spaces in QlikView

Preceding Load strips leading and trailing spaces

Preceding Load strips leading and trailing spaces

Verbatim

Example: