topic AW:Characters in QlikView https://community.qlik.com/t5/QlikView/Characters/m-p/216212#M69563 <HTML><HEAD></HEAD><BODY><P>Also:</P><P style="padding-left:30px;">mid(Fieldname,9)<BR />subfield(Fieldname,' ',2) // Still works even if the store lengths are variable</P></BODY></HTML> Thu, 08 Jul 2010 01:33:44 GMT johnw 2010-07-08T01:33:44Z Characters https://community.qlik.com/t5/QlikView/Characters/m-p/216209#M69560 <HTML><HEAD></HEAD><BODY><P>Can anyone please help me. I'm creating a bar chart to show sales and I've got Names of stores here, however, they all start with the same name. It is 7 characters long then a space and then the name. eg.</P><P>Georges Muffins</P><P>And i want to get rid of Georges and just keep Muffins. How do I go about doing that? I have 6 stores.</P><P>Any help will be greatly appreciated.</P><P></P></BODY></HTML> Wed, 07 Jul 2010 08:50:34 GMT https://community.qlik.com/t5/QlikView/Characters/m-p/216209#M69560 2010-07-07T08:50:34Z AW:Characters https://community.qlik.com/t5/QlikView/Characters/m-p/216210#M69561 <HTML><HEAD></HEAD><BODY><P>Hi Blaze,</P><P>here helps the same stringfunction:</P><P>Right(Fieldname,Len(Fieldname)-8)</P></BODY></HTML> Wed, 07 Jul 2010 09:24:56 GMT https://community.qlik.com/t5/QlikView/Characters/m-p/216210#M69561 brenner_martina 2010-07-07T09:24:56Z AW:Characters https://community.qlik.com/t5/QlikView/Characters/m-p/216211#M69562 <HTML><HEAD></HEAD><BODY><P>Awesome thanks so much</P></BODY></HTML> Wed, 07 Jul 2010 09:39:19 GMT https://community.qlik.com/t5/QlikView/Characters/m-p/216211#M69562 2010-07-07T09:39:19Z AW:Characters https://community.qlik.com/t5/QlikView/Characters/m-p/216212#M69563 <HTML><HEAD></HEAD><BODY><P>Also:</P><P style="padding-left:30px;">mid(Fieldname,9)<BR />subfield(Fieldname,' ',2) // Still works even if the store lengths are variable</P></BODY></HTML> Thu, 08 Jul 2010 01:33:44 GMT https://community.qlik.com/t5/QlikView/Characters/m-p/216212#M69563 johnw 2010-07-08T01:33:44Z