IMPORTING TEXT DATA

[Bill C]

I get emails from a service I use, it gives me client profiles in emails that
vary in size and lenght (foregoing zonal OCR) the data in these unstructured
emails I would like to extract are separated by semicolons as follows on
different zones of the email:

Company Name: Jones Furniture
Name: Betty Jones
Title: Office Manager
Address: 123 Main Street
City: Home town
State: AL
zip: 12345

I want to be able to export this data to either Outlook or ACT 2005, I can
print to TIF (with a printer driver I purchased) and then OCR using Office
2003 Imaging or I can print to hard copy and then OCR. The problem I am
having is that, when I import into Excel (an in between step, in order to be
able to export to the previously mentioned applications) using the
semi-colon, space and tab settings the title, address and any other data
field with a space formats into separate columns. This makes the data
useless, can anyone help with this unstructured data problem?

[Nick]

If you want the data either side of the colon to be in separate columns in
the excel file then use the Other delimiter option and type : in the box.
This will split the data at the colon.

Nick

"Bill C" <Bill C@discussions.microsoft.com> wrote in message
news:31D9789E-6E9C-49A2-AE96-9D839F5414C5@microsoft.com...
>I get emails from a service I use, it gives me client profiles in emails
>that
> vary in size and lenght (foregoing zonal OCR) the data in these
> unstructured
> emails I would like to extract are separated by semicolons as follows on
> different zones of the email:
>
> Company Name: Jones Furniture
> Name: Betty Jones
> Title: Office Manager
> Address: 123 Main Street
> City: Home town
> State: AL
> zip: 12345
>
> I want to be able to export this data to either Outlook or ACT 2005, I can
> print to TIF (with a printer driver I purchased) and then OCR using Office
> 2003 Imaging or I can print to hard copy and then OCR. The problem I am
> having is that, when I import into Excel (an in between step, in order to
> be
> able to export to the previously mentioned applications) using the
> semi-colon, space and tab settings the title, address and any other data
> field with a space formats into separate columns. This makes the data
> useless, can anyone help with this unstructured data problem?