topic Re: Text Between Function in QlikView

topic Re: Text Between Function in QlikView https://community.qlik.com/t5/QlikView/Text-Between-Function/m-p/1091#M195 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>=SubField('aaaa_ddd_222_555_jacac','_',-2)</P></BODY></HTML> Mon, 15 Jan 2018 17:19:34 GMT el_aprendiz111 2018-01-15T17:19:34Z Text Between Function https://community.qlik.com/t5/QlikView/Text-Between-Function/m-p/1090#M194 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>i need your help with the next issue :</P><P> i need to get the number between the third and the fourth      "_"  ( 555)</P><P></P><P>for example :</P><P></P><P>aaaa_ddd_222_555_jacac</P><P></P><P>somtimes it can be 3 chars and somtimes even 5 or 6 .</P><P></P><P>Thanks</P><P>Roee</P></BODY></HTML> Mon, 15 Jan 2018 17:15:07 GMT https://community.qlik.com/t5/QlikView/Text-Between-Function/m-p/1090#M194 roee1983 2018-01-15T17:15:07Z Re: Text Between Function https://community.qlik.com/t5/QlikView/Text-Between-Function/m-p/1091#M195 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>=SubField('aaaa_ddd_222_555_jacac','_',-2)</P></BODY></HTML> Mon, 15 Jan 2018 17:19:34 GMT https://community.qlik.com/t5/QlikView/Text-Between-Function/m-p/1091#M195 el_aprendiz111 2018-01-15T17:19:34Z