topic TextBetween to eliminate one number in QlikView https://community.qlik.com/t5/QlikView/TextBetween-to-eliminate-one-number/m-p/1324538#M613545 <HTML><HEAD></HEAD><BODY><P>Bonjour,</P><P></P><P>Comment pourrai je utiliser textbetween pour prendre que 4chiffres de l'attribut suivant TextBetween Date(Date#(ADDTEN, 'DDMYYYY'), 'YYYY') c'est à dire je dois supprimer le 1er chiffre et prendre les 4.</P></BODY></HTML> Tue, 18 Jul 2017 08:08:03 GMT chadliagabsi 2017-07-18T08:08:03Z TextBetween to eliminate one number https://community.qlik.com/t5/QlikView/TextBetween-to-eliminate-one-number/m-p/1324538#M613545 <HTML><HEAD></HEAD><BODY><P>Bonjour,</P><P></P><P>Comment pourrai je utiliser textbetween pour prendre que 4chiffres de l'attribut suivant TextBetween Date(Date#(ADDTEN, 'DDMYYYY'), 'YYYY') c'est à dire je dois supprimer le 1er chiffre et prendre les 4.</P></BODY></HTML> Tue, 18 Jul 2017 08:08:03 GMT https://community.qlik.com/t5/QlikView/TextBetween-to-eliminate-one-number/m-p/1324538#M613545 chadliagabsi 2017-07-18T08:08:03Z Re: TextBetween to eliminte one number https://community.qlik.com/t5/QlikView/TextBetween-to-eliminate-one-number/m-p/1324539#M613546 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You use Mid() instead TextBetween</P><P><STRONG>Mid(Date(Date#(ADDTEN, 'DDMYYYY'), 'YYYY'),2,4)</STRONG></P><P>Regards,</P><P>Antonio</P></BODY></HTML> Tue, 18 Jul 2017 08:11:45 GMT https://community.qlik.com/t5/QlikView/TextBetween-to-eliminate-one-number/m-p/1324539#M613546 antoniotiman 2017-07-18T08:11:45Z