O
Oliver Wong
Joe Attardi said:Yes but, now we know what all the data means. Your example is quite
clear, but what about this one:
Lawrence,David,Maynard,MA
Ah, obviously a list of 4 arbitrary strings, i.e. (in SQL terms):
CREATE TABLE foo {
bar VARCHAR(255)
}
INSERT INTO foo VALUES ("Lawrence"),("David"),("Maynard"),("MA").
Could mean several things:
(1) Lawrence David lives in Maynard, MA.
Oops, okay, it's one record. Well, maybe it means.
Lawrence D. Maynard, who has an Masters in Arts. (Or perhaps it uses last
name first, i.e. David M. Lawrence, Masters in Arts).
Or maybe (s)he's a Medical Assitant? Or (s)he lives in Madagascar?
(2) David Lawrence lives in Maynard, MA
(3) David Maynard lives in Lawrence, MA
(4) Maynard David lives in Lawrence, MA
etc. You see where I'm going with this.
Hmm, looks like I was way off... Not being an American, I am not
familiar with American city names, nor American State abbreviations. If only
you had used XML!
- Oliver