02-04-2009, 09:37 AM
Hi,
Using Replace(Var,"""",""") will not work as ' " ' is a metacharacter. Hence try converting ' " ' to ASCII value (i think the ASCII value of " is 34 and use Chr(34))
*this code may require some chage.
Using Replace(Var,"""",""") will not work as ' " ' is a metacharacter. Hence try converting ' " ' to ASCII value (i think the ASCII value of " is 34 and use Chr(34))
Code:
vReplace = Chr(34) & Chr(34)
vValue = Replace(Var,vReplace,Chr(34))
*this code may require some chage.