I need to get a macro/vb script/program that can convert something like this
:




CITY OF ST. GEORGE,
UTAH

BUSINESS CONTACT LISTING - ALL
BUSINESSES



BUSINESS NAME LOCATION ADDRESS OPEN DATE
OWNER NAME BUSINESS PHONE

------------------------------ ------------------------------ ---------
------------------------------ --------------

#1 CENTRAL VAC LLC 574 DAMMERON VALLEY DR W 06/15/2005
GARN, BRETT K 4355742222

DAMMERON VALLEY UT 84783

1 CALL SERVICE PROS 511 E ST GEORGE BLVD #G 08/20/2004
KIRKLAND, CASEY 4356888700

ST. GEORGE UT 84770

1001 BUSINESS CARDS INC 60 N 300 E 08/06/2001
OGAARD, LORI 4356741330

ST. GEORGE UT 84770





To convert it to a csv or xls like this :

BusinessName|Address|Date|Owner|Phone|City|ST|ZIP

This way it can be used for mail lists or DB mining.

The city says this is the only way they can export the info..

Any help is appreciated.. If someone would like to write a script to strip
the file I would be interested in that as well.

Thanks.

Mark:

Unless this is hand-written or done on a typewriter, it's probably reported
from a database somewhere. I don't think the City is so stone-age as to
maintain non-computerized records, are they? Somehow they are outputting a
Word-format report. Can the database they are using output a csv report?
I'd check there first.

Ed

"Mark Simons" wrote in message
...

I need to get a macro/vb script/program that can convert something like
this
:




CITY OF ST. GEORGE,
UTAH

BUSINESS CONTACT LISTING -
ALL
BUSINESSES



BUSINESS NAME LOCATION ADDRESS OPEN
DATE
OWNER NAME BUSINESS PHONE

------------------------------ ------------------------------ --------
-
------------------------------ --------------

#1 CENTRAL VAC LLC 574 DAMMERON VALLEY DR W
06/15/2005
GARN, BRETT K 4355742222

DAMMERON VALLEY UT 84783

1 CALL SERVICE PROS 511 E ST GEORGE BLVD #G
08/20/2004
KIRKLAND, CASEY 4356888700

ST. GEORGE UT 84770

1001 BUSINESS CARDS INC 60 N 300 E
08/06/2001
OGAARD, LORI 4356741330

ST. GEORGE UT 84770





To convert it to a csv or xls like this :

BusinessName|Address|Date|Owner|Phone|City|ST|ZIP

This way it can be used for mail lists or DB mining.

The city says this is the only way they can export the info..

Any help is appreciated.. If someone would like to write a script to
strip
the file I would be interested in that as well.

Thanks.