How to remove double quotes in a file name?

[laredo512]

Hi,

 

I got a DB that contains file names. For some unknown reason, some of the entries contain a double quote ( " ).

 

Using the replace function, I eliminated all other invalid characters from the names and the only one remaining is that darn double quote.

 

How would I use the name = replace(name, """, "") ?

 

Thanks

[IngisKahn]

"""" - two doule-quotes is the escape sequence for double-quotes in VB and In C# literal strings.

[laredo512]

"""" - two doule-quotes is the escape sequence for double-quotes in VB and In C# literal strings.

thanks for the information