Only the normal address-related stuff:

* For most records, the occurance of the first numeric value indicates the
end of the company name; there will, of course, be anomalies where the
company name includes numeric values.

* The 2 rightmost capitalized alpha characters indicate the state
abbreviation.

Nothing else stands out other than these 2 characteristics.



"roadkill" wrote:

Is there anything at all distinctive about the format of each record that
would allow (with a smart enough algorithm) for proper separation of fields?

"robinsgate" wrote:

Thanks for the suggestion, but the file has variable length records, and has
several thousand records. I'd REALLY rather not parse it one record at a
time.

" wrote:

hi,
you could use the fixed width option but unless all of the
data is the same width that could cause a serious problem.
i don't know how much data you have but you may have to do
it in groups or 1 line at a time. (yuk)

-----Original Message-----
I have a space delimited file that contains address
information. Is there a
way to parse each record so that I parse the records into
specific portions
(Company Name is field 1, Street Address is field 2,
etc.)? Using the space
as a delimiter doesn't help in this instance because
every word is obviously
separated by a space.

Any help with this would be appreciated.

Thanks.
.