Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
hi there, take a look at this special variable
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.
set Verbatim = 1;
hope this helps
Mansyno
hi there, take a look at this special variable
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.
set Verbatim = 1;
hope this helps
Mansyno