Replace characters in String

[Excel User]

Hi,

I'm trying to replace special characters in a string before inserting into a
database, but cannot this to work, could some please help.

sMyString = "blah, blah blah's +"

with sMyString
.Replace(sMyString, "+", "and")
.Replace(sMyString, "&", "and")
end with

 

[Bob Barrows]

Hi,

I'm trying to replace special characters in a string before inserting
into a database, but cannot this to work, could some please help.

sMyString = "blah, blah blah's +"

with sMyString
.Replace(sMyString, "+", "and")
.Replace(sMyString, "&", "and")
end with

strings are not objects so they do not have methods that can be called
using the dot-notation. VBscript has a function called replace which
accepts a string as the first argument, does the replacement and returns
a new string. Here is how it should be used:

sMyString=Replace(sMyString, "+", "and")
sMyString=Replace(sMyString, "&", "and")

 

[Excel User]

Thanks Bob,

I was just looking for a more efficient way of using the replace function.