topic Re: Trim to a Space in QlikView https://community.qlik.com/t5/QlikView/Trim-to-a-Space/m-p/352255#M492417 <HTML><HEAD></HEAD><BODY><P>Perfect guys, thanks very much for your help!</P></BODY></HTML> Mon, 16 Jul 2012 12:50:52 GMT 2012-07-16T12:50:52Z Trim to a Space https://community.qlik.com/t5/QlikView/Trim-to-a-Space/m-p/352251#M492413 <HTML><HEAD></HEAD><BODY><P>I am looking to trim a field storing postcodes, the issue im having is that i dont want to specify the trim to a set number of characters as some first parts of a post code can be 2,3 or 4 characters long.</P><P></P><P>Is it possilbe to trim until it reaches a space, so for example</P><P></P><P>B1 2AA = B1</P><P>B12 3AA = B12</P><P>BE12 4BB = BE12</P><P></P><P>Any help would be greatly apreciated...</P></BODY></HTML> Mon, 16 Jul 2012 12:21:04 GMT https://community.qlik.com/t5/QlikView/Trim-to-a-Space/m-p/352251#M492413 2012-07-16T12:21:04Z Re: Trim to a Space https://community.qlik.com/t5/QlikView/Trim-to-a-Space/m-p/352252#M492414 <HTML><HEAD></HEAD><BODY><P>Maybe</P><P></P><P><EM>LOAD</EM></P><P><EM>...</EM></P><P><EM>subfield(POSTCODEFIELD, ' ',1) as TrimmedPostcodes,</EM></P><P><EM>...</EM></P></BODY></HTML> Mon, 16 Jul 2012 12:23:46 GMT https://community.qlik.com/t5/QlikView/Trim-to-a-Space/m-p/352252#M492414 swuehl 2012-07-16T12:23:46Z Re: Trim to a Space https://community.qlik.com/t5/QlikView/Trim-to-a-Space/m-p/352253#M492415 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Probably the easiest way to get it is</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13424414523282812" jivemacro_uid="_13424414523282812"><P>SubField(Postcode, ' ', 1) AS FirstPart,</P><P>SubField(Postcode, ' ', 2) AS SecondPart</P></PRE><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Mon, 16 Jul 2012 12:24:04 GMT https://community.qlik.com/t5/QlikView/Trim-to-a-Space/m-p/352253#M492415 Miguel_Angel_Baeyens 2012-07-16T12:24:04Z Re: Trim to a Space https://community.qlik.com/t5/QlikView/Trim-to-a-Space/m-p/352254#M492416 <HTML><HEAD></HEAD><BODY><P>try this</P><P>trim(left(str,index(str,' ')))</P></BODY></HTML> Mon, 16 Jul 2012 12:24:06 GMT https://community.qlik.com/t5/QlikView/Trim-to-a-Space/m-p/352254#M492416 2012-07-16T12:24:06Z Re: Trim to a Space https://community.qlik.com/t5/QlikView/Trim-to-a-Space/m-p/352255#M492417 <HTML><HEAD></HEAD><BODY><P>Perfect guys, thanks very much for your help!</P></BODY></HTML> Mon, 16 Jul 2012 12:50:52 GMT https://community.qlik.com/t5/QlikView/Trim-to-a-Space/m-p/352255#M492417 2012-07-16T12:50:52Z