[FX.php List] Capitalization

Gjermund Gusland Thorsen ggt667 at gmail.com
Sat Dec 2 01:34:49 MST 2006


Ehh, this is not as much a data entry issue as a data laundry issue,
perhaps you should make a FileMaker script with permutation table to solve this?

ggt667

2006/12/1, Jonathan Schwartz <jonathan at eschwartz.com>:
> Hi Folks,
>
> To condition form data, I am using strtolower() and ucwords() to get
> "proper"  capitalization.  The biggest offenders are the "all lower
> case" users, closely followed by the "ALL UPPER CASE"  users.
>
> The problem I see with forcing capitalization with these function are
> the occasional names that don't follow the "rules": deSilva, etc.
>
> As I write this, I'm realizing that perhaps I can creat a rule based
> on the "de" and similar beginnings to surnames that pose the
> exceptions.
>
> Why I enjoy the results of sanitized data from forms, I feel an
> obligation to not force mis-capitalization if possible.
>
> Thanks
>
> Jonathan
>
>
>
>
>
>
> --
>
> Jonathan Schwartz
> FileMaker 8 Certified  Developer
> Associate Member, FileMaker Solutions Alliance
> Schwartz & Company
> jonathan at eschwartz.com
> http://www.eschwartz.com
> http://www.exit445.com
> 415-381-1852
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>


More information about the FX.php_List mailing list