Replace Function in VB

[Xcelsoft]

Hello,

Is there a Replace function in VB that would allow you to
replace certain characters in a text string. I now you
can use the Left, Mid and Right functions but the
characters may not always be in the same position on each
record. Example

Imported Data = (999)999-9999 or 1(999) 999-9999 or 999-
999-9999.

I want to remove the ()'s and the -.

Any help will be appreciated.

Thanks,

 

[Douglas J. Steele]

Access 2000 and newer have a Replace function.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vafctreplace.asp

 

[Xcelsoft]

Many thanks, I kept trying to find it in the Help
function to no avail. I figured there had to be a
Replace function available or something similar.

Again,

Thanks