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.

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.
.

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.
.

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.
.

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.
.

Without some distinct way of determining where fields should start and end it
seems to me that expressing some sort of rule to properly separate fields in
a high percentage of records would be rather complex. And even then, you
probably would have some anomalous records that would get by.

Sorry, but my advise is either do it line by line (manually) or, if you are
sufficiently skilled in macro writing, write a macro that can handle most
situation (looking for numbers, capital letter, etc.) and then go through the
result and fix what's left manually.

I wish I could be more help.

"robinsgate" wrote:

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.
.

Your response confirms what I've known to this point: there's no easy way of
doing this. But, I appreciate your interest; thanks for trying to help.

"roadkill" wrote:

Without some distinct way of determining where fields should start and end it
seems to me that expressing some sort of rule to properly separate fields in
a high percentage of records would be rather complex. And even then, you
probably would have some anomalous records that would get by.

Sorry, but my advise is either do it line by line (manually) or, if you are
sufficiently skilled in macro writing, write a macro that can handle most
situation (looking for numbers, capital letter, etc.) and then go through the
result and fix what's left manually.

I wish I could be more help.

"robinsgate" wrote:

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.
.