Unformatted Addresses |
27th Ave, Queens, NY 11102 |
1975 Bathgate Ave, Bronx, NY 10457 |
1242 Abbott Blvd, Fort Lee, NJ 67024 |
899 Teller Ave, Bronx, NY 10451 |
614 59th St, Brooklyn, NY 11220 |
41 W 96th St, New York, NY 10025 |
155 W 2nd Ave, Roselle, NJ 75203 |
17 Windsor Rd, Summit, NJ 57901 |
11 Ashland Rd, Summit, NJ 79016 |
203-18 32nd Ave, Flushing, NY 11361 |
function extractAddresses () { var sheet, range1, range2, range3, range4, range5; var commaPos1, commaPos2, counter; sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); // 27th Ave, Queens, NY 11102 // 01234567890123456789012345 range1 = sheet.getRange(2, 1); range2 = sheet.getRange(2, 2); range3 = sheet.getRange(2, 3); range4 = sheet.getRange(2, 4); range5 = sheet.getRange(2, 5); completeAddressArray = range1.getValues (); completeAddress = completeAddressArray[0][0]; range2.setValue ("Some Address"); range3.setValue ("Some City"); range4.setValue ("Some State"); range5.setValue ("Some Zip"); }