remove the first space from the following Postcodes

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

Garry

Hi all, How can I remove the first space from the following Postcodes :
B 1 0FD or B 3 1GF

thanks Garry
 
Backup the database and try this --
IIF(Right(Left([Postcodes]),2),1)=" ", Left([Postcodes],1) &
Mid([Postcodes],3)
 
Too fast on post --
Backup the database and try this --
IIF(Right(Left([Postcodes]),2),1)=" ", Left([Postcodes],1) &
Mid([Postcodes],3), [Postcodes])

--
KARL DEWEY
Build a little - Test a little


KARL DEWEY said:
Backup the database and try this --
IIF(Right(Left([Postcodes]),2),1)=" ", Left([Postcodes],1) &
Mid([Postcodes],3)

--
KARL DEWEY
Build a little - Test a little


Garry said:
Hi all, How can I remove the first space from the following Postcodes :
B 1 0FD or B 3 1GF

thanks Garry
Click to expand...
Click to expand...
 
Spot on Karl, thanks for your time. You have saved me hours of manual work.
cheers



KARL DEWEY said:
Too fast on post --
Backup the database and try this --
IIF(Right(Left([Postcodes]),2),1)=" ", Left([Postcodes],1) &
Mid([Postcodes],3), [Postcodes])

--
KARL DEWEY
Build a little - Test a little


KARL DEWEY said:
Backup the database and try this --
IIF(Right(Left([Postcodes]),2),1)=" ", Left([Postcodes],1) &
Mid([Postcodes],3)

--
KARL DEWEY
Build a little - Test a little


Garry said:
Hi all, How can I remove the first space from the following Postcodes :
B 1 0FD or B 3 1GF

thanks Garry
Click to expand...
Click to expand...
Click to expand...
 
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

Remove duplicate information in different fields 3
Use Replace function to reduce postcode to postcode region 11
Merge 2 columns into one. 5
search specific postcodes 3
Remove certain characters from a text string 6
How do I now add an extra space to Access field in Customer dbase 2
List of all and complete UK Postcodes 4
Excel Excel Web Query on URL: DirectGov PostCode not working 1

Back
Top