[FX.php List] To data condition or not data condition. That is the question

[Gjermund Gusland Thorsen]

If you are to make proper() on names you would probably have to make
exceptions...

McDuck

case( left( $lastname; 2 ) = "mc" ; proper( left( $lastname; 2 ) ) &
proper( middle( $lastname; 3; -1 ) );
/* misc other exceptions */
proper( $lastname )
)

ggt

2009/12/5 Jonathan Schwartz <jschwartz at exit445.com>:
> Hi Folks,
>
> To data condition or not data condition. That is the question
>
> This is a philosophical question, I believe.
>
> Up until now, most of my projects have dealt with collecting records where
> 100% of the records would be used later in the client's FileMaker systems.
> It made sense to apply capitalization and phone number formatting and such
> to have the data comply with existing data standards.
>
> In a new project, however, records are being submitted that will be stored
> in a remote database and undergo a series of reviews before potentially
> being accepted and copied to the main database.  Perhaps 5% will make it.
>
> Because..
>        - Data conditioning isn't a perfect process
>        - It costs time to develop
>        - It costs cycles to run
>        - It "taints" the original data entry. (What would ee cummings think
> about having his name be capitalized?)
>        - Only a small number of records will emerge from the process
>
> ...does it makes sense to perform this step?
>
> Also, is this a question best left to the client?
>
> Would appreciate the insight of folks who have dealt with this....except Bob
> of course. ;-)
>
> Jonathan
> --
> Jonathan Schwartz
> Exit 445 Group
> jonathan at exit445.com
> http://www.exit445.com
> 415-370-5011
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>