topic Re: substring in macro in QlikView https://community.qlik.com/t5/QlikView/substring-in-macro/m-p/407146#M151451 <HTML><HEAD></HEAD><BODY><P>right('"LR 1",1) or replace("LR 1","LR","") or see <A href="http://www.w3schools.com/vbscript/vbscript_ref_functions.asp#string">here</A> if there's a function that matches your needs.</P></BODY></HTML> Tue, 05 Mar 2013 09:02:40 GMT Gysbert_Wassenaar 2013-03-05T09:02:40Z substring in macro https://community.qlik.com/t5/QlikView/substring-in-macro/m-p/407145#M151450 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>I am using a macro readin and writing in excel. I have a number in excel that looks like this: LR 1 </P><P>now in my macro I am saving this LR 1 in a variable and then I want to split the number and just save the 1 and ignore the LR cause I need to add a number to the 1</P><P>can someone help me?</P><P></P><P>regards,</P><P>MT</P></BODY></HTML> Tue, 05 Mar 2013 08:58:00 GMT https://community.qlik.com/t5/QlikView/substring-in-macro/m-p/407145#M151450 2013-03-05T08:58:00Z Re: substring in macro https://community.qlik.com/t5/QlikView/substring-in-macro/m-p/407146#M151451 <HTML><HEAD></HEAD><BODY><P>right('"LR 1",1) or replace("LR 1","LR","") or see <A href="http://www.w3schools.com/vbscript/vbscript_ref_functions.asp#string">here</A> if there's a function that matches your needs.</P></BODY></HTML> Tue, 05 Mar 2013 09:02:40 GMT https://community.qlik.com/t5/QlikView/substring-in-macro/m-p/407146#M151451 Gysbert_Wassenaar 2013-03-05T09:02:40Z