topic Re: Strip Away Extra Character in QlikView https://community.qlik.com/t5/QlikView/Strip-Away-Extra-Character/m-p/604619#M1105438 <HTML><HEAD></HEAD><BODY><P>See attached.</P><P></P><P>subfield(YourFieldName, '*', 2)</P></BODY></HTML> Fri, 04 Apr 2014 19:44:02 GMT 2014-04-04T19:44:02Z Strip Away Extra Character https://community.qlik.com/t5/QlikView/Strip-Away-Extra-Character/m-p/604617#M1105436 <HTML><HEAD></HEAD><BODY><P>How do you strip away a character that precedes the data in a field? Example: Item_No field has items, all in the format *12345. I want to remove the * at the load.</P><P></P><P>Thanks.</P><P></P><P>Jeff</P></BODY></HTML> Fri, 04 Apr 2014 19:39:15 GMT https://community.qlik.com/t5/QlikView/Strip-Away-Extra-Character/m-p/604617#M1105436 jmonroe918 2014-04-04T19:39:15Z Re: Strip Away Extra Character https://community.qlik.com/t5/QlikView/Strip-Away-Extra-Character/m-p/604618#M1105437 <HTML><HEAD></HEAD><BODY><P>use purgechar() function</P><P>purgechar(Item_No, '*') as Item_No</P></BODY></HTML> Fri, 04 Apr 2014 19:43:10 GMT https://community.qlik.com/t5/QlikView/Strip-Away-Extra-Character/m-p/604618#M1105437 Anonymous 2014-04-04T19:43:10Z Re: Strip Away Extra Character https://community.qlik.com/t5/QlikView/Strip-Away-Extra-Character/m-p/604619#M1105438 <HTML><HEAD></HEAD><BODY><P>See attached.</P><P></P><P>subfield(YourFieldName, '*', 2)</P></BODY></HTML> Fri, 04 Apr 2014 19:44:02 GMT https://community.qlik.com/t5/QlikView/Strip-Away-Extra-Character/m-p/604619#M1105438 2014-04-04T19:44:02Z Re: Strip Away Extra Character https://community.qlik.com/t5/QlikView/Strip-Away-Extra-Character/m-p/604620#M1105439 <HTML><HEAD></HEAD><BODY><P>Thank you Michael.</P></BODY></HTML> Fri, 04 Apr 2014 20:12:18 GMT https://community.qlik.com/t5/QlikView/Strip-Away-Extra-Character/m-p/604620#M1105439 jmonroe918 2014-04-04T20:12:18Z Re: Strip Away Extra Character https://community.qlik.com/t5/QlikView/Strip-Away-Extra-Character/m-p/604621#M1105440 <HTML><HEAD></HEAD><BODY><P>No problem, here is another way, just starting from the 2nd position of the string:</P><P>mid(Item_No, 2) as Item_No</P></BODY></HTML> Fri, 04 Apr 2014 20:13:47 GMT https://community.qlik.com/t5/QlikView/Strip-Away-Extra-Character/m-p/604621#M1105440 Anonymous 2014-04-04T20:13:47Z