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...
 
Back
Top