Thread: How can i get rid off the double quote in a text
View Single Post
  #2 (permalink)  
Old January 21st, 2005, 04:54 AM
Vadivel Vadivel is offline
Friend of Wrox
  
Join Date: Dec 2004
Posts: 307
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Vadivel Send a message via Yahoo to Vadivel
Default
Below code replaces double quotes with single quotes:

Dim strMyVariable As String
strMyVariable = "D""souza"
strMyVariable = Replace(strMyVariable, Chr(34), Chr(39))
MsgBox "Output :: " & Trim(strMyVariable)

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com
Reply With Quote