[pchelpers] Re: Phone list data
- From: John Durham <john.modec@xxxxxxxxxx>
- To: pchelpers@xxxxxxxxxxxxx
- Date: Tue, 04 May 2010 07:30:02 +1200
On 28/02/2010 2:12 p.m., pccowboy wrote:
> I'm making a phone territory for the Hall.
> I got a program that gives me the address and phone number of a street.
> But the data is in this format:
>
> "Name","Address","City","State","ZIP/Postal","Phone","BusCode","BusOrRes","SolicitFlag","BusType","Last
> Name","First Name","Middle Initial","Suffix","Secondary
> Name","URL","Country"
> "Hill Harold","1213 W 1st
> St","Hereford","TX","79045","806-363-1183","","R","","","Hill","Harold","","","","","US"
> "Jones Twyla","1201 W 1st
> St","Hereford","TX","79045","806-364-1253","","R","","","Jones","Twyla","","","","","US"
> "Walker Sally","1217 W 1st
> St","Hereford","TX","79045","806-364-5163","","R","","","Walker","Sally","","","","","US"
>
> How do I make this data usable without having to delete by hand all the
> "",, and rearranging everything.
>
> I see that it has sorted by names instead of house numbers.
>
> Dallas
I suspect this format (comma delimited) can be imported into Excel and
worked with there. Once imported it may be possible to sort it according
to the most important column.
Have you tried it?
--
Regards, John Durham <http://modecideas.com/contact.html?sig>
ICQ number 571215671 Fax/Phone 64 4 5286786
PC-HELPERS list subscribe/unsub at http://modecideas.com/discuss.htm?sig
Blog http://pc-tech-upper-hutt.blogspot.com/
Get a copy of my novel entitled "Return" at
http://stores.lulu.com/store.php?fAcctID=1382737
Good advice is like good paint- it only works if applied.
--
I am using the free version of SPAMfighter.
We are a community of 7 million users fighting spam.
SPAMfighter has removed 68 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len
The Professional version does not have this message
--
-------list-services-below-----------
Regards, John Durham (list moderator) <http://modecideas.com/contact.html?sig>
Freelists login at //www.freelists.org/cgi-bin/lsg2.cgi
List archives at //www.freelists.org/archives/pchelpers
PC-HELPERS list subscribe/unsub at http://modecideas.com/discuss.htm?sig
Latest news live feeds at http://modecideas.com/indexhomenews.htm?sig
Good advice is like good paint- it only works if applied.
Other related posts:
