I have a phone number like (416)123-45-67*007,
I want to reaplce the second hyphen with a NULL string("")
(because it's a obvious mistake in a telephone number),
what would you do to solve the problem?
(hint: you can not use the real number like 45,67 as
your search symbol, because I have a lot of different
numbers like this, I need a general solution)
dim sVariable as string
sVariable = "(416)123-45-67*007"