https://community.qlik.com/t5/QlikView/Truncate-characters-and-preceding-zero/m-p/1238536#M866528 <HTML><HEAD></HEAD><BODY><P>Thank you Sunny.</P></BODY></HTML> Fri, 09 Dec 2016 22:56:02 GMT 2016-12-09T22:56:02Z https://community.qlik.com/t5/QlikView/Truncate-characters-and-preceding-zero/m-p/1238534#M866526 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Am new to QlikView and have the below requirement and seeking help from gurus.</P><P></P><P>I have a Field as per below and need help on desired output. Please advice.</P><P>Field is a combination of Name &amp; ID -&gt; ID starts with '(' and ends with ')' I need to truncate the first 2 chars and if there is a preceding zero that needs to be removed as well. </P><P></P><P>Field - XXX YYY ZZZ (AA0123054)</P><P>Output - 123054</P><P><SPAN style="font-size: 13.3333px;">Field - </SPAN>A BB CCCC (XX0985050)</P><P><SPAN style="font-size: 13.3333px;">Output - </SPAN>985050</P><P></P><P>Thanks,</P><P>Rai</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Truncate-characters-and-preceding-zero/m-p/1238534#M866526 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Truncate-characters-and-preceding-zero/m-p/1238535#M866527 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>KeepChar(TextBetween(FieldName, '(', ')'), '0123456789) * 1 as Output</STRONG></P></BODY></HTML> Fri, 09 Dec 2016 16:48:07 GMT https://community.qlik.com/t5/QlikView/Truncate-characters-and-preceding-zero/m-p/1238535#M866527 sunny_talwar 2016-12-09T16:48:07Z https://community.qlik.com/t5/QlikView/Truncate-characters-and-preceding-zero/m-p/1238536#M866528 <HTML><HEAD></HEAD><BODY><P>Thank you Sunny.</P></BODY></HTML> Fri, 09 Dec 2016 22:56:02 GMT https://community.qlik.com/t5/QlikView/Truncate-characters-and-preceding-zero/m-p/1238536#M866528 2016-12-09T22:56:02Z