check for data consistancy
Posted: Mon Mar 28, 2005 11:44 am
Hi,
I have a requirement to match a description field to be in title case. For example, this would be a valid description:"Removal of Motor". However, these would not be a valid description "removal of motor", or "REMOVAL OF MOTOR". We can take care of when each word needs to start with a capital letter, but how do we make sure that words like 'of, 'and' etc stay in lower case ? Also there may be some abbreviations in the text which strictly need to be in capital case like "Removal of Motor ISO". Any ideas on how I can do this ?
Thanks,
I have a requirement to match a description field to be in title case. For example, this would be a valid description:"Removal of Motor". However, these would not be a valid description "removal of motor", or "REMOVAL OF MOTOR". We can take care of when each word needs to start with a capital letter, but how do we make sure that words like 'of, 'and' etc stay in lower case ? Also there may be some abbreviations in the text which strictly need to be in capital case like "Removal of Motor ISO". Any ideas on how I can do this ?
Thanks,