topic Re: Remove from field in QlikView https://community.qlik.com/t5/QlikView/Remove-from-field/m-p/1228301#M855367 <HTML><HEAD></HEAD><BODY><P>yeah I have no idea why I chose mid over left</P></BODY></HTML> Mon, 20 Feb 2017 14:59:44 GMT adamdavi3s 2017-02-20T14:59:44Z Remove from field https://community.qlik.com/t5/QlikView/Remove-from-field/m-p/1228298#M855364 <HTML><HEAD></HEAD><BODY><P>‌<SPAN style="font-size: 10pt;">Hi.</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">I am loading data from a table and would like to remove the last ten characters (YYYY-MM-DD) from the field 'Bevakning'. The total length of the string can vary and it can consist of text, numbers or both, separated by blanks, but the last ten characters are always a date formatet as YYYY-MM-DD.</SPAN></P><P></P><P>BEVAKNING</P><P>123 2017-03-01</P><P>Ändra förväntat belopp 2017-02-27</P><P></P><P><SPAN style="font-size: 10pt;">I want it like</SPAN></P><P>BEVAKNING</P><P>123</P><P>Ändra förväntat belopp</P><P></P><P><SPAN style="font-size: 10pt;">Anyone who can help me solve this one?</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Thank you! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></SPAN></P><P>Anna</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Remove-from-field/m-p/1228298#M855364 annanirvin 2020-11-25T16:16:04Z Re: Remove from field https://community.qlik.com/t5/QlikView/Remove-from-field/m-p/1228299#M855365 <HTML><HEAD></HEAD><BODY><P>something like:</P><P></P><P>mid(field,1,len(field)-10)</P></BODY></HTML> Mon, 20 Feb 2017 14:45:29 GMT https://community.qlik.com/t5/QlikView/Remove-from-field/m-p/1228299#M855365 adamdavi3s 2017-02-20T14:45:29Z Re: Remove from field https://community.qlik.com/t5/QlikView/Remove-from-field/m-p/1228300#M855366 <HTML><HEAD></HEAD><BODY><P><STRONG>Left(Field,Len(Field)-10)</STRONG></P></BODY></HTML> Mon, 20 Feb 2017 14:55:19 GMT https://community.qlik.com/t5/QlikView/Remove-from-field/m-p/1228300#M855366 aarkay29 2017-02-20T14:55:19Z Re: Remove from field https://community.qlik.com/t5/QlikView/Remove-from-field/m-p/1228301#M855367 <HTML><HEAD></HEAD><BODY><P>yeah I have no idea why I chose mid over left</P></BODY></HTML> Mon, 20 Feb 2017 14:59:44 GMT https://community.qlik.com/t5/QlikView/Remove-from-field/m-p/1228301#M855367 adamdavi3s 2017-02-20T14:59:44Z Re: Remove from field https://community.qlik.com/t5/QlikView/Remove-from-field/m-p/1228302#M855368 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>Left(Field,Len(Field)-11)&nbsp; // 10 positions to get rid of date + 1 for the leading space</STRONG></SPAN></P></BODY></HTML> Mon, 20 Feb 2017 16:02:51 GMT https://community.qlik.com/t5/QlikView/Remove-from-field/m-p/1228302#M855368 albertovarela 2017-02-20T16:02:51Z Re: Remove from field https://community.qlik.com/t5/QlikView/Remove-from-field/m-p/1228303#M855369 <HTML><HEAD></HEAD><BODY><P>check this </P></BODY></HTML> Mon, 20 Feb 2017 16:11:26 GMT https://community.qlik.com/t5/QlikView/Remove-from-field/m-p/1228303#M855369 aarkay29 2017-02-20T16:11:26Z Re: Remove from field https://community.qlik.com/t5/QlikView/Remove-from-field/m-p/1228304#M855370 <HTML><HEAD></HEAD><BODY><P>Tried again and it worked. Thanks a lot!</P></BODY></HTML> Mon, 20 Feb 2017 18:31:15 GMT https://community.qlik.com/t5/QlikView/Remove-from-field/m-p/1228304#M855370 annanirvin 2017-02-20T18:31:15Z Re: Remove from field https://community.qlik.com/t5/QlikView/Remove-from-field/m-p/1228305#M855371 <HTML><HEAD></HEAD><BODY><P>maybe using</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14876328404536956 jive_text_macro" jivemacro_uid="_14876328404536956"> <P>Trim(Left(BEVAKNING,Len(BEVAKNING)-10)) as BEVAKNING</P> </PRE><P></P><P>to get rid of possible trailing spaces ...</P><P></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Mon, 20 Feb 2017 23:20:46 GMT https://community.qlik.com/t5/QlikView/Remove-from-field/m-p/1228305#M855371 MarcoWedel 2017-02-20T23:20:46Z