Hi I am new to VB. I have an access database that has data that uses the single quote like in (don't) or (g'night).
I have create a procedure that will do a search and replace, Which I thought should be simply search for (') and replace it with (& "'" &), but that just leads to a billion (& "'" &) of these being inserted. Okay maybe it's not that much but it is a lot.
Isn't there an easier way to get around "data" that uses characters that produce errors in "code". I saw an example in Perl on this site but I don't get it how to translate that into VB.
many thanks from the "geek in training"
I have create a procedure that will do a search and replace, Which I thought should be simply search for (') and replace it with (& "'" &), but that just leads to a billion (& "'" &) of these being inserted. Okay maybe it's not that much but it is a lot.
Isn't there an easier way to get around "data" that uses characters that produce errors in "code". I saw an example in Perl on this site but I don't get it how to translate that into VB.
many thanks from the "geek in training"
Comment