Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

rasmuskolding
New Contributor

Blank spaces when peek

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

2 Replies
el_aprendiz111
Valued Contributor

Re: Blank spaces when peek

Hi

SET verbatim =1;

Table:

Load * from xyz.xlsx;

pradosh_thakur
Valued Contributor III

Re: Blank spaces when peek

Community Browser