topic Re: Trim last two characters in QlikView https://community.qlik.com/t5/QlikView/Trim-last-two-characters/m-p/315132#M1185420 <HTML><HEAD></HEAD><BODY><P>That is strange. Attached is a sample application that does what you want, trims 2 characters from the right.</P><P>Press Ctrl + E inside the app to see the script.</P></BODY></HTML> Fri, 11 Nov 2011 21:33:55 GMT Alexander_Thor 2011-11-11T21:33:55Z Trim last two characters https://community.qlik.com/t5/QlikView/Trim-last-two-characters/m-p/315129#M1185417 <HTML><HEAD></HEAD><BODY><P>Trying to trim the last 2 characters (could be text or number) from a field with a variable number of total characters.&nbsp; Could be staring with 200000WS and want 200000 as the result, or 789ABC123456YT4X and want 789ABC12345YT as the result.&nbsp; Will index work for this?&nbsp; I thought<SPAN style="text-decoration: underline;"> Left ([Item_number], index([Item-number],'')-2)</SPAN> might do it by jumping back 2 spaces from the the first balnk (the end of the string) but it returns the whole string.</P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT https://community.qlik.com/t5/QlikView/Trim-last-two-characters/m-p/315129#M1185417 Anonymous 2020-11-20T18:02:30Z Trim last two characters https://community.qlik.com/t5/QlikView/Trim-last-two-characters/m-p/315130#M1185418 <HTML><HEAD></HEAD><BODY><P>Try left(YourField, len(YourField)-2)</P></BODY></HTML> Fri, 11 Nov 2011 18:56:42 GMT https://community.qlik.com/t5/QlikView/Trim-last-two-characters/m-p/315130#M1185418 Alexander_Thor 2011-11-11T18:56:42Z Trim last two characters https://community.qlik.com/t5/QlikView/Trim-last-two-characters/m-p/315131#M1185419 <HTML><HEAD></HEAD><BODY><P> No, it doesn't seem to work either.&nbsp; I still get the entire field.</P></BODY></HTML> Fri, 11 Nov 2011 20:53:35 GMT https://community.qlik.com/t5/QlikView/Trim-last-two-characters/m-p/315131#M1185419 Anonymous 2011-11-11T20:53:35Z Re: Trim last two characters https://community.qlik.com/t5/QlikView/Trim-last-two-characters/m-p/315132#M1185420 <HTML><HEAD></HEAD><BODY><P>That is strange. Attached is a sample application that does what you want, trims 2 characters from the right.</P><P>Press Ctrl + E inside the app to see the script.</P></BODY></HTML> Fri, 11 Nov 2011 21:33:55 GMT https://community.qlik.com/t5/QlikView/Trim-last-two-characters/m-p/315132#M1185420 Alexander_Thor 2011-11-11T21:33:55Z Trim last two characters https://community.qlik.com/t5/QlikView/Trim-last-two-characters/m-p/315133#M1185421 <HTML><HEAD></HEAD><BODY><P> Thanks a bunch Alexander, I got it.</P></BODY></HTML> Fri, 11 Nov 2011 21:46:00 GMT https://community.qlik.com/t5/QlikView/Trim-last-two-characters/m-p/315133#M1185421 Anonymous 2011-11-11T21:46:00Z