Working with fields containing commas makes using traditional CSV (comma-separated values) very tricky. In preparation of loading the data into a Google map, you’re going to need to reformat the list you’re starting with into a format that looks like this: Anne Marie Palmer:123 Songbird Lane:Winchester, VA 22601:(123) 456-7890 (home):(123) 567-8901 (mobile) These observations should prove very useful. In the unlabeled example above, you might notice that four of the lines include numbers, one has an sign and the last has neither of these things.
Overall, labels are helpful, but they are not always needed. You might also have some entries where no email address is included. If other entries have only five - maybe no home or mobile number - your parsing has to be a little more complicated. (123) 567-8901 of these entries has six lines. Does each entry in the address list have the same numbers of lines? Are the lines labelled in some way? Are the fields in the same order? Here are two examples: A labeled listing Name: Anne Marie PalmerĮmail: An unlabeled listing Anne Marie Palmer
The first thing you should do is examine the list of addresses and determine how consistent it is. Say you have an address list for some organization that you belong to and you want to see how geographically dispersed the members are. Click on some markers and make sure it works as expected - as in the example below.Upload the information from the CSV file or spreadsheet onto the map.Put the extracted fields into a CSV (comma-separated value) or related format that Google maps can use.Parse the address list to pull out the relevant information.
0 kommentar(er)
