4 Replies Latest reply: Nov 11, 2011 4:46 PM by Jonathan Love RSS

    Trim last two characters

    Jonathan Love

      Trying to trim the last 2 characters (could be text or number) from a field with a variable number of total characters.  Could be staring with 200000WS and want 200000 as the result, or 789ABC123456YT4X and want 789ABC12345YT as the result.  Will index work for this?  I thought Left ([Item_number], index([Item-number],'')-2) might do it by jumping back 2 spaces from the the first balnk (the end of the string) but it returns the whole string.