A aedislee New member Local time Today, 17:23 Joined Feb 12, 2015 Messages 4 Feb 12, 2015 #1 Good afternoon all I have a table with about 29,000 postcode values I want to extraxct the first part of the field (usually 3 or 4 characters) how can I automate this please? thanks lee
Good afternoon all I have a table with about 29,000 postcode values I want to extraxct the first part of the field (usually 3 or 4 characters) how can I automate this please? thanks lee
pbaldy Wino Moderator Staff member Local time Today, 09:23 Joined Aug 30, 2003 Messages 36,272 Feb 12, 2015 #2 How do you know whether to get 3 or 4 characters?
C CJ_London Super Moderator Staff member Local time Today, 17:23 Joined Feb 19, 2013 Messages 17,570 Feb 12, 2015 #3 Assuming the postcode is in its own field and there is always a space between the first and second parts the you can use firstpart=left(postcode,instr(postcode," ")-1)
Assuming the postcode is in its own field and there is always a space between the first and second parts the you can use firstpart=left(postcode,instr(postcode," ")-1)
