Re: Alpha Sort - ignore certain characters
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 52696
interpreted = N
texte = 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. > > > -- > James P. Ziegler > Director of Web Services > Plank Road Publishing > www.musick8.com > www.resourcefulclassroom.com > > > > ------------------------------------------------------------- > 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/ > > -- Charles Kline, President RightCode, Inc. 900 Briggs Road Suite 303 Mount Laurel, NJ 08054 Phone: 856-608-7908 Fax: 856-439-0154 http://www.rightcode.net ------------------------------------------------------------- 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:
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. > > > -- > James P. Ziegler > Director of Web Services > Plank Road Publishing > www.musick8.com > www.resourcefulclassroom.com > > > > ------------------------------------------------------------- > 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/ > > -- Charles Kline, President RightCode, Inc. 900 Briggs Road Suite 303 Mount Laurel, NJ 08054 Phone: 856-608-7908 Fax: 856-439-0154 http://www.rightcode.net ------------------------------------------------------------- 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/
Charles Kline
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:
Help! WebCat2 bug (1997)
E-mailer error codes (1997)
WebDelivery downloads alias, not original ? (1997)
webcat error log (1998)
Help! WebCat2 bug (1997)
Mondo amounts of Mail [long] (1999)
multi-paragraph fields (1997)
Re:2nd WebCatalog2 Feature Request (1996)
Security problems (2000)
Stumpted Again (1997)
For those of you not on the WebCatalog Beta... (1997)
multi-paragraph fields (1997)
Plugin or CGI or both (1997)
Keeping track of revision history, etc. (2005)
More help for discount pricing (1998)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
[WebDNA] Grep everything and replace with asterisks? (2010)
How big can WebCat go? (1999)
oops private message leaked into talk list (1997)
log files (1998)