Re: SF Bay Area transit schedules for Palm handhelds?

Article View: alt.comp.sys.palmtops.pilot

Article #103

Back to alt.comp.sys.palmtops.pilot Previous Next

#103

From: modorney
Date: Mon, 16 Oct 2000 00:00

19 lines
1915 bytes

Michael Edson wrote:

> Boy, I'm confused about all of this.  What I've been doing is going to
> the muni online schedules, saving them as htm files, opening them in
> Word; doing multiple search and replaces to delete the multiple spaces
> between the columns and replace them with tabs; then converting the whole
> deal to a table; then converting the table to an Excel doc;

One trick I do for these schedules is to:
1. Copy from the html page and paste to a text file (stuff.txt)
2. Import that text file into Excel, using whitespace as a delimiter
3. Using simple macros in Excel to clean up all the blank spaces, rearrange
columns,
change the times to a consistent format (6:02 AM to 0602a, etc.)
4. Then download to palm format.

By doing all the macros in Excel, I can remember them as well as save them.

-- mike

Technical Details

Message-ID: <39EB29FC.DB15481B@aol.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References:

<MPG.145224d333fa0847989685@netnews.worldnet.att.net> <Y5tG5.82757$g6.36615963@news2.rdc2.tx.home.com> <MPG.1454839914fb596b989685@news-server.neo.rr.com> <MPG.1454639aa96c9d6e989686@netnews.worldnet.att.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fd3ff,8af39655c7caee3e
X-Google-Attributes: gidfd3ff,public
X-Google-Thread: 112073,8af39655c7caee3e
X-Google-Attributes: gid112073,public
X-Google-Thread: 11219a,8af39655c7caee3e
X-Google-Attributes: gid11219a,public
From: modorney@aol.com
Subject: Re: SF Bay Area transit schedules for Palm handhelds?
Date: 2000/10/16
Message-ID: <39EB29FC.DB15481B@aol.com>
X-Deja-AN: 682111262
Content-Transfer-Encoding: 7bit
References: <MPG.145224d333fa0847989685@netnews.worldnet.att.net> <Y5tG5.82757$g6.36615963@news2.rdc2.tx.home.com> <MPG.1454839914fb596b989685@news-server.neo.rr.com> <MPG.1454639aa96c9d6e989686@netnews.worldnet.att.net>
X-Accept-Language: en,pdf
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: newsmaster@intuit.com
X-Trace: news.intuit.com 971713014 27375 208.157.255.3 (16 Oct 2000 16:16:54 GMT)
Organization: Intuit Inc
Mime-Version: 1.0
NNTP-Posting-Date: 16 Oct 2000 16:16:54 GMT
Newsgroups: alt.comp.sys.palmtops.pilot,ba.transportation,comp.sys.palmtops.pilot

Reply to Parent Message