Text String

  • Thread starter Thread starter Garry Fitzgerald
  • Start date Start date
G

Garry Fitzgerald

Hi all

Is there a way to find and strip out postcodes that appear in many fields.

I want to end up with address fields and a postcode only field

postcodes such as CF10 XXX or CF4 XXX

many thanks
 
String functions such as Left(), Right(), Mid(), InStr(), and Len() can
assist you with this kind of manipulation.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text field in Access query is blank 8
Query help 1
Query table using criteria from an Excel document 2
Appending null data and moving! 4
Remove certain characters from a text string 6
Subject: transferring address postcodes to another table 2
Finding and deleting dupe queries across two fields 6
Splitting a large field up into six new fields 3

Back
Top