https://community.qlik.com/t5/QlikView/mobile-number-clean-up/m-p/1720934#M722621 <P>Maye be</P><LI-CODE lang="python">right(Field,10) as NewField </LI-CODE><P>&nbsp;</P><P>output :</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Taoufiq_ZARRA_0-1592838011480.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/36001iB17EC30421EE20DB/image-size/medium?v=v2&amp;px=400" role="button" title="Taoufiq_ZARRA_0-1592838011480.png" alt="Taoufiq_ZARRA_0-1592838011480.png" /></span></P><P>&nbsp;</P> Mon, 22 Jun 2020 15:00:33 GMT Taoufiq_Zarra 2020-06-22T15:00:33Z https://community.qlik.com/t5/QlikView/mobile-number-clean-up/m-p/1720929#M722620 <P>Hello all,</P><P>I am working on customer data where the mobile number filed needs to be clean before matching to other tables. I want to clean numbers that start from +91 or 91 which is country code.&nbsp; The following data and output example will clear all that its to be look like so some data points have +91 at starts and some have only 91 and some data point consist of space after country code. i want final output to be only a 10 digit mobile number please help me I am new to qlik sense.</P><P>Ex.&nbsp;</P><P>Data&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; output</P><P>1. +919898989898&nbsp; =&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9898989898</P><P>2. 919898989898 =&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9898989898</P><P>3. 91 9898989898 =&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9898989898</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/mobile-number-clean-up/m-p/1720929#M722620 Sagarm35 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/mobile-number-clean-up/m-p/1720934#M722621 <P>Maye be</P><LI-CODE lang="python">right(Field,10) as NewField </LI-CODE><P>&nbsp;</P><P>output :</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Taoufiq_ZARRA_0-1592838011480.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/36001iB17EC30421EE20DB/image-size/medium?v=v2&amp;px=400" role="button" title="Taoufiq_ZARRA_0-1592838011480.png" alt="Taoufiq_ZARRA_0-1592838011480.png" /></span></P><P>&nbsp;</P> Mon, 22 Jun 2020 15:00:33 GMT https://community.qlik.com/t5/QlikView/mobile-number-clean-up/m-p/1720934#M722621 Taoufiq_Zarra 2020-06-22T15:00:33Z