Looking for a program


R

rfdjr1

I run a website for my Son who teaches safe driving to (predominantly)
firefighters around the country. I started it around seven years ago. I am not a
pro at this. I started a list of classes he has taught and update it every time
he teaches. It's grown quite large. It starts with the first classes taught and
scrolls down to the most recent. A friend of mine who is a professional software
guy and writes apps, looked at it and suggested that the list be in reverse,
with the most recent classes being at the top. It would be a daunting task to
redo this whole list manually. I was wondering if there's any program that I
could copy and paste into, and then have it reverse the order? Here's a link to
the page if it helps. I have a feeling that I'll be sitting in front of the
keyboard doing this by hand, but it doesn't hurt to ask. Thanks.

http://www.drivetosurvive.org/past_seminars.htm
 
Ad

Advertisements

T

Tester

Here is your list in reverse order:

Lititz Fire Company, Lititz PA, February, 2012
McConnellsburg Fire Company, Fulton County PA, February, 2012
Waterford Fire Department, Erie County PA, January, 2012
Johnsonburg Fire Department, Elk County PA, January 2012
Mount Troy Fire Department, Pittsburg PA, January, 2012
Burlington Township Fire Department, Burlington County NJ, January, 2012
Henderson High School, West Chester PA, January, 2012
Pottstown Fire Department, Pottstown PA, November, 2011
Haverford Township Fire Department, Havertown PA, November, 2011
Marple Township Police Department, Broomall PA, November, 2011
Woodlawn Fire Department, South Whitehall PA, November, 2011
Greenbrook Fire-EMS, Greenbrook NJ, October, 2011
Pottstown High School, Pottstown PA, October, 2011
Botsworth Fire Rescue, Newtown CT, October, 2011
Princeton Junction Fire Company, Princeton Junction NJ, October, 2011
Sea Bright Fire Department, Sea Bright NJ, September, 2011
Lawrenceville Fire Company, Lawrenceville NJ, May, 2011
Radnor Fire Company, Wayne PA, May, 2011
Essex County College Police Academy, Cedar Grove NJ, May, 2011
Five Points Fire Company, Wilmington DE, May, 2011
Colonia Fire Department, Colonia NJ, May, 2011
First West Chester Fire Company, West Chester PA, April, 2011
Bethel Fire Company, Bethel PA, April, 2011
Manheim Fire Company, Lancaster PA, April, 2011
Linglestown Fire Company, Linglestown PA, March, 2011
Crisdel Construction Group, South Plainfield NJ, March, 2011
Iselin Fire Department, Iselin NJ, March, 2011
Delaware City Fire Company, Delaware City DE, March, 2011
Quarryville Fire Company, Lancaster PA, March, 2011
Bowmansville Fire Company, Buffalo NY, March, 2011
Duncannon EMS, Duncannon PA, March, 2011
Little Rocky Hill Fire Company, Princeton NJ, February, 2011
Avenel Fire Department, Avenel NJ, February, 2011
Liberty Hose Company, Willliamstown PA, February, 2011
Trexlertown Fire Company, Trexlertown PA, January, 2011
Liberty Corner Fire Company, Somerset County NJ, January, 2011
Berkeley Heights Fire Department, Berkeley Heights NJ, January, 2011
Montgomery Township Fire Company No. 2, Princeton NJ, January, 2011
Concordville Fire and Protective Association, Concordville PA, November,
2010
Thornhurst Fire Company, Lackawanna PA, October, 2010
Everett Fire Company, Bedford County PA, October, 2010
West Trenton Fire Company, Mercer County NJ, October, 2010
Eatontown Fire Department, Monmouth NJ, September, 2010
Christiana Fire Company, Christiana PA, September, 2010
Pennsylvania State Firefighters Convention, Luzerne County PA,
September, 2010
Perkasie Fire Company, Perkasie PA, September, 2010
Hockessin Fire Company, Hockessin DE, September, 2010
Aetna Hose, Hook and Ladder Company, Newark DE, June, 2010
East Petersburg Fire Company, Lancaster PA, June, 2010
McConnellsburg Fire Company, Fulton County PA, May, 2010
Reinholds Fire Company, Lancaster PA, May, 2010
Lancaster EMS, Lancaster PA, April, 2010
Oreland Fire Company, Oreland PA, April, 2010
Seelyville Fire Company, Wayne County PA, April, 2010
New Egypt Fire Company, Ocean County NJ, April, 2010
Stafford Township Fire Company, Ocean County NJ, March, 2010
Franklin Fire Company, Chambersburg PA, March, 2010
Hanover Township Volunteer Fire Company, Bethlehem PA, March, 2010
Pioneer Fire Company, Ephrata PA, February, 2010
Laurys Station Fire Company, Laurys Station PA, February, 2010
Topton Fire Company, Topton PA, February, 2010
Upper Saucon Fire Department, Upper Saucon PA, February, 2010
Lower Merion Fire Department, Gladwyne PA, February, 2010
Medford Farms Fire Company, Tabernacle NJ, February, 2010
Penryn Fire Company, Lancaster PA, February, 2010
Bradford Township Fire Department, McKean County, PA, January, 2010
Breslau Hose Company, Hanover PA, January, 2010
Spring Township Fire Department, West Lawn PA, January, 2010
Bel Air Fire Company, Bel Air MD, November, 2009
Five Points Fire Company, Wilmington DE, November, 2009
Shipley Energy, York PA, November, 2009
Hanover Township Fire Company, Bethlehem PA, November, 2009
Cheltenham Fire Company, Cheltenham PA, October, 2009
Saginaw County Michigan, October, 2009
Paradise Fire Company, Lancaster County PA, October, 2009
West Grove Fire Company, West Grove PA, September, 2009
Newtown Square Fire Company, Newtown Square PA, June, 2009
Berwyn Fire Company, Berwyn PA, June, 2009
Aetna Hose, Hook and Ladder Company, Newark DE, June, 2009
Union Fire Company, Carlisle PA, May, 2009
Chambers Hill Fire Company, Swatara PA, May, 2009
Evesham Township Fire Department, Evesham NJ, May 2009
Goshen Fire Company, West Chester PA, April, 2009
Fire Department Instructor's Conference, Indianapolis IN, April 2009
Millvale Fire Department, Pittsburgh PA, April 2009
Thorndale Fire Company, Chester County PA, April 2009
Port Penn Fire Company, Port Penn DE, March, 2009
Phoenixville Fire Department, Phoenixville PA, March, 2009
Radnor Fire Company, Wayne PA, March, 2009
Progress Fire Company, Dauphi County PA, March, 2009
Virginia State Fire Chief's Conference, Richmond VA, February, 2009
Kinzer Fire Company, Kinzer PA, Fenruary, 2009
Marcus Hook Trainer Fire Department, Marcus Hook PA, February, 2009
Penryn Fire Company, Lancaster County PA, February, 2009
Five Points Fire Company, Wilmington DE, January, 2009
Second Alarmers Rescue Squad, Willow Grove PA, January, 2009
Garrettford Drexel Hill Fire Company, Drexel Hill PA, January, 2009
Lower Allen Fire Company, Cumberland County PA, December, 2008
Lewes Fire Department, Lewes DE, December, 2008
Community Ambulance of Ambler, Ambler PA, December, 2008
Port Penn Fire Company, Port Penn DE, November, 2008
Brandywine Hundred Fire Company, Wilmington DE, November, 2008
District 3 Training Association, New Holland PA, November, 2008
Christiana Fire Company, Christiana DE, November, 2008
Southern Chester County Medical Center, Jennersville PA – October 2008
Hampden Township VFC, Mechanicsburg PA – October 2008
Richlandtown Fire Company, Bucks County PA – October 2008
Lititz FireCompany, Lititz PA – October 2008
Fairview Fire Company, Erie County PA – September 2008
Witmer Fire Company – Witmer PA – September 2008
PECO Energy, Coatesville PA – September 2008
Cheswold Fire Company, Cheswold DE – August 2008
Spring Township Fire Department, Berks County PA – July 2008
Cumberland Valley Volunteer Firefighter’s Assocation Conference – June 2008
Martin’s Corner Fire Company, Coatesville PA – June 2008
Brandywine Valley Heating and Air Conditioning, West Chester PA – May 2008
Central Fire Company, Pittsburgh PA – May 2008
Five Points Fire Company, Wilmington DE – May202008
ACAC Fitness Center, West Chester PA – May 2008
West Hempfield Fire / Rescue, West Hempfield, PA – May 2008
Penn Forest Fire Company, Jim Thorpe PA – April 2008
Walker Township Fire Company, Howard PA – April 2008
Columbia Fire Company, Columbia PA – April 2008
Parkesburg Fire Company, Parkesburg PA – April 2008
Fire Department Instructor’s Conference (FDIC), Indianapolis IN – April 2008
ACAC Fitness Center (civilian class), West Chester PA – April 2008
Goodwill Fire Company of Pemberton, Pemberton NJ – March 2008
City of Hermitage Fire and Rescue, Hermitage PA – March 2008
Aetna Hose, Hook and Ladder Company, Newark DE – March 2008
Ephrata Fire Company, Ephrata PA – March 2008
East Whiteland Fire Company, Frazer PA – March 2008
Ambler Community Ambulance Association, Ambler PA – March 2008
Lancaster PA Fire Chief’s Association, Manheim PA – March 2008
Sassamansville Fire Company, Sassamansville PA – February 2008
Millersville Fire Company, Millersville PA – February 2008
Mont Clare Fire Company, Mont Clare PA – February 2008
City of Manhattan Fire Department, Manhattan KS – November 2007
South Bend IN Regional Airport Fire Department,, South Bend, IN –
October 2007
South Carolina Firefighters Conference, Myrtle Beach SC – July 2007
Whatcom County Fire District #4, Bellingham WA – May 2007
Fire Department Instructor’s Conference (FDIC), Indianapolis, Indiana -
April 2007
Glenside Fire Company, Cheltenham PA – April 2007
Christiana Fire Company, Christiana DE – April 2007
Vandalia Fire Department, Vandalia OH – March 2007
Broomall Fire C ompany, Broomall PA – February 2007
West Chester Regional Emergency Response Team, West Chester PA -
February 2007
Valley Forge Fire Company, Valley Forge PA – February 2007
Keating Fire Company, Pittsburgh PA – September 2006
Marion Fire Department, Marion OH – September 2006
Sloan Ford , Downingtown PA – July 2006
Horsham Fire Company, Horsham PA – July 2006
East Brandywine Fire Company, Glenmoore PA – May 2006
Danby Lumber Company , Kennett Square PA – May 2006
Brandywine Heating and Air Conditioning, West Chester PA – May 2006
Fire Department Instructor’s Conference (FDIC), Indianapolis, Indiana, -
April, 2006
East Goshen Township, East Goshen PA – April 2006
Kennett Square Fire Company, Kennett Square PA – April 2006
Litiz Fire Company, Lititz PA – March 2006
West Chester Fire Department, West Chester PA – March 2006
Hilltown Township Fire Company, Hilltown PA – February 2006
First West Chester Fire Company, West Chester PA – February 2006
Goshen Fire Company, West Chester PA – January, 2006
Lionville Fire Company, Lionville PA – January 2006
Dallastown Fire Company, Dallastown, PA – January 2006
Radnor Fire Company, Wayne PA – November 2005
Firehouse Exposition, Baltimore Maryland - July 29, 2005
 
