topic Re: Modify data from a table in QlikView https://community.qlik.com/t5/QlikView/Modify-data-from-a-table/m-p/614365#M682044 <HTML><HEAD></HEAD><BODY><P>if its '#0' always. You can use the Replace function to replace the '#0'&nbsp; with a '' (blank).</P></BODY></HTML> Mon, 24 Mar 2014 13:17:23 GMT srchilukoori 2014-03-24T13:17:23Z Modify data from a table https://community.qlik.com/t5/QlikView/Modify-data-from-a-table/m-p/614364#M682043 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am loading data from a table and would like to remove the two last characters of the field <STRONG>PRV_CODE</STRONG>. (#0)</P><P>These characters is allways in the end of the value, but the length of the <STRONG>PRV_CODE</STRONG> can vary.</P><P>Any idea?</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0"><TBODY><TR><TD height="19" width="88">PRV_RENTITY</TD><TD width="99">PRV_PROPERTY</TD><TD width="71"><STRONG>PRV_CODE</STRONG></TD><TD width="86">PRV_NVALUE</TD></TR><TR><TD height="19">PMCF</TD><TD>ESTTIMER</TD><TD>83<STRONG>#0</STRONG></TD><TD>5.000000</TD></TR></TBODY></TABLE><P></P><P>Best regards<BR />Dag</P></BODY></HTML> Mon, 24 Mar 2014 13:15:13 GMT https://community.qlik.com/t5/QlikView/Modify-data-from-a-table/m-p/614364#M682043 2014-03-24T13:15:13Z Re: Modify data from a table https://community.qlik.com/t5/QlikView/Modify-data-from-a-table/m-p/614365#M682044 <HTML><HEAD></HEAD><BODY><P>if its '#0' always. You can use the Replace function to replace the '#0'&nbsp; with a '' (blank).</P></BODY></HTML> Mon, 24 Mar 2014 13:17:23 GMT https://community.qlik.com/t5/QlikView/Modify-data-from-a-table/m-p/614365#M682044 srchilukoori 2014-03-24T13:17:23Z Re: Modify data from a table https://community.qlik.com/t5/QlikView/Modify-data-from-a-table/m-p/614366#M682045 <HTML><HEAD></HEAD><BODY><P>you can use</P><P>=SubField(<STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">PRV_CODE</STRONG>,'#',1)</P></BODY></HTML> Mon, 24 Mar 2014 13:20:33 GMT https://community.qlik.com/t5/QlikView/Modify-data-from-a-table/m-p/614366#M682045 chiru_thota 2014-03-24T13:20:33Z Re: Modify data from a table https://community.qlik.com/t5/QlikView/Modify-data-from-a-table/m-p/614367#M682046 <HTML><HEAD></HEAD><BODY><P>Use below in your script instead of <STRONG style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.800000190734863px;">PRV_CODE</STRONG></P><P></P><P>Replace(<SPAN style="font-size: 12.800000190734863px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>PRV_CODE</STRONG></SPAN>,'#0','') as <STRONG style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.800000190734863px;">PRV_CODE</STRONG></P></BODY></HTML> Mon, 24 Mar 2014 13:23:21 GMT https://community.qlik.com/t5/QlikView/Modify-data-from-a-table/m-p/614367#M682046 MK_QSL 2014-03-24T13:23:21Z Re: Modify data from a table https://community.qlik.com/t5/QlikView/Modify-data-from-a-table/m-p/614368#M682049 <HTML><HEAD></HEAD><BODY><P>Use Purge Char fuction</P><P>=purgechar(<STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">PRV_CODE</STRONG>,'#0')</P></BODY></HTML> Mon, 24 Mar 2014 13:23:59 GMT https://community.qlik.com/t5/QlikView/Modify-data-from-a-table/m-p/614368#M682049 arsal_90 2014-03-24T13:23:59Z Re: Modify data from a table https://community.qlik.com/t5/QlikView/Modify-data-from-a-table/m-p/614369#M682051 <HTML><HEAD></HEAD><BODY><P>Thanks for all answers.<BR />The code worked fine <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Mon, 24 Mar 2014 13:36:07 GMT https://community.qlik.com/t5/QlikView/Modify-data-from-a-table/m-p/614369#M682051 2014-03-24T13:36:07Z