Re: Alpha Sort - ignore certain characters

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 52702
interpreted = N
texte = Thanks Charles and Donovan, Sounds like the extra field in the database might be faster and easier - though not quite as slick. -- Jim Ziegler List Administrator Plank Road Publishing www.musick8.com/html/list.tpl www.resourcefulclassroom.com/html/list.tpl on 9/8/03 14:10, Charles Kline at ckline@rightcode.net wrote: > Not that I know of. You might do this in 2 searches. First seach gets > all the records and writes them to a temporary database, whacking off > any non-alpha characters on the front. Then you do another search on > that record set and there ya go. > > Another option could be to have two fields in the table for each song > (on for display another for searching) - where the one you search does > not have the quotes, etc. > > - Charles > > On Monday, Sep 8, 2003, at 15:07 US/Eastern, James Ziegler wrote: > >> Greetings! >> >> I want to do a nice simple sort of a bunch of song titles. No problem, >> except that certain songs begin with an apostrophe or a quotation mark >> or >> some other non-alpha character, i.e.: >> >> 'Round About Autumn >> >> So is there a way to make this product come up with the other "R" >> products >> where it belongs, instead of at the beginning of the list? Any way to >> tell >> the sort to ignore certain characters? >> >> Thanks. ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Alpha Sort - ignore certain characters ( James Ziegler 2003)
  2. Re: Alpha Sort - ignore certain characters ( Donovan 2003)
  3. Re: Alpha Sort - ignore certain characters ( Charles Kline 2003)
  4. Alpha Sort - ignore certain characters ( James Ziegler 2003)
Thanks Charles and Donovan, Sounds like the extra field in the database might be faster and easier - though not quite as slick. -- Jim Ziegler List Administrator Plank Road Publishing www.musick8.com/html/list.tpl www.resourcefulclassroom.com/html/list.tpl on 9/8/03 14:10, Charles Kline at ckline@rightcode.net wrote: > Not that I know of. You might do this in 2 searches. First seach gets > all the records and writes them to a temporary database, whacking off > any non-alpha characters on the front. Then you do another search on > that record set and there ya go. > > Another option could be to have two fields in the table for each song > (on for display another for searching) - where the one you search does > not have the quotes, etc. > > - Charles > > On Monday, Sep 8, 2003, at 15:07 US/Eastern, James Ziegler wrote: > >> Greetings! >> >> I want to do a nice simple sort of a bunch of song titles. No problem, >> except that certain songs begin with an apostrophe or a quotation mark >> or >> some other non-alpha character, i.e.: >> >> 'Round About Autumn >> >> So is there a way to make this product come up with the other "R" >> products >> where it belongs, instead of at the beginning of the list? Any way to >> tell >> the sort to ignore certain characters? >> >> Thanks. ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ James Ziegler

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

A question on sub-categories (1997) Re:How to Display text in empty fields (1997) How to Display text in empty fields (1997) Hosting (1998) WebDNA version? (2007) Not really WebCat (1997) Emailer (WebCat2) (1997) Date comparison has serious bug ... (1998) Re:2nd WebCatalog2 Feature Request (1996) searchable list archive (1997) WebCat2_Mac RETURNs in .db (1997) searching multiple databases in single search (1997) New WebDNA Example from Olin -- (1998) referrer (2000) Part Html part WebDNA (1997) [OT] SMTP Server for W2000 (2002) Problems setting MIME Headers (1998) No shipping systems available? (1998) Robert Minor duplicate mail (1997) Adding Shipping Fields (1999)