Removing spaces from string

[davetek]

Hi,

I have a string in the format '001 555 2391'.

I want to convert this to 0015552391.

Any suggestions?

Thanks.

 

[PHV]

Something like this ?
newString = Replace(oldString, " ", "")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[davetek]

using access97 and replace function isn't there unfortunately.

 

[fredericofonseca]

create your own function then.

thread701-952372 will give one example similar to what you need. others exist that have exactly what you need.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com