Example: How to parse and map multiple fields from 1 excel cell

by trolleymusic

JavaScript

const addresses = [
  'Elizabeth Bay NSW 2011',
  'Sydney NSW 2000',
  'St Kilda VIC 3182',
  'Middle Park QLD 4047',
  'The Big Pineapple QLD 4559',
  'Uluru NT 0872',
  'Sausage 1234567890'
]

const reg = /([\w\s]+)\s([A-Z]{2,3})\s(\d{4})/

const matches = addresses.map(address => {
  const match = address.match(reg)
  return match && match.slice(1)
})

console.log(matches)