How do I remove an embedded Double quotes

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
vvenk
myString.Replace(chr(34), "")
Click to expand...
String.Replace is a function that returns a new value with any replacements.

Have you tried:

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

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

You are a Godsend! Thanks you.

venki
 
Back
Top