Blank spaces when peek

[Anonymous]

Hi all!

I have a table loaded from an excelfile with some text columns, in which som cells have blank spaces before or after the cell text. This is deliberate and needed for further use. However, in the debugger, I can se that blank spaces are removed from the variable when using peek() to retrieve values from the cell.

I am not sure if this is done by the peek function or upon load, but in either case, is there a way to retain the blank spaces in the cells?

Regards

Rasmus

[el_aprendiz111]

Hi

SET verbatim =1;

Table:

Load * from xyz.xlsx;

[pradosh_thakur]

Hi

refer this for the explanation.

http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/SystemVariables/Verbati...

regards

Pradosh