7 Replies Latest reply: Dec 17, 2010 8:00 AM by David Carlin RSS

    How to get length of field before 1st space

      Hi

      I am trying to use Postcode lookups to add an area to the data I am analysing.

      If I use Left string I get most of the fields matched up but I need to remove the text after the space in the post code to get a full match.

      Eg Left 4 on N1 4TH will not match to N1 as it is coming over as N1 4 which isn''t a match to my postcode lookup

      If I use Left 3 I will not match the postcodes that are 4 digits eg NN44

      Anyone know how to strip the text after the 1st blank space...I am thinking of using length upto the space then using this as the left statement.

      Thankyou for any assistance you can offer.

       

      cheers