topic How to disable automatic TRIM? in QlikView https://community.qlik.com/t5/QlikView/How-to-disable-automatic-TRIM/m-p/207218#M63042 <HTML><HEAD></HEAD><BODY><P>thnx</P></BODY></HTML> Wed, 30 Jun 2010 08:02:21 GMT 2010-06-30T08:02:21Z How to disable automatic TRIM? https://community.qlik.com/t5/QlikView/How-to-disable-automatic-TRIM/m-p/207216#M63040 <HTML><HEAD></HEAD><BODY><P>My question is very simple - how to disable an automatic trim in script?</P><P>For example - when I have in my SQL table in two rows such data: "12345" and " 12345" (in second variant there is a space before the number) - all I have in Qlik in both rows - is "12345". Whether I use text(Field) or just a Field - any way Qlik trims spaces.</P><P>How to disable it?</P></BODY></HTML> Tue, 29 Jun 2010 15:43:40 GMT https://community.qlik.com/t5/QlikView/How-to-disable-automatic-TRIM/m-p/207216#M63040 2010-06-29T15:43:40Z How to disable automatic TRIM? https://community.qlik.com/t5/QlikView/How-to-disable-automatic-TRIM/m-p/207217#M63041 <HTML><HEAD></HEAD><BODY><P>There's a special variable for it, "Verbatim".</P><P style="padding-left:30px;">SET Verbatim = 1; // This stops the auto trim for anything following it in the script<BR />SET Verbatim = 0; // This restarts the auto trim for anything following it in the script</P></BODY></HTML> Wed, 30 Jun 2010 00:52:58 GMT https://community.qlik.com/t5/QlikView/How-to-disable-automatic-TRIM/m-p/207217#M63041 johnw 2010-06-30T00:52:58Z How to disable automatic TRIM? https://community.qlik.com/t5/QlikView/How-to-disable-automatic-TRIM/m-p/207218#M63042 <HTML><HEAD></HEAD><BODY><P>thnx</P></BODY></HTML> Wed, 30 Jun 2010 08:02:21 GMT https://community.qlik.com/t5/QlikView/How-to-disable-automatic-TRIM/m-p/207218#M63042 2010-06-30T08:02:21Z Re: How to disable automatic TRIM? https://community.qlik.com/t5/QlikView/How-to-disable-automatic-TRIM/m-p/1763964#M454167 <P>it didn't work on my app</P><P>anythink else to check?</P> Tue, 24 Nov 2020 09:23:39 GMT https://community.qlik.com/t5/QlikView/How-to-disable-automatic-TRIM/m-p/1763964#M454167 bumin 2020-11-24T09:23:39Z