M
Mark Simons
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.
:
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.