The ClevelandDotNet Blog is created to serve all .Net developers, both in Cleveland and elsewhere. Various .Net questions, events, and technical topics of interest will be posted regularly.
To learn more about ClevelandDotNet, visit http://www.ClevelandDotNet.info
Determining if an address is within a radius of a zip code
Q: I need to take a list of vendors and be able to extract those vendors within a mileage of a zip code. For example, list all vendors within 40 miles of 44131. Is there a utility that will facilitate this?
String manipulation in VB2005 is fairly simple. However, things can get a little tricky with the double quote character. How do you look for it in a string? How can you insert into a string? How do you remove it from a string? These are questions that may lead to confusion if you don't know what you're looking for.
Ironically enough, in VB the double quote can also be used as an escape character when searching for it in a string. For example:
Dim strTest As String strTest = """123""" 'Displays "123" (double quotes appear in the final result) strTest = """""123""" 'Displays ""123" (double quotes appear in the final result) strTest = "test\""test" 'Displays test\"test strTest = "test""test" 'Displays test"test
In cases where you want to insert a double quote character, simply reference it unicode character designation, chr(34).…