J

J. P. Gilliver (John)

In message <[email protected]>,
I run a website for my Son who teaches safe driving to (predominantly)
firefighters around the country. I started it around seven years ago. I
am not a
pro at this. I started a list of classes he has taught and update it every time
he teaches. It's grown quite large. It starts with the first classes taught and
scrolls down to the most recent. A friend of mine who is a professional
software
guy and writes apps, looked at it and suggested that the list be in reverse,
with the most recent classes being at the top. It would be a daunting task to
Personally, I don't like the trend to do this: it tends to stop the
oldest parts ever being looked at. Like top-posting, it smacks of
laziness (i. e. people can't be bothered to scroll); also, I think
chronological order makes more plain sense than reverse, in most cases.

However:
redo this whole list manually. I was wondering if there's any program that I
could copy and paste into, and then have it reverse the order? Here's a link to
the page if it helps. I have a feeling that I'll be sitting in front of the
keyboard doing this by hand, but it doesn't hurt to ask. Thanks.

http://www.drivetosurvive.org/past_seminars.htm
having had a look, it looks like just one line per class (I'd assumed
you meant the names of all the "pupils", and was going to raise the
warning about data protection, but you didn't). While I suspect there
are better ways, possibly even editors that can do what you want, I
think it could be done with a spreadsheet like Excel: copy the text
lines into one column (not sure how you'd do that - possibly just
pasting, though you might have to change all the commas to something
else temporarily), add another column that just counts 1, 2, 3 etc. (you
don't have to type them all in - just put 1 in the top cell and "=A1+1"
in A2, and copy that into the rest), then reverse sort on that column,
then export the text column (and reverse the comma substitution if you
had to make it). But, as I said, there's probably an easier way - this
would just be quicker than retyping all of it.
--
J. P. Gilliver. UMRA: 1960/<1985 MB++G.5AL-IS-P--Ch++(p)[email protected]+Sh0!:`)DNAf

"You know what they say. In London you're never more than ten feet away from a
lying politician." The Downing Street rat, "quoted" by Rod Liddle in Radio
Times
 
P

Paul

I run a website for my Son who teaches safe driving to (predominantly)
firefighters around the country. I started it around seven years ago. I am not a
pro at this. I started a list of classes he has taught and update it every time
he teaches. It's grown quite large. It starts with the first classes taught and
scrolls down to the most recent. A friend of mine who is a professional software
guy and writes apps, looked at it and suggested that the list be in reverse,
with the most recent classes being at the top. It would be a daunting task to
redo this whole list manually. I was wondering if there's any program that I
could copy and paste into, and then have it reverse the order? Here's a link to
the page if it helps. I have a feeling that I'll be sitting in front of the
keyboard doing this by hand, but it doesn't hurt to ask. Thanks.

http://www.drivetosurvive.org/past_seminars.htm
I would use a scripting language for that. While PERL is more
powerful (and in terms of job skills, more of an asset on your
resume), I like AWK for its simplicity. A free version is GAWK,
and a port for Windows is available via the Gnuwin32 packages.

http://gnuwin32.sourceforge.net/packages/gawk.htm

First I write a program in AWK (stored in reverse.txt).
The first line has no conditionals on it, so it executes once
for each line of text. It stores the entire input file, into memory,
in the array "x". The variable "NR" is "number of records" and
is an automatic variable. $0 stands for the whole line of text,
while things like $1 stand for the first word in the line and so
on. So the first program line "memorizes" the file by storing it in an
array. This isn't a good idea, if your list is bigger than system
memory :) But since we know the input list is small and finite,
this method is OK.

{x[NR] = $0}

END { while ( NR > 0 ) print x[NR--] }

The second line only executes, when the input file is exhausted
and completely processed. Now, the array is read out in reverse order.
The print statement, just takes whole lines stored in "x" and prints
them. The variable NR is "post-decremented" until it hits zero.

I copied the program from here. but as far as I can remember, this
is actually copied out of the original Awk book (I think it may
have been an example in there).

http://www.unix.com/shell-programming-scripting/35832-reversing-order-lines-file.html

The command I issued in command prompt, looked like this.
Reverse.txt is the script to run, while the other files are for I/O.
(All the files are in the folder with the gawk program, because
I never set these things up properly. I know what files it needs
and just stage them when I have a job to do.)

gawk -f reverse.txt < thelist.txt > revlist.txt

The < and > are for stdin and stdout redirection respectively.
That tells the gawk program to get input from "thelist" and
put the output in "revlist". I can use Notepad to work on
any of those files.

Here is your list, ROT13 encoded. Just do a ROT13 on it, and you
should be ready to go.

There is nothing magic about ROT13. This is just to prevent
a search engine from indexing it directly. Whether they ROT13
stuff for themselves, I don't know.

If your newsreader doesn't have ROT13, you can use www.rot13.com,
paste in the list, and push the button to get the list back. Then,
compare to make sure nothing got corrupted.

****************** revlist.txt ************************
Yvgvgm Sver Pbzcnal, Yvgvgm CN, Sroehnel, 2012
ZpPbaaryyfohet Sver Pbzcnal, Shygba Pbhagl CN, Sroehnel, 2012
Jngresbeq Sver Qrcnegzrag, Revr Pbhagl CN, Wnahnel, 2012
Wbuafbaohet Sver Qrcnegzrag, Ryx Pbhagl CN, Wnahnel 2012
Zbhag Gebl Sver Qrcnegzrag, Cvggfohet CN, Wnahnel, 2012
Oheyvatgba Gbjafuvc Sver Qrcnegzrag, Oheyvatgba Pbhagl AW, Wnahnel, 2012
Uraqrefba Uvtu Fpubby, Jrfg Purfgre CN, Wnahnel, 2012
Cbggfgbja Sver Qrcnegzrag, Cbggfgbja CN, Abirzore, 2011
Uniresbeq Gbjafuvc Sver Qrcnegzrag, Uniregbja CN, Abirzore, 2011
Znecyr Gbjafuvc Cbyvpr Qrcnegzrag, Oebbznyy CN, Abirzore, 2011
Jbbqynja Sver Qrcnegzrag, Fbhgu Juvgrunyy CN, Abirzore, 2011
Terraoebbx Sver-RZF, Terraoebbx AW, Bpgbore, 2011
Cbggfgbja Uvtu Fpubby, Cbggfgbja CN, Bpgbore, 2011
Obgfjbegu Sver Erfphr, Arjgbja PG, Bpgbore, 2011
Cevaprgba Whapgvba Sver Pbzcnal, Cevaprgba Whapgvba AW, Bpgbore, 2011
Frn Oevtug Sver Qrcnegzrag, Frn Oevtug AW, Frcgrzore, 2011
Ynjeraprivyyr Sver Pbzcnal, Ynjeraprivyyr AW, Znl, 2011
Enqabe Sver Pbzcnal, Jnlar CN, Znl, 2011
Rffrk Pbhagl Pbyyrtr Cbyvpr Npnqrzl, Prqne Tebir AW, Znl, 2011
Svir Cbvagf Sver Pbzcnal, Jvyzvatgba QR, Znl, 2011
Pbybavn Sver Qrcnegzrag, Pbybavn AW, Znl, 2011
Svefg Jrfg Purfgre Sver Pbzcnal, Jrfg Purfgre CN, Ncevy, 2011
Orgury Sver Pbzcnal, Orgury CN, Ncevy, 2011
Znaurvz Sver Pbzcnal, Ynapnfgre CN, Ncevy, 2011
Yvatyrfgbja Sver Pbzcnal, Yvatyrfgbja CN, Znepu, 2011
Pevfqry Pbafgehpgvba Tebhc, Fbhgu Cynvasvryq AW, Znepu, 2011
Vfryva Sver Qrcnegzrag, Vfryva AW, Znepu, 2011
Qrynjner Pvgl Sver Pbzcnal, Qrynjner Pvgl QR, Znepu, 2011
Dhneelivyyr Sver Pbzcnal, Ynapnfgre CN, Znepu, 2011
Objznafivyyr Sver Pbzcnal, Ohssnyb AL, Znepu, 2011
Qhapnaaba RZF, Qhapnaaba CN, Znepu, 2011
Yvggyr Ebpxl Uvyy Sver Pbzcnal, Cevaprgba AW, Sroehnel, 2011
Nirary Sver Qrcnegzrag, Nirary AW, Sroehnel, 2011
Yvoregl Ubfr Pbzcnal, Jvyyyvnzfgbja CN, Sroehnel, 2011
Gerkyregbja Sver Pbzcnal, Gerkyregbja CN, Wnahnel, 2011
Yvoregl Pbeare Sver Pbzcnal, Fbzrefrg Pbhagl AW, Wnahnel, 2011
Orexryrl Urvtugf Sver Qrcnegzrag, Orexryrl Urvtugf AW, Wnahnel, 2011
Zbagtbzrel Gbjafuvc Sver Pbzcnal Ab. 2, Cevaprgba AW, Wnahnel, 2011
Pbapbeqivyyr Sver naq Cebgrpgvir Nffbpvngvba, Pbapbeqivyyr CN, Abirzore, 2010
Gubeauhefg Sver Pbzcnal, Ynpxnjnaan CN, Bpgbore, 2010
Rirergg Sver Pbzcnal, Orqsbeq Pbhagl CN, Bpgbore, 2010
Jrfg Geragba Sver Pbzcnal, Zrepre Pbhagl AW, Bpgbore, 2010
Rngbagbja Sver Qrcnegzrag, Zbazbhgu AW, Frcgrzore, 2010
Puevfgvnan Sver Pbzcnal, Puevfgvnan CN, Frcgrzore, 2010
Craaflyinavn Fgngr Sversvtugref Pbairagvba, Yhmrear Pbhagl CN, Frcgrzore, 2010
Crexnfvr Sver Pbzcnal, Crexnfvr CN, Frcgrzore, 2010
Ubpxrffva Sver Pbzcnal, Ubpxrffva QR, Frcgrzore, 2010
Nrgan Ubfr, Ubbx naq Ynqqre Pbzcnal, Arjnex QR, Whar, 2010
Rnfg Crgrefohet Sver Pbzcnal, Ynapnfgre CN, Whar, 2010
ZpPbaaryyfohet Sver Pbzcnal, Shygba Pbhagl CN, Znl, 2010
Ervaubyqf Sver Pbzcnal, Ynapnfgre CN, Znl, 2010
Ynapnfgre RZF, Ynapnfgre CN, Ncevy, 2010
Berynaq Sver Pbzcnal, Berynaq CN, Ncevy, 2010
Frrylivyyr Sver Pbzcnal, Jnlar Pbhagl CN, Ncevy, 2010
Arj Rtlcg Sver Pbzcnal, Bprna Pbhagl AW, Ncevy, 2010
Fgnssbeq Gbjafuvc Sver Pbzcnal, Bprna Pbhagl AW, Znepu, 2010
Senaxyva Sver Pbzcnal, Punzorefohet CN, Znepu, 2010
Unabire Gbjafuvc Ibyhagrre Sver Pbzcnal, Orguyrurz CN, Znepu, 2010
Cvbarre Sver Pbzcnal, Rcuengn CN, Sroehnel, 2010
Ynhelf Fgngvba Sver Pbzcnal, Ynhelf Fgngvba CN, Sroehnel, 2010
Gbcgba Sver Pbzcnal, Gbcgba CN, Sroehnel, 2010
Hccre Fnhpba Sver Qrcnegzrag, Hccre Fnhpba CN, Sroehnel, 2010
Ybjre Zrevba Sver Qrcnegzrag, Tynqjlar CN, Sroehnel, 2010
Zrqsbeq Snezf Sver Pbzcnal, Gnoreanpyr AW, Sroehnel, 2010
Craela Sver Pbzcnal, Ynapnfgre CN, Sroehnel, 2010
Oenqsbeq Gbjafuvc Sver Qrcnegzrag, ZpXrna Pbhagl, CN, Wnahnel, 2010
Oerfynh Ubfr Pbzcnal, Unabire CN, Wnahnel, 2010
Fcevat Gbjafuvc Sver Qrcnegzrag, Jrfg Ynja CN, Wnahnel, 2010
Ory Nve Sver Pbzcnal, Ory Nve ZQ, Abirzore, 2009
Svir Cbvagf Sver Pbzcnal, Jvyzvatgba QR, Abirzore, 2009
Fuvcyrl Raretl, Lbex CN, Abirzore, 2009
Unabire Gbjafuvc Sver Pbzcnal, Orguyrurz CN, Abirzore, 2009
Purygraunz Sver Pbzcnal, Purygraunz CN, Bpgbore, 2009
Fntvanj Pbhagl Zvpuvtna, Bpgbore, 2009
Cnenqvfr Sver Pbzcnal, Ynapnfgre Pbhagl CN, Bpgbore, 2009
Jrfg Tebir Sver Pbzcnal, Jrfg Tebir CN, Frcgrzore, 2009
Arjgbja Fdhner Sver Pbzcnal, Arjgbja Fdhner CN, Whar, 2009
Orejla Sver Pbzcnal, Orejla CN, Whar, 2009
Nrgan Ubfr, Ubbx naq Ynqqre Pbzcnal, Arjnex QR, Whar, 2009
Havba Sver Pbzcnal, Pneyvfyr CN, Znl, 2009
Punzoref Uvyy Sver Pbzcnal, Fjngnen CN, Znl, 2009
Rirfunz Gbjafuvc Sver Qrcnegzrag, Rirfunz AW, Znl 2009
Tbfura Sver Pbzcnal, Jrfg Purfgre CN, Ncevy, 2009
Sver Qrcnegzrag Vafgehpgbe'f Pbasrerapr, Vaqvnancbyvf VA, Ncevy 2009
Zvyyinyr Sver Qrcnegzrag, Cvggfohetu CN, Ncevy 2009
Gubeaqnyr Sver Pbzcnal, Purfgre Pbhagl CN, Ncevy 2009
Cbeg Craa Sver Pbzcnal, Cbeg Craa QR, Znepu, 2009
Cubravkivyyr Sver Qrcnegzrag, Cubravkivyyr CN, Znepu, 2009
Enqabe Sver Pbzcnal, Jnlar CN, Znepu, 2009
Cebterff Sver Pbzcnal, Qnhcuv Pbhagl CN, Znepu, 2009
Ivetvavn Fgngr Sver Puvrs'f Pbasrerapr, Evpuzbaq IN, Sroehnel, 2009
Xvamre Sver Pbzcnal, Xvamre CN, Sraehnel, 2009
Znephf Ubbx Genvare Sver Qrcnegzrag, Znephf Ubbx CN, Sroehnel, 2009
Craela Sver Pbzcnal, Ynapnfgre Pbhagl CN, Sroehnel, 2009
Svir Cbvagf Sver Pbzcnal, Jvyzvatgba QR, Wnahnel, 2009
Frpbaq Nynezref Erfphr Fdhnq, Jvyybj Tebir CN, Wnahnel, 2009
Tneerggsbeq Qerkry Uvyy Sver Pbzcnal, Qerkry Uvyy CN, Wnahnel, 2009
Ybjre Nyyra Sver Pbzcnal, Phzoreynaq Pbhagl CN, Qrprzore, 2008
Yrjrf Sver Qrcnegzrag, Yrjrf QR, Qrprzore, 2008
Pbzzhavgl Nzohynapr bs Nzoyre, Nzoyre CN, Qrprzore, 2008
Cbeg Craa Sver Pbzcnal, Cbeg Craa QR, Abirzore, 2008
Oenaqljvar Uhaqerq Sver Pbzcnal, Jvyzvatgba QR, Abirzore, 2008
Qvfgevpg 3 Genvavat Nffbpvngvba, Arj Ubyynaq CN, Abirzore, 2008
Puevfgvnan Sver Pbzcnal, Puevfgvnan QR, Abirzore, 2008
Fbhgurea Purfgre Pbhagl Zrqvpny Pragre, Wraarefivyyr CN – Bpgbore 2008
Unzcqra Gbjafuvc ISP, Zrpunavpfohet CN – Bpgbore 2008
Evpuynaqgbja Sver Pbzcnal, Ohpxf Pbhagl CN – Bpgbore 2008
Yvgvgm SverPbzcnal, Yvgvgm CN – Bpgbore 2008
Snveivrj Sver Pbzcnal, Revr Pbhagl CN – Frcgrzore 2008
Jvgzre Sver Pbzcnal – Jvgzre CN – Frcgrzore 2008
CRPB Raretl, Pbngrfivyyr CN – Frcgrzore 2008
Purfjbyq Sver Pbzcnal, Purfjbyq QR – Nhthfg 2008
Fcevat Gbjafuvc Sver Qrcnegzrag, Orexf Pbhagl CN – Whyl 2008
Phzoreynaq Inyyrl Ibyhagrre Sversvtugre’f Nffbpngvba Pbasrerapr – Whar 2008
Znegva’f Pbeare Sver Pbzcnal, Pbngrfivyyr CN – Whar 2008
Oenaqljvar Inyyrl Urngvat naq Nve Pbaqvgvbavat, Jrfg Purfgre CN – Znl 2008
Prageny Sver Pbzcnal, Cvggfohetu CN – Znl 2008
Svir Cbvagf Sver Pbzcnal, Jvyzvatgba QR – Znl202008
NPNP Svgarff Pragre, Jrfg Purfgre CN – Znl 2008
Jrfg Urzcsvryq Sver / Erfphr, Jrfg Urzcsvryq, CN – Znl 2008
Craa Sberfg Sver Pbzcnal, Wvz Gubecr CN – Ncevy 2008
Jnyxre Gbjafuvc Sver Pbzcnal, Ubjneq CN – Ncevy 2008
Pbyhzovn Sver Pbzcnal, Pbyhzovn CN – Ncevy 2008
Cnexrfohet Sver Pbzcnal, Cnexrfohet CN – Ncevy 2008
Sver Qrcnegzrag Vafgehpgbe’f Pbasrerapr (SQVP), Vaqvnancbyvf VA – Ncevy 2008
NPNP Svgarff Pragre (pvivyvna pynff), Jrfg Purfgre CN – Ncevy 2008
Tbbqjvyy Sver Pbzcnal bs Crzoregba, Crzoregba AW – Znepu 2008
Pvgl bs Urezvgntr Sver naq Erfphr, Urezvgntr CN – Znepu 2008
Nrgan Ubfr, Ubbx naq Ynqqre Pbzcnal, Arjnex QR – Znepu 2008
Rcuengn Sver Pbzcnal, Rcuengn CN – Znepu 2008
Rnfg Juvgrynaq Sver Pbzcnal, Senmre CN – Znepu 2008
Nzoyre Pbzzhavgl Nzohynapr Nffbpvngvba, Nzoyre CN – Znepu 2008
Ynapnfgre CN Sver Puvrs’f Nffbpvngvba, Znaurvz CN – Znepu 2008
Fnffnznafivyyr Sver Pbzcnal, Fnffnznafivyyr CN – Sroehnel 2008
Zvyyrefivyyr Sver Pbzcnal, Zvyyrefivyyr CN – Sroehnel 2008
Zbag Pyner Sver Pbzcnal, Zbag Pyner CN – Sroehnel 2008
Pvgl bs Znaunggna Sver Qrcnegzrag, Znaunggna XF – Abirzore 2007
Fbhgu Oraq VA Ertvbany Nvecbeg Sver Qrcnegzrag,, Fbhgu Oraq, VA – Bpgbore 2007
Fbhgu Pnebyvan Sversvtugref Pbasrerapr, Zlegyr Ornpu FP – Whyl 2007
Jungpbz Pbhagl Sver Qvfgevpg #4, Oryyvatunz JN – Znl 2007
Sver Qrcnegzrag Vafgehpgbe’f Pbasrerapr (SQVP), Vaqvnancbyvf, Vaqvnan - Ncevy 2007
Tyrafvqr Sver Pbzcnal, Purygraunz CN – Ncevy 2007
Puevfgvnan Sver Pbzcnal, Puevfgvnan QR – Ncevy 2007
Inaqnyvn Sver Qrcnegzrag, Inaqnyvn BU – Znepu 2007
Oebbznyy Sver P bzcnal, Oebbznyy CN – Sroehnel 2007
Jrfg Purfgre Ertvbany Rzretrapl Erfcbafr Grnz, Jrfg Purfgre CN - Sroehnel 2007
Inyyrl Sbetr Sver Pbzcnal, Inyyrl Sbetr CN – Sroehnel 2007
Xrngvat Sver Pbzcnal, Cvggfohetu CN – Frcgrzore 2006
Znevba Sver Qrcnegzrag, Znevba BU – Frcgrzore 2006
Fybna Sbeq , Qbjavatgbja CN – Whyl 2006
Ubefunz Sver Pbzcnal, Ubefunz CN – Whyl 2006
Rnfg Oenaqljvar Sver Pbzcnal, Tyrazbber CN – Znl 2006
Qnaol Yhzore Pbzcnal , Xraargg Fdhner CN – Znl 2006
Oenaqljvar Urngvat naq Nve Pbaqvgvbavat, Jrfg Purfgre CN – Znl 2006
Sver Qrcnegzrag Vafgehpgbe’f Pbasrerapr (SQVP), Vaqvnancbyvf, Vaqvnan, - Ncevy, 2006
Rnfg Tbfura Gbjafuvc, Rnfg Tbfura CN – Ncevy 2006
Xraargg Fdhner Sver Pbzcnal, Xraargg Fdhner CN – Ncevy 2006
Yvgvm Sver Pbzcnal, Yvgvgm CN – Znepu 2006
Jrfg Purfgre Sver Qrcnegzrag, Jrfg Purfgre CN – Znepu 2006
Uvyygbja Gbjafuvc Sver Pbzcnal, Uvyygbja CN – Sroehnel 2006
Svefg Jrfg Purfgre Sver Pbzcnal, Jrfg Purfgre CN – Sroehnel 2006
Tbfura Sver Pbzcnal, Jrfg Purfgre CN – Wnahnel, 2006
Yvbaivyyr Sver Pbzcnal, Yvbaivyyr CN – Wnahnel 2006
Qnyynfgbja Sver Pbzcnal, Qnyynfgbja, CN – Wnahnel 2006
Enqabe Sver Pbzcnal, Jnlar CN – Abirzore 2005
Sverubhfr Rkcbfvgvba, Onygvzber Znelynaq - Whyl 29, 2005
********************************************************

I'm sure you could pull the files into a spreadsheet, and do
stuff to it. Excel is pretty powerful.

Nobody uses GAWK, but I do :)

Gawk could also be used to reorder the fields, such as put
the date first and location second and so on. The "-" character
which is used in the file, makes a convenient delimiter, to break
the lines into two pieces for that kind of manipulation. Maybe
Excel can do the breaks that way as well, if you define a
delimiter in it when pulling in the file.

HTH,
Paul
 
G

Gene E. Bloch

add another column that just counts 1, 2, 3 etc. (you don't have to type
them all in - just put 1 in the top cell and "=A1+1" in A2, and copy that
into the rest),
Or use the fill down command.

Or even just Ctrl-drag a cell with a 1 in it...

Assuming Excel, but any other spreadsheet program can probably do it
just as easily.
 
P

Paul in Houston TX

I run a website for my Son who teaches safe driving to (predominantly)
firefighters around the country. I started it around seven years ago. I am not a
pro at this. I started a list of classes he has taught and update it every time
he teaches. It's grown quite large. It starts with the first classes taught and
scrolls down to the most recent. A friend of mine who is a professional software
guy and writes apps, looked at it and suggested that the list be in reverse,
with the most recent classes being at the top. It would be a daunting task to
redo this whole list manually. I was wondering if there's any program that I
could copy and paste into, and then have it reverse the order? Here's a link to
the page if it helps. I have a feeling that I'll be sitting in front of the
keyboard doing this by hand, but it doesn't hurt to ask. Thanks.

http://www.drivetosurvive.org/past_seminars.htm
It's a simple matter for a txt dump into Excel, then txt back out.
Tester has already fixed this for you, however, in the future
it would be good to be consistent in format.
Always put the comma or other delimiter in the same place
on each line.
 
Ad

Advertisements

R

richard

I run a website for my Son who teaches safe driving to (predominantly)
firefighters around the country. I started it around seven years ago. I am not a
pro at this. I started a list of classes he has taught and update it every time
he teaches. It's grown quite large. It starts with the first classes taught and
scrolls down to the most recent. A friend of mine who is a professional software
guy and writes apps, looked at it and suggested that the list be in reverse,
with the most recent classes being at the top. It would be a daunting task to
redo this whole list manually. I was wondering if there's any program that I
could copy and paste into, and then have it reverse the order? Here's a link to
the page if it helps. I have a feeling that I'll be sitting in front of the
keyboard doing this by hand, but it doesn't hurt to ask. Thanks.

http://www.drivetosurvive.org/past_seminars.htm
Nothing wrong with the way it is. Could use a seperator between the years.
Perhaps use a table and use different colors as background.
Another idea might be to use a folding menu.
Level 1= year
Or even a dropdown box menu.
 
R

richard

It's a simple matter for a txt dump into Excel, then txt back out.
Tester has already fixed this for you, however, in the future
it would be good to be consistent in format.
Always put the comma or other delimiter in the same place
on each line.
why is a spread sheet being the way to do a simple thing?
have you people looked at the code those things add on that are not
necessary?
I have. Most of the code they use PER CODE LINE is outrageous!
Most of which is out of date and depricated.
A file that should be 10kb in size, is now a whopping 640kb simply due to
the excessive tags in the code.
 
P

Paul

richard said:
why is a spread sheet being the way to do a simple thing?
have you people looked at the code those things add on that are not
necessary?
I have. Most of the code they use PER CODE LINE is outrageous!
Most of which is out of date and depricated.
A file that should be 10kb in size, is now a whopping 640kb simply due to
the excessive tags in the code.
You don't need to keep the temporary file you create in Excel.
Pull in the text, change the order, and copy it out again,
then throw it away.

All we care about is tricks. It's up to the OP to decide
if he has the tools to do these things, whether it is too
complicated, whether it's achieving the stated objective
and so on. For us, it's just a source of fun.

If I was doing it, I'd put the date first, then the other text.
Since it's a "chronology", the date is the important factor,
and the dates show the relative frequency the courses were given.
Who took the courses is harder to draw trends from, for the viewer
(unless they happen to know all the named parties).

Paul
 
R

richard

I run a website for my Son who teaches safe driving to (predominantly)
firefighters around the country. I started it around seven years ago. I am not a
pro at this. I started a list of classes he has taught and update it every time
he teaches. It's grown quite large. It starts with the first classes taught and
scrolls down to the most recent. A friend of mine who is a professional software
guy and writes apps, looked at it and suggested that the list be in reverse,
with the most recent classes being at the top. It would be a daunting task to
redo this whole list manually. I was wondering if there's any program that I
could copy and paste into, and then have it reverse the order? Here's a link to
the page if it helps. I have a feeling that I'll be sitting in front of the
keyboard doing this by hand, but it doesn't hurt to ask. Thanks.

http://www.drivetosurvive.org/past_seminars.htm
http://1littleworld.net/classes1.html

just tossed this together to show one way of doing it.
 
V

VanguardLH

I run a website for my Son who teaches safe driving to (predominantly)
firefighters around the country. I started it around seven years ago. I am not a
pro at this. I started a list of classes he has taught and update it every time
he teaches. It's grown quite large. It starts with the first classes taught and
scrolls down to the most recent. A friend of mine who is a professional software
guy and writes apps, looked at it and suggested that the list be in reverse,
with the most recent classes being at the top. It would be a daunting task to
redo this whole list manually. I was wondering if there's any program that I
could copy and paste into, and then have it reverse the order? Here's a link to
the page if it helps. I have a feeling that I'll be sitting in front of the
keyboard doing this by hand, but it doesn't hurt to ask. Thanks.

http://www.drivetosurvive.org/past_seminars.htm
Paste the list into MS Excel, OpenOffice Calc, or any spreadsheet. Then
change the sort order. Paste resorted list back into the web page or
wherever it is sourced at the web site.
 
Ad

Advertisements

R

rfdjr1

Here is your list in reverse order:

Lititz Fire Company, Lititz PA, February, 2012
McConnellsburg Fire Company, Fulton County PA, February, 2012
Waterford Fire Department, Erie County PA, January, 2012
Johnsonburg Fire Department, Elk County PA, January 2012
Mount Troy Fire Department, Pittsburg PA, January, 2012
Burlington Township Fire Department, Burlington County NJ, January, 2012
Henderson High School, West Chester PA, January, 2012
Pottstown Fire Department, Pottstown PA, November, 2011
Haverford Township Fire Department, Havertown PA, November, 2011
Marple Township Police Department, Broomall PA, November, 2011
Woodlawn Fire Department, South Whitehall PA, November, 2011
Greenbrook Fire-EMS, Greenbrook NJ, October, 2011
Pottstown High School, Pottstown PA, October, 2011
Botsworth Fire Rescue, Newtown CT, October, 2011
Princeton Junction Fire Company, Princeton Junction NJ, October, 2011
Sea Bright Fire Department, Sea Bright NJ, September, 2011
Lawrenceville Fire Company, Lawrenceville NJ, May, 2011
Radnor Fire Company, Wayne PA, May, 2011
Essex County College Police Academy, Cedar Grove NJ, May, 2011
Five Points Fire Company, Wilmington DE, May, 2011
Colonia Fire Department, Colonia NJ, May, 2011
First West Chester Fire Company, West Chester PA, April, 2011
Bethel Fire Company, Bethel PA, April, 2011
Manheim Fire Company, Lancaster PA, April, 2011
Linglestown Fire Company, Linglestown PA, March, 2011
Crisdel Construction Group, South Plainfield NJ, March, 2011
Iselin Fire Department, Iselin NJ, March, 2011
Delaware City Fire Company, Delaware City DE, March, 2011
Quarryville Fire Company, Lancaster PA, March, 2011
Bowmansville Fire Company, Buffalo NY, March, 2011
Duncannon EMS, Duncannon PA, March, 2011
Little Rocky Hill Fire Company, Princeton NJ, February, 2011
Avenel Fire Department, Avenel NJ, February, 2011
Liberty Hose Company, Willliamstown PA, February, 2011
Trexlertown Fire Company, Trexlertown PA, January, 2011
Liberty Corner Fire Company, Somerset County NJ, January, 2011
Berkeley Heights Fire Department, Berkeley Heights NJ, January, 2011
Montgomery Township Fire Company No. 2, Princeton NJ, January, 2011
Concordville Fire and Protective Association, Concordville PA, November,
2010
Thornhurst Fire Company, Lackawanna PA, October, 2010
Everett Fire Company, Bedford County PA, October, 2010
West Trenton Fire Company, Mercer County NJ, October, 2010
Eatontown Fire Department, Monmouth NJ, September, 2010
Christiana Fire Company, Christiana PA, September, 2010
Pennsylvania State Firefighters Convention, Luzerne County PA,
September, 2010
Perkasie Fire Company, Perkasie PA, September, 2010
Hockessin Fire Company, Hockessin DE, September, 2010
Aetna Hose, Hook and Ladder Company, Newark DE, June, 2010
East Petersburg Fire Company, Lancaster PA, June, 2010
McConnellsburg Fire Company, Fulton County PA, May, 2010
Reinholds Fire Company, Lancaster PA, May, 2010
Lancaster EMS, Lancaster PA, April, 2010
Oreland Fire Company, Oreland PA, April, 2010
Seelyville Fire Company, Wayne County PA, April, 2010
New Egypt Fire Company, Ocean County NJ, April, 2010
Stafford Township Fire Company, Ocean County NJ, March, 2010
Franklin Fire Company, Chambersburg PA, March, 2010
Hanover Township Volunteer Fire Company, Bethlehem PA, March, 2010
Pioneer Fire Company, Ephrata PA, February, 2010
Laurys Station Fire Company, Laurys Station PA, February, 2010
Topton Fire Company, Topton PA, February, 2010
Upper Saucon Fire Department, Upper Saucon PA, February, 2010
Lower Merion Fire Department, Gladwyne PA, February, 2010
Medford Farms Fire Company, Tabernacle NJ, February, 2010
Penryn Fire Company, Lancaster PA, February, 2010
Bradford Township Fire Department, McKean County, PA, January, 2010
Breslau Hose Company, Hanover PA, January, 2010
Spring Township Fire Department, West Lawn PA, January, 2010
Bel Air Fire Company, Bel Air MD, November, 2009
Five Points Fire Company, Wilmington DE, November, 2009
Shipley Energy, York PA, November, 2009
Hanover Township Fire Company, Bethlehem PA, November, 2009
Cheltenham Fire Company, Cheltenham PA, October, 2009
Saginaw County Michigan, October, 2009
Paradise Fire Company, Lancaster County PA, October, 2009
West Grove Fire Company, West Grove PA, September, 2009
Newtown Square Fire Company, Newtown Square PA, June, 2009
Berwyn Fire Company, Berwyn PA, June, 2009
Aetna Hose, Hook and Ladder Company, Newark DE, June, 2009
Union Fire Company, Carlisle PA, May, 2009
Chambers Hill Fire Company, Swatara PA, May, 2009
Evesham Township Fire Department, Evesham NJ, May 2009
Goshen Fire Company, West Chester PA, April, 2009
Fire Department Instructor's Conference, Indianapolis IN, April 2009
Millvale Fire Department, Pittsburgh PA, April 2009
Thorndale Fire Company, Chester County PA, April 2009
Port Penn Fire Company, Port Penn DE, March, 2009
Phoenixville Fire Department, Phoenixville PA, March, 2009
Radnor Fire Company, Wayne PA, March, 2009
Progress Fire Company, Dauphi County PA, March, 2009
Virginia State Fire Chief's Conference, Richmond VA, February, 2009
Kinzer Fire Company, Kinzer PA, Fenruary, 2009
Marcus Hook Trainer Fire Department, Marcus Hook PA, February, 2009
Penryn Fire Company, Lancaster County PA, February, 2009
Five Points Fire Company, Wilmington DE, January, 2009
Second Alarmers Rescue Squad, Willow Grove PA, January, 2009
Garrettford Drexel Hill Fire Company, Drexel Hill PA, January, 2009
Lower Allen Fire Company, Cumberland County PA, December, 2008
Lewes Fire Department, Lewes DE, December, 2008
Community Ambulance of Ambler, Ambler PA, December, 2008
Port Penn Fire Company, Port Penn DE, November, 2008
Brandywine Hundred Fire Company, Wilmington DE, November, 2008
District 3 Training Association, New Holland PA, November, 2008
Christiana Fire Company, Christiana DE, November, 2008
Southern Chester County Medical Center, Jennersville PA – October 2008
Hampden Township VFC, Mechanicsburg PA – October 2008
Richlandtown Fire Company, Bucks County PA – October 2008
Lititz FireCompany, Lititz PA – October 2008
Fairview Fire Company, Erie County PA – September 2008
Witmer Fire Company – Witmer PA – September 2008
PECO Energy, Coatesville PA – September 2008
Cheswold Fire Company, Cheswold DE – August 2008
Spring Township Fire Department, Berks County PA – July 2008
Cumberland Valley Volunteer Firefighter’s Assocation Conference – June 2008
Martin’s Corner Fire Company, Coatesville PA – June 2008
Brandywine Valley Heating and Air Conditioning, West Chester PA – May 2008
Central Fire Company, Pittsburgh PA – May 2008
Five Points Fire Company, Wilmington DE – May202008
ACAC Fitness Center, West Chester PA – May 2008
West Hempfield Fire / Rescue, West Hempfield, PA – May 2008
Penn Forest Fire Company, Jim Thorpe PA – April 2008
Walker Township Fire Company, Howard PA – April 2008
Columbia Fire Company, Columbia PA – April 2008
Parkesburg Fire Company, Parkesburg PA – April 2008
Fire Department Instructor’s Conference (FDIC), Indianapolis IN – April 2008
ACAC Fitness Center (civilian class), West Chester PA – April 2008
Goodwill Fire Company of Pemberton, Pemberton NJ – March 2008
City of Hermitage Fire and Rescue, Hermitage PA – March 2008
Aetna Hose, Hook and Ladder Company, Newark DE – March 2008
Ephrata Fire Company, Ephrata PA – March 2008
East Whiteland Fire Company, Frazer PA – March 2008
Ambler Community Ambulance Association, Ambler PA – March 2008
Lancaster PA Fire Chief’s Association, Manheim PA – March 2008
Sassamansville Fire Company, Sassamansville PA – February 2008
Millersville Fire Company, Millersville PA – February 2008
Mont Clare Fire Company, Mont Clare PA – February 2008
City of Manhattan Fire Department, Manhattan KS – November 2007
South Bend IN Regional Airport Fire Department,, South Bend, IN –
October 2007
South Carolina Firefighters Conference, Myrtle Beach SC – July 2007
Whatcom County Fire District #4, Bellingham WA – May 2007
Fire Department Instructor’s Conference (FDIC), Indianapolis, Indiana -
April 2007
Glenside Fire Company, Cheltenham PA – April 2007
Christiana Fire Company, Christiana DE – April 2007
Vandalia Fire Department, Vandalia OH – March 2007
Broomall Fire C ompany, Broomall PA – February 2007
West Chester Regional Emergency Response Team, West Chester PA -
February 2007
Valley Forge Fire Company, Valley Forge PA – February 2007
Keating Fire Company, Pittsburgh PA – September 2006
Marion Fire Department, Marion OH – September 2006
Sloan Ford , Downingtown PA – July 2006
Horsham Fire Company, Horsham PA – July 2006
East Brandywine Fire Company, Glenmoore PA – May 2006
Danby Lumber Company , Kennett Square PA – May 2006
Brandywine Heating and Air Conditioning, West Chester PA – May 2006
Fire Department Instructor’s Conference (FDIC), Indianapolis, Indiana, -
April, 2006
East Goshen Township, East Goshen PA – April 2006
Kennett Square Fire Company, Kennett Square PA – April 2006
Litiz Fire Company, Lititz PA – March 2006
West Chester Fire Department, West Chester PA – March 2006
Hilltown Township Fire Company, Hilltown PA – February 2006
First West Chester Fire Company, West Chester PA – February 2006
Goshen Fire Company, West Chester PA – January, 2006
Lionville Fire Company, Lionville PA – January 2006
Dallastown Fire Company, Dallastown, PA – January 2006
Radnor Fire Company, Wayne PA – November 2005
Firehouse Exposition, Baltimore Maryland - July 29, 2005
Thanks so much. Can I ask how you did that?
 
R

rfdjr1

Personally, I don't like the trend to do this: it tends to stop the
oldest parts ever being looked at. Like top-posting, it smacks of
laziness (i. e. people can't be bothered to scroll); also, I think
chronological order makes more plain sense than reverse, in most cases.

However:


having had a look, it looks like just one line per class (I'd assumed
you meant the names of all the "pupils", and was going to raise the
warning about data protection, but you didn't). While I suspect there
are better ways, possibly even editors that can do what you want, I
think it could be done with a spreadsheet like Excel: copy the text
lines into one column (not sure how you'd do that - possibly just
pasting, though you might have to change all the commas to something
else temporarily), add another column that just counts 1, 2, 3 etc. (you
don't have to type them all in - just put 1 in the top cell and "=A1+1"
in A2, and copy that into the rest), then reverse sort on that column,
then export the text column (and reverse the comma substitution if you
had to make it). But, as I said, there's probably an easier way - this
would just be quicker than retyping all of it.
Thanks for the reply.
 
N

Nil

I run a website for my Son who teaches safe driving to
(predominantly) firefighters around the country. I started it
around seven years ago. I am not a pro at this. I started a list
of classes he has taught and update it every time he teaches. It's
grown quite large. It starts with the first classes taught and
scrolls down to the most recent. A friend of mine who is a
professional software guy and writes apps, looked at it and
suggested that the list be in reverse, with the most recent
classes being at the top. It would be a daunting task to redo this
whole list manually. I was wondering if there's any program that I
could copy and paste into, and then have it reverse the order?
Here's a link to the page if it helps. I have a feeling that I'll
be sitting in front of the keyboard doing this by hand, but it
doesn't hurt to ask. Thanks.

http://www.drivetosurvive.org/past_seminars.htm
You don't say how you do it now or what tools you have available. There
are lots of ways to do it. Some good suggestions have been made in this
thread already. Personally, I'd prefer to keep a list like that in a
database, probably MS Access 2003. I can then sort the list by any
criteria I like, and I can create macros or Visual Basic code to export
it as text or HTML.
 
N

Nil

You don't say how you do it now or what tools you have available.
There are lots of ways to do it. Some good suggestions have been
made in this thread already. Personally, I'd prefer to keep a list
like that in a database, probably MS Access 2003. I can then sort
the list by any criteria I like, and I can create macros or Visual
Basic code to export it as text or HTML.
I forgot to mention that many word processors and text editors can re-
sort the lines in a text file. MS Word can do it, so can the free text
editor Notepad++.
 
W

...winston

Here are a few examples of the data in different file formats
http://tinyurl.com/6sqrb6k

Excel 2007, 2010 (*.xls, *.xlsx) 42 KB, 15 KB
PDF (*.pdf) 149 KB
Web Page (*.mht) 62KB

All can be downloaded and/or viewed.
The Excel files should open using the Office Apps web UI.

Fyi...files will be removed in 7 days.


--
....winston
msft mvp mail


wrote in message
I run a website for my Son who teaches safe driving to (predominantly)
firefighters around the country. I started it around seven years ago. I am not a
pro at this. I started a list of classes he has taught and update it every time
he teaches. It's grown quite large. It starts with the first classes taught and
scrolls down to the most recent. A friend of mine who is a professional software
guy and writes apps, looked at it and suggested that the list be in reverse,
with the most recent classes being at the top. It would be a daunting task to
redo this whole list manually. I was wondering if there's any program that I
could copy and paste into, and then have it reverse the order? Here's a link to
the page if it helps. I have a feeling that I'll be sitting in front of the
keyboard doing this by hand, but it doesn't hurt to ask. Thanks.

http://www.drivetosurvive.org/past_seminars.htm
 
Ad

Advertisements

W

...winston

"richard" wrote in message
why is a spread sheet being the way to do a simple thing?
have you people looked at the code those things add on that are not
necessary?
I have. Most of the code they use PER CODE LINE is outrageous!
Most of which is out of date and depricated.
A file that should be 10kb in size, is now a whopping 640kb simply due to
the excessive tags in the code.
600 KB ?
More like 15 or 42 KB depending upon the spreadsheet format (Excel 2007 or 2010)

http://tinyurl.com/6sqrb6k
 
R

Roger Mills

I run a website for my Son who teaches safe driving to (predominantly)
firefighters around the country. I started it around seven years ago. I am not a
pro at this. I started a list of classes he has taught and update it every time
he teaches. It's grown quite large. It starts with the first classes taught and
scrolls down to the most recent. A friend of mine who is a professional software
guy and writes apps, looked at it and suggested that the list be in reverse,
with the most recent classes being at the top. It would be a daunting task to
redo this whole list manually. I was wondering if there's any program that I
could copy and paste into, and then have it reverse the order? Here's a link to
the page if it helps. I have a feeling that I'll be sitting in front of the
keyboard doing this by hand, but it doesn't hurt to ask. Thanks.

http://www.drivetosurvive.org/past_seminars.htm
As others have shown, reversing the list - using Excel or whatever - is
trivial.

But I'm not sure that will achieve what you want to do. Presumably each
of those titles on your website is actually a *link* to a page
containing the text of the lecture - which means that it has some
attached HTML code. That HTML needs to be kept with the relevant title,
and the whole thing reversed - otherwise it won't work.
--
Cheers,
Roger
____________
Please reply to Newsgroup. Whilst email address is valid, it is seldom
checked.
 
S

Stan Brown

I was wondering if there's any program that I
could copy and paste into, and then have it reverse the order?
Excel, or any database program, will let you sort from oldest to
newest or newest to oldest.
 
Ad

Advertisements

C

Char Jackson

why is a spread sheet being the way to do a simple thing?
have you people looked at the code those things add on that are not
necessary?
I have. Most of the code they use PER CODE LINE is outrageous!
Most of which is out of date and depricated.
A file that should be 10kb in size, is now a whopping 640kb simply due to
the excessive tags in the code.
You should look into some of the export as text options of your
favorite spreadsheet program. I think you'll be amazed to find that no
additional code is added.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top