4 Replies Latest reply: Jul 16, 2012 8:50 AM by lewiscooksey RSS

    Trim to a Space

      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.

       

      Is it possilbe to trim until it reaches a space, so for example

       

      B1 2AA = B1

      B12 3AA = B12

      BE12 4BB = BE12

       

      Any help would be greatly apreciated...