lets say i have a string like this
string = "david,a1, a2, ""a3,a4,a5,a6"",a7,a8"
i want to replace the two double quotes with a single quote like this
string = "david,a1, a2, "a3,a4,a5,a6",a7,a8"
any idea on how to do this in vba.......for some reason i cant figure it out
You need extra double quotes
try this to see hoe it works:
Please Login or Register to view this content.
Best Regards,
Kaper
Or witch ascii code:
Please Login or Register to view this content.
Please Login or Register to view this content.
yep that was it..........
i have never understood how many quotes to put to get two quotes together.......is there some logic to it?
basically - during assignment two outer (first and last) enclose whole string and then in the string each doublequote is represented by two
singledoublequotestring = """" when you print, msgbox etc -> "
doubledoublequotestring = """""" -> ""
tripledoublequotestring = """""""" -> """
etc.
Last edited by Kaper; 06-17-2015 at 10:17 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks