Propercase Validation

[jamesfranklin]

Hi,
I'm having string like this
String 1: "Albert einstein College"
string 2: "Albert Einstein College"
String 3: Head of Department
string 4: Biochemist and Group Leader

This query will (StrComp([title],StrConv([title],3),0))<>0) return String 1 and String 3
because the string 1 is not in propercase
but i don't want to display whether the string contain "of,the,and" please leave the string which contain "of, the , and"


thank u..........................

 

[John Big Booty]

As StrConv() Proper Case will convert the first letter of Every Word to upper case, you would need to have a list of exceptions and then loop through your string and convert any occurrence of those exceptions back to lower case.

 

[John Big Booty]

Here's a sample that demonstrates one method that you might use to achieve your goal.

Note: In reality you would simply overwrite your data rather than copying it to a new field, which I have done for clarity only.

 

[jamesfranklin]

Thank u john. Exactly what i needed. But here i attached one file in this i want to check all fields in my table. any idea

thank u............

 

[John Big Booty]

You have the tool to convert a single field, it should now be a reasonably straight forward task to apply it across your entire table.

 

[jamesfranklin]

thank u for ur reply

sorry its not clear. explain something brief
thank u.....