Update Question

[Guest]

Hello

I have a field which contains the following:

ABC . 123
CDE 456
FGHIK. 789

and i would like to update as below:

ABC123
CDE456
FGHIK789

Any suggestions?? Thanks a million.

 

[Brendan Reynolds]

So you want to remove spaces and full stops? You can do that with the
Replace function in an Update query ...

UPDATE YourTableName SET YourFieldName = Replace(Replace(YourFieldName, " ",
""), ".", "") WHERE YourFieldName IS NOT NULL

 

[Guest]

Thanks alot. It works if the field contains one full stop, but if the field
contains more than one full stop, the new update still leave the full stop
there.

Any good advice??

 

[John Vinson]

Thanks alot. It works if the field contains one full stop, but if the field
contains more than one full stop, the new update still leave the full stop
there.

Any good advice??

If this is a one-time operation, just keep rerunning the query until
it's done.

John W. Vinson[MVP]

 

[Brendan Reynolds]

The example I posted will remove all spaces and full stops from the
specified field. You must have modified it in some way. If you post your
modified SQL statement, perhaps it might be possible to see what the problem
is.