How do I remove an embedded Double quotes

[Guest]

Hello:

I am reading from a CSV file into a variable.

The variable reads as ""My data"" since the file contains "My data"

How do I get rid of the embedded double quotes?

I tried
myString.Replace(chr(34), "")

It did not work even though Chr(34) occurs at 0 and 8.

Help would be appreciated.

venki

 

[Jay B. Harlow]

vvenk

myString.Replace(chr(34), "")

String.Replace is a function that returns a new value with any replacements.

Have you tried:

myString = myString.Replace(chr(34), "")

 

[Guest]

Jay:

How dumb could I be for overlooking such a simple mistake?

You are a Godsend! Thanks you.

venki