Replace Speech Marks

[JasGun]

I have imported a text file from a in-house Database.
One of the fields has various speech marks before after and in between the string e.g.

"Help Me"
"""Help Me"""
""Help" Me"

I could write a write a proceedure to get rid of any other charaters apart from the Special characters.

Does anyone have any ideas.

 

[MichaelRed]

If (VB6) Then
[tab]Replace this, that
Else
[tab]'Back to the old procedure
End If

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over

 

[chiph]

JasGun -

You can also use ADO command parameters, which will take care of not only the double-quotes, but single quotes " ' " as well.

I posted an example of this yesterday in this forum.

Chip H.