REPLACE blank space in field.

[sal21]

In field NOME of Acces table i can have, see the txt attached.

The first value is the surname and second is the name.
Naturally from name and surname i need one only space

How to delete the "surplus" spcace from name and surname and maintain only one?

Naturally dont check if in the field are the surname and name with only one space.

[Claude]

without having looked at your attachment, I think you're trying to get rid of "white spaces" which http://www.editpadpro.com/; an editor I've bought and used for decades, does exactly that in no time at all.

[sal21]

without having looked at your attachment, I think you're trying to get rid of "white spaces" which http://www.editpadpro.com/; an editor I've bought and used for decades, does exactly that in no time at all.

but I refer my post on a field in Access table.

I have post a question in:
Portal » Board index ‹ Office Applications ‹ Access/SQL

[HansV]

You can run an update query:

Code: Select all

UPDATE Test1 SET Nome = Replace(Replace(Replace([Nome],"  "," *"),"* ",""),"*","");

[sal21]

You can run an update query:

Code: Select all

UPDATE Test1 SET Nome = Replace(Replace(Replace([Nome],"  "," *"),"* ",""),"*","");

as usual your code work fine!

But instead to use a query, my real question is:

i get a string data with:

PRES = Trim(mid(MyString, 10, 50))

is possible to check if in PRES are present more of 2 space in data string, and delete the "surplus" space before to insert PReS in filed?

e

[HansV]

You can use

Code: Select all

PRES = Replace(Replace(Replace(Trim(Mid(MyString, 10, 50)),"  "," *"),"* ",""),"*","")

[sal21]

You can use

Code: Select all

PRES = Replace(Replace(Replace(Trim(Mid(MyString, 10, 50)),"  "," *"),"* ",""),"*","")

no words!
work perfect.
Tks.