Preceding Load strips leading and trailing spaces

[#1]

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);

[wizardo · Accepted solution]

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