Textkit Logo

SPIonic in MS Excel

Here's where you can discuss all things Ancient Greek. Use this board to ask questions about grammar, discuss learning strategies, get translation help and more!

SPIonic in MS Excel

Postby Stephen » Wed Jun 09, 2004 3:19 pm

I'm using Excel to keep a list of words that I'm learning. I'd like to have Excel sort the list alphabetically, and wonder if anyone has already worked out how to do this. I think I'd write a macro to generate a number to sort on (this could be different for different fonts), but don't want to reinvent the wheel.
Stephen
Textkit Neophyte
 
Posts: 12
Joined: Tue May 11, 2004 6:52 pm
Location: Pennsylvania

Postby Paul » Wed Jun 09, 2004 3:43 pm

Hi Stephen,

Are you trying to sort betacode (ascii) or unicode?

Cordially,

Paul
User avatar
Paul
Textkit Zealot
 
Posts: 701
Joined: Sun Jun 15, 2003 4:47 pm
Location: New York

Postby Stephen » Wed Jun 09, 2004 3:58 pm

Paul,

What I had in mind was betacode. I had started off using the Athenian font (from MS, I think), but since it doesn't seem to support accents, I was thinking of switching to SPIonic, using betacode - based on the recommendations in this forum. (My word list isn't very long yet, so I can switch without too much effort.)

I was sorting the Athenian font with a simple formula that looked at just the first two letters of a word. I'd need something more elaborate for betacode, skipping over the characters used to represent accents.

Steve
Stephen
Textkit Neophyte
 
Posts: 12
Joined: Tue May 11, 2004 6:52 pm
Location: Pennsylvania

Postby Paul » Wed Jun 09, 2004 4:24 pm

Hi Stephen,

Hmm...I guess I should have read your subject line. :oops:

It's entirely plausible that my AGTM (which you are beta-testing) contains 'normalization' code that could be used to strip out betacode diacriticals. I'd have to check.

But in any event, removing the diacrits via a script is a straightforward matter. I know next to nothing about Excel. Does its macro facility let you call a javascript function?

Cordially,

Paul
User avatar
Paul
Textkit Zealot
 
Posts: 701
Joined: Sun Jun 15, 2003 4:47 pm
Location: New York

Postby Stephen » Wed Jun 09, 2004 4:40 pm

Excel uses Visual Basic for its macros - I don't know if it handles javascript too. It shouldn't be hard to write a VB routine that skips over the diacritics. I was hoping that someone had already thought this through.

What I'd be using this for is to make up my own personal dictionary of just those words I'm learning and still need to be able to look up quickly or review. Right now I have a hundred or so, and I'd like an easy way to keep them in order as I add new ones.
Stephen
Textkit Neophyte
 
Posts: 12
Joined: Tue May 11, 2004 6:52 pm
Location: Pennsylvania

Postby Paul » Wed Jun 09, 2004 4:43 pm

If, like JavaScript, VBS supports regular expressions, then it should be a walk in the park.

Cordially,

Paul
User avatar
Paul
Textkit Zealot
 
Posts: 701
Joined: Sun Jun 15, 2003 4:47 pm
Location: New York


Return to Learning Greek

Who is online

Users browsing this forum: Ahab, aristoteles, C. S. Bartholomew, daivid and 58 guests