A data munging example

• Input:

Auckland:
Graeme Barker        grabar@xtra.co.nz        027 555 1234
Martin Fenwick       m.fenwick@clear.net.nz   021 555 5432

Waikato:
Fiona Winters        fiwi@mooloo.net.nz       021 555 8113
Justin Hiraka        justinh@xtra.co.nz       027 555 289

Hawkes Bay:
Michael Teller       mike.teller@bay.net.nz   027 555 9753

• Output:

INSERT INTO dealer VALUES (
  'Graeme', 'Barker', 'grabar@xtra.co.nz',
  '027 555 1234', 'Auckland'
);