How to sort this list by date?

General questions about using TextPad

Moderators: AmigoJack, bbadmin, helios, Bob Hansen, MudGuard

Post Reply
User avatar
Dick7
Posts: 24
Joined: Mon Feb 02, 2004 6:55 am

How to sort this list by date?

Post by Dick7 »

American Composers - July/Aug 1995
American Symphonies - July/Aug 2007
American Music - Nov/Dec 2007
Bach - Nov/Dec 1997
Bach Keyboard - July/August 2005
Ballet Music - Mar/Apr 1996
Bartok - Mar/Apr 2001
Beethoven Piano Sonatas - May/June 2002
Beethoven Quartets - Nov/Dec 2006
Beethoven - July/August 2003
Berlioz - May/June 2007
Brahms - Sept/Oct 2006
Brass - Sept/Oct 2005
Britten - July/Aug 1998
Bruckner - May/June 2006
Cello Concertos - Nov/Dec 1998
Chopin - July/Aug 1999
Choral Masterpieces - Nov/Dec 2000
Debussy & Ravel - Jan/Feb 2000
Dvorak - Sept/Oct 1998
English Symphonies - July/Aug 2000
Favorite Violin Concertos - Sept/Oct 1996
Favorite String Quartets - Sept/Oct 1997
Film Music - Mar/Apr 1998
French & German Operas - March/April 2008
French Favorites - Nov/Dec 1999
Guitar Music - Sept/Oct 2003
Handel Orchestral & Messiah - Nov/Dec 2002
Handel Operas - Jan/Feb 2003
Haydn - Mar/Apr 2002
Historic Conductors - May/June 1998
Italian Opera - Sept/Oct 2000
Liszt - May/June 1999
Mahler - July/Aug 2001
Mendelssohn - Jan/Feb 2005
Mozart Operas - Jan/Feb 2002
Mozart Symphonies - Nov/Dec 2001
Music since 1975 - Sept/Oct 2001
Nielsen - May/June 2004
Piano Trios - May/June 1997
Program Music - Sept/Oct 1999
Prokofieff - July/Aug 2004
Rachmaninoff - Mar/Apr 1999
Respighi - Jan/Feb 1998
Russian Favorites - July/Aug 1996
Russian Music beyond Tchaikovsky - Part 1 - Jan/Feb 2004
Russian Music beyond Tchaikovsky - Part 2 - Mar/Apr 2004
Russian Operas - May/June 2003
Saint-Saens - Mar/Apr 2000
Schubert - Nov/Dec 2003
Schumann - Sept/Oct 2004
Shostakovich Symphonies - Jan/Feb 2006
Shostakovich other music - Mar/Apr 2006
Sibelius - Jan/Feb 1999
Spanish Music - Sept/Oct 2002
R Strauss - May/June 2005
Stravinsky - May/June 2001
Tchaikovsky - Jan/Feb 2001
Verdi - May/June 2000
Wagner - July/Aug 2002
Woodwinds - Nov/Dec 2005

This is the list of Overviews in The American Record Guide. I want to sort them so that the newest is at the top, and so on down to the oldest.

Possible?

Thanks
Dick
User avatar
Bob Hansen
Posts: 1516
Joined: Sun Mar 02, 2003 8:15 pm
Location: Salem, NH
Contact:

Post by Bob Hansen »

1. Do multiple replaces first.
Replace month range with a two digit number, ie: Mar/April becomes 03 or 04

2. Use Regex to realign date components
Find for xx\year
Replace with year\xx

3. Move date component year\xx to beginning of line using RegEx

4. Now you can do the sort.

5. After the sort you could move dates from beginning to end of line again.

==================
This could become a macro and be called with a macro hot key.
Hope this was helpful.............good luck,
Bob
User avatar
Dick7
Posts: 24
Joined: Mon Feb 02, 2004 6:55 am

Post by Dick7 »

Thank you!
Dick
Post Reply