topic Substring In Macro in QlikView https://community.qlik.com/t5/QlikView/Substring-In-Macro/m-p/457373#M170733 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am trying to implement a macro that does a field selection, based on a list of items in a variable.</P><P>Consequently the variable in question will be a string where the items are seperated by ','.</P><P></P><P>I tried achieving this through a substring creation.</P><P>THat way I get the count of items, as well as can extract the items individually.</P><P>Qlikview does not accept the standard macro commands 'Substring' or 'SubStr' .</P><P></P><P>How can this substring search be done in a Qlikview macro ?</P><P></P><P>Thank you</P></BODY></HTML> Thu, 20 Dec 2012 15:05:39 GMT 2012-12-20T15:05:39Z Substring In Macro https://community.qlik.com/t5/QlikView/Substring-In-Macro/m-p/457373#M170733 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am trying to implement a macro that does a field selection, based on a list of items in a variable.</P><P>Consequently the variable in question will be a string where the items are seperated by ','.</P><P></P><P>I tried achieving this through a substring creation.</P><P>THat way I get the count of items, as well as can extract the items individually.</P><P>Qlikview does not accept the standard macro commands 'Substring' or 'SubStr' .</P><P></P><P>How can this substring search be done in a Qlikview macro ?</P><P></P><P>Thank you</P></BODY></HTML> Thu, 20 Dec 2012 15:05:39 GMT https://community.qlik.com/t5/QlikView/Substring-In-Macro/m-p/457373#M170733 2012-12-20T15:05:39Z Re: Substring In Macro https://community.qlik.com/t5/QlikView/Substring-In-Macro/m-p/457374#M170734 <HTML><HEAD></HEAD><BODY><P>You can use the instr function. Instr("Hello, World!",",") returns 6 which is the position of the comma in the string. Something else you can use is the activedocument.Evaluate function which allows you to evaluate qlikview expressions.&nbsp; activedocument.Evaluate("subfield('Hello, World!',',',1)") returns "Hello".</P></BODY></HTML> Thu, 20 Dec 2012 15:20:48 GMT https://community.qlik.com/t5/QlikView/Substring-In-Macro/m-p/457374#M170734 Gysbert_Wassenaar 2012-12-20T15:20:48Z