Remove spaces

[Ezekiël]

Hi everyone,

Can somebody help me with a code that removes spaces within text.

I've many fields which i would like to examine for double values. The
problem is that there are sometimes spaces involved in text. When looking
for doubles, the result would be different.

E.g.:

value in field 1 = "too late"
value in field 2 = "toolate"
value in field 3 = " too late"

Can somebody help me to resolve this?

 

[Randy Harris]

Hi everyone,

Can somebody help me with a code that removes spaces within text.

I've many fields which i would like to examine for double values. The
problem is that there are sometimes spaces involved in text. When looking
for doubles, the result would be different.

E.g.:

value in field 1 = "too late"
value in field 2 = "toolate"
value in field 3 = " too late"

Can somebody help me to resolve this?

The Replace function will remove the spaces for you.

?Replace(" too late ", " ", "")
"toolate"

 

[Michel Walsh]

Hi,



? Replace(" too late ", " ", "" )
toolate

Replace exists in VBA6, but with Access 2000, you have to rollup your
own cover function in VBA in order to be able to call it in a query. There
is no problem in 2002 or 2003.

For Access2000, define something like:

Public Function MyOwnReplace( Arg1 As String, Arg2 As string, Arg3 As
String ) As String
MyOwnReplace=Replace(Arg1, Arg2, Arg3)'
End Function



and use MyOneReplace(myFields, " ", "" ) in a query.


Hoping it may help,
Vanderghast, Access MVP

 

[Douglas J. Steele]

Shouldn't that be

Public Function MyOwnReplace( Arg1 As Variant, Arg2 As string, Arg3 As
String ) As String

to handle the possibility of a null field in what you're passing to the
function?