How to get the field value, that starts with a space?

[asgardd2]

Hello!

     I have values in my database, that starts with a space, like " Pepsi"," Mirinda".

Then i load them in QlikView, the first space character disappears.

How i can load them in QlikView and "save" first space character?

Best regards,

Alexandrov Anton

[tresesco · Accepted solution]

Verbatim

Normally all field values are automatically stripped of leading and trailing blanks (ASCII 32) before being loaded into the QlikView  database. Setting this variable to 1 suspends the stripping of blanks. Tab (ASCII 9) and hard space (ANSI 160) are never stripped.

Syntax:

Verbatim 

Example:

set Verbatim = 1;             // in the script

[Anonymous]

you could also concatenate a dummy symbol in front and/or after your fieldvalue at SQL database level and remove this symbol(s) later...

Verbatim = 1 works for all fields as long as it is activated. This can be a feature or a problem... it depends.