https://community.qlik.com/t5/QlikView/Deleting-First-word/m-p/232095#M83767 <HTML><HEAD></HEAD><BODY><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />mid(Product,5) as Product</PRE></BLOCKQUOTE><BR /><BR /> <P>where product is your field. and 5 is the 1st character you want to read in. you can use an expression to get this number if you had</P><P>hamster bites<BR />hamster food<BR />hamster biscuits</P><P>in the same table then you have something like,</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR /><BR />mid(product,if(left(product,3) ='Dog',5,9)) as Product<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P></P><P></P></BODY></HTML> Fri, 08 Oct 2010 12:30:55 GMT 2010-10-08T12:30:55Z https://community.qlik.com/t5/QlikView/Deleting-First-word/m-p/232093#M83765 <HTML><HEAD></HEAD><BODY><P>Hey guys.</P><P></P><P>I needa delete the first word in a field in the script so when the data is reloaded then they all change. e.g</P><P></P><P>Dog Biscuits</P><P>Dog Bites</P><P>Dog Food</P><P></P><P>I need to delete dog. How do I go abt doing that?</P><P></P><P>Thanks in advance</P></BODY></HTML> Fri, 08 Oct 2010 12:23:07 GMT https://community.qlik.com/t5/QlikView/Deleting-First-word/m-p/232093#M83765 2010-10-08T12:23:07Z https://community.qlik.com/t5/QlikView/Deleting-First-word/m-p/232094#M83766 <HTML><HEAD></HEAD><BODY><P>Use MID( FIELD , LEN(SUBFIELD( FIELD , ' ' , 1 )+1 )</P><P>Search for these functions to see more details / options</P></BODY></HTML> Fri, 08 Oct 2010 12:29:53 GMT https://community.qlik.com/t5/QlikView/Deleting-First-word/m-p/232094#M83766 fernandotoledo 2010-10-08T12:29:53Z https://community.qlik.com/t5/QlikView/Deleting-First-word/m-p/232095#M83767 <HTML><HEAD></HEAD><BODY><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />mid(Product,5) as Product</PRE></BLOCKQUOTE><BR /><BR /> <P>where product is your field. and 5 is the 1st character you want to read in. you can use an expression to get this number if you had</P><P>hamster bites<BR />hamster food<BR />hamster biscuits</P><P>in the same table then you have something like,</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR /><BR />mid(product,if(left(product,3) ='Dog',5,9)) as Product<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P></P><P></P></BODY></HTML> Fri, 08 Oct 2010 12:30:55 GMT https://community.qlik.com/t5/QlikView/Deleting-First-word/m-p/232095#M83767 2010-10-08T12:30:55Z