topic Re: extract in QlikView https://community.qlik.com/t5/QlikView/extract/m-p/401566#M149422 <HTML><HEAD></HEAD><BODY><P>Hi. As far as I know, there is no way to access object properties from the application rather than VBScript module.</P><P></P><P>Where are you planning to place that piece of code? Can you give us further info?</P></BODY></HTML> Mon, 05 Nov 2012 12:03:20 GMT diegofcaivano 2012-11-05T12:03:20Z extract https://community.qlik.com/t5/QlikView/extract/m-p/401565#M149421 <HTML><HEAD></HEAD><BODY><P>hi friends ,'</P><P></P><P>I have Object id like OTG123456_1</P><P></P><P>i need to extract only OTG123456</P><P></P><P>pls its Urgent</P></BODY></HTML> Mon, 05 Nov 2012 11:51:36 GMT https://community.qlik.com/t5/QlikView/extract/m-p/401565#M149421 janardhan 2012-11-05T11:51:36Z Re: extract https://community.qlik.com/t5/QlikView/extract/m-p/401566#M149422 <HTML><HEAD></HEAD><BODY><P>Hi. As far as I know, there is no way to access object properties from the application rather than VBScript module.</P><P></P><P>Where are you planning to place that piece of code? Can you give us further info?</P></BODY></HTML> Mon, 05 Nov 2012 12:03:20 GMT https://community.qlik.com/t5/QlikView/extract/m-p/401566#M149422 diegofcaivano 2012-11-05T12:03:20Z Re: extract https://community.qlik.com/t5/QlikView/extract/m-p/401567#M149423 <HTML><HEAD></HEAD><BODY><P>use subfield('OTG123456_1','_',1)</P></BODY></HTML> Mon, 05 Nov 2012 12:07:14 GMT https://community.qlik.com/t5/QlikView/extract/m-p/401567#M149423 sivarajs 2012-11-05T12:07:14Z Re: extract https://community.qlik.com/t5/QlikView/extract/m-p/401568#M149424 <HTML><HEAD></HEAD><BODY><P>hope it help you</P><P>If you have a field like&nbsp; you can do it for the field</P><P>name of your field FIELD value xxxxx_x, yyyyy_y</P><P>=SubField(FIELD,'_',1)</P><P>=SubField(OTG123456_1,'_',1)</P><P></P><P>Hope it help you</P></BODY></HTML> Mon, 05 Nov 2012 12:11:00 GMT https://community.qlik.com/t5/QlikView/extract/m-p/401568#M149424 fdelacal 2012-11-05T12:11:00Z