topic Referencing VBScript functions in QlikView https://community.qlik.com/t5/QlikView/Referencing-VBScript-functions/m-p/163127#M36349 <HTML><HEAD></HEAD><BODY><P>hmm,</P><P>many vbscript functions have an equivilant in QV</P><P>in your case the, instead of Findvalue(str) vbscript function you can use this function:</P><P>--- taken from the inside QV help ----</P><P></P><H4>FindOneOf<A id="findoneof" name="findoneof"></A> ( text , characterset [ , n] )</H4><P style="margin-left:0px;">Returns the position of the n :th occurrence in the string text of any of the characters found in the string characterset . If n is omitted, the position of the first occurrence is returned. If there no matching string is found, 0 is returned.</P><H2>Example:</H2><P style="margin-left:40px;">findoneof( 'my example text string', 'et%s') returns '4 '</P><P style="margin-left:40px;">findoneof( 'my example text string', 'et%s', 3) returns '12 '</P><P style="margin-left:40px;">findoneof( 'my example text string', '¤%&amp;') returns '0 '</P><P style="margin-left:40px;"></P><P style="margin-left:40px;">Mansyno</P></BODY></HTML> Mon, 01 Mar 2010 16:43:33 GMT wizardo 2010-03-01T16:43:33Z Referencing VBScript functions https://community.qlik.com/t5/QlikView/Referencing-VBScript-functions/m-p/163125#M36347 <HTML><HEAD></HEAD><BODY><P>How do your eference VBScript functions in a QlikView table?</P><P></P><P>The VBScript Function is named Findvalue(str)</P></BODY></HTML> Mon, 01 Mar 2010 14:24:30 GMT https://community.qlik.com/t5/QlikView/Referencing-VBScript-functions/m-p/163125#M36347 alan_grn 2010-03-01T14:24:30Z Referencing VBScript functions https://community.qlik.com/t5/QlikView/Referencing-VBScript-functions/m-p/163126#M36348 <HTML><HEAD></HEAD><BODY><P>Hi, I would love to be able to do this. But I'm sorry to let you know you cannot!</P></BODY></HTML> Mon, 01 Mar 2010 15:19:24 GMT https://community.qlik.com/t5/QlikView/Referencing-VBScript-functions/m-p/163126#M36348 tseebach 2010-03-01T15:19:24Z Referencing VBScript functions https://community.qlik.com/t5/QlikView/Referencing-VBScript-functions/m-p/163127#M36349 <HTML><HEAD></HEAD><BODY><P>hmm,</P><P>many vbscript functions have an equivilant in QV</P><P>in your case the, instead of Findvalue(str) vbscript function you can use this function:</P><P>--- taken from the inside QV help ----</P><P></P><H4>FindOneOf<A id="findoneof" name="findoneof"></A> ( text , characterset [ , n] )</H4><P style="margin-left:0px;">Returns the position of the n :th occurrence in the string text of any of the characters found in the string characterset . If n is omitted, the position of the first occurrence is returned. If there no matching string is found, 0 is returned.</P><H2>Example:</H2><P style="margin-left:40px;">findoneof( 'my example text string', 'et%s') returns '4 '</P><P style="margin-left:40px;">findoneof( 'my example text string', 'et%s', 3) returns '12 '</P><P style="margin-left:40px;">findoneof( 'my example text string', '¤%&amp;') returns '0 '</P><P style="margin-left:40px;"></P><P style="margin-left:40px;">Mansyno</P></BODY></HTML> Mon, 01 Mar 2010 16:43:33 GMT https://community.qlik.com/t5/QlikView/Referencing-VBScript-functions/m-p/163127#M36349 wizardo 2010-03-01T16:43:33Z