topic Re: Trim Function in QlikView

Trim Function

Prabhu1204 — Sat, 16 Nov 2024 00:41:10 GMT

Hello

Could you please clear how trim works.

I have a values in excel like below

When i loaded the excel in Qlivkiew, i am not getting the text with leading spaces.

For example in my excel the second column apple has leading spaces. why doesnt it shoes in qlivkiew? there is no rim used inside script

Why so ?

Re: Trim Function

dplr-rn — Wed, 13 May 2020 14:21:18 GMT

qlik automatically trims leading and trailing spaces.

if you dont want qlik to do so you can specify using a system variable

set Verbatim = 1;

refer to below

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/SystemVariables/Verbatim.htm

Re: Trim Function

fosuzuki — Wed, 13 May 2020 14:23:26 GMT

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

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/SystemVariables/Verbatim.htm

So try putting this in your script:

set Verbatim = 1;