When I wrote the blog post, it worked, it was a little to simplistic, as it converted every first character to upper case in a text field.
So I thought I would modify it, to do this with the exception of the words And, For, To and The contained within the text field.
Solution:
The formula then becomes:
IF " And " in CSTR(PROPERCASE({Tablename.Fieldname})) THEN REPLACE ( PROPERCASE({Tablename.Fieldname}), " And ", " and ") else IF " For " in CSTR(PROPERCASE({Tablename.Fieldname})) THEN REPLACE ( PROPERCASE({Tablename.Fieldname}), " For ", " for ") else IF " To " in CSTR(PROPERCASE({Tablename.Fieldname})) THEN REPLACE ( PROPERCASE({Tablename.Fieldname}), " To ", " to ") else IF " The " in CSTR(PROPERCASE({Tablename.Fieldname})) THEN REPLACE ( PROPERCASE({Tablename.Fieldname}), " The ", " the ") else PROPERCASE({Tablename.Fieldname})
If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us
|
