Replace Function in VB

  • Thread starter Thread starter Xcelsoft
  • Start date Start date
X

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,
 
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
 
Back
Top