Re: [WebDNA] checking for mixed case text

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 102727
interpreted = N
texte = Well done Ken! That's an approach I'd not thought of and to me seems like the most straight forward and re-usable. I now remember getting hung up on the [lookup] because it is in fact case sensitive. That is after all the main point of this thread... Marc Kenneth Grome wrote: >> But I cannot figure out how to get WebDNA to check a text >> string to report whether it is mixed case or not. > > > Here's another approach: > > Set the text string to a text variable (var) then create an > up.db with only one field (letter). Create one record in > this db for each uppercase letter in the alphabet, plus one > record for each non-alphabetic character that might occur in > a name. > > Then use this code: > > [math show=f]numUp=0[/math] > [text]numChars=[countchars][var][/countchars][/text] > > [listchars chars=[var]] > [showif [char]=[lookup > db=up.db&value=[char]&lookinfield=letter&returnfield=letter]] > [math show=f]numUp=numUp+1[/math] > [/showif] > [/listchars] > > [showif [numChars]=[numUp]] > all letters are uppercase > [/showif] > > [showif [numChars]![numUp]] > some letters are not uppercase > [/showif] > > > Sincerely, > Ken Grome > > > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > . > -- ------------------------------------------- Marc Thompson Software Engineer Office of Information Technology University of Utah 801.585.9264 marc.thompson@utah.edu ------------------------------------------- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] checking for mixed case text (Dana E Keil 2009)
  2. RE: [WebDNA] checking for mixed case text ("Olin Lagon" 2009)
  3. Re: [WebDNA] checking for mixed case text (Marc Thompson 2009)
  4. Re: [WebDNA] checking for mixed case text (christophe.billiottet@webdna.us 2009)
  5. Re: [WebDNA] checking for mixed case text (Matthew Bohne 2009)
  6. Re: [WebDNA] checking for mixed case text (Kenneth Grome 2009)
  7. Re: [WebDNA] checking for mixed case text (Govinda 2009)
  8. Re: [WebDNA] checking for mixed case text (Terry Wilson 2009)
  9. Re: [WebDNA] checking for mixed case text (Brian Fries 2009)
  10. [WebDNA] checking for mixed case text (Dana E Keil 2009)
Well done Ken! That's an approach I'd not thought of and to me seems like the most straight forward and re-usable. I now remember getting hung up on the [lookup] because it is in fact case sensitive. That is after all the main point of this thread... Marc Kenneth Grome wrote: >> But I cannot figure out how to get WebDNA to check a text >> string to report whether it is mixed case or not. > > > Here's another approach: > > Set the text string to a text variable (var) then create an > up.db with only one field (letter). Create one record in > this db for each uppercase letter in the alphabet, plus one > record for each non-alphabetic character that might occur in > a name. > > Then use this code: > > [math show=f]numUp=0[/math] > [text]numChars=[countchars][var][/countchars][/text] > > [listchars chars=[var]] > [showif [char]=[lookup > db=up.db&value=[char]&lookinfield=letter&returnfield=letter]] > [math show=f]numUp=numUp+1[/math] > [/showif] > [/listchars] > > [showif [numChars]=[numUp]] > all letters are uppercase > [/showif] > > [showif [numChars]![numUp]] > some letters are not uppercase > [/showif] > > > Sincerely, > Ken Grome > > > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > . > -- ------------------------------------------- Marc Thompson Software Engineer Office of Information Technology University of Utah 801.585.9264 marc.thompson@utah.edu ------------------------------------------- Marc Thompson

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:

WebCatalog NT beta 18 problem (1997) More on the email templates (1997) RAM variables (1997) Requiring that certain fields be completed (1997) server side includes & webcatalog (2000) Trouble with formula.db + more explanation (1997) PIXO support (1997) Multiple prices (1997) Not reading code (1997) Need relative path explanation (1997) Unique SKUs (2000) Page Showing 3 times (2000) Languages (1997) Stumped (1999) Search Philosophy (2001) [TaxableTotal] - not working with AOL and IE (1997) [WriteFile] problems (1997) Tried installing Windows beta with no success... (2000) expired beta (1997) Forms Search Questions (1997)