First letter of 1st word needs to be uppercase

[ttmail]

Hi There

I need to know how to make the first letter of the 1st word that I input to be capitalized.

I feel as I should know the answer to this but my mind is blank.

Hope someone can help.

Thanks

[comment]

Use the Proper() function?

[ttmail]

Hi thanks for that.

That gives me the uppercase for all words.

e.g. The Quick Brown

I need: The quick brown

Thanks

[comment]

Sorry, I missed that part. What should the result be if you enter "the quick Fox is an FBI agent"?

[ttmail]

Hi there

I just need this to be "The quick fox is an fbi agent"

So just to clarify "T" needs to best in capitals and rest can be lowercase.

Hope I have explained OK.

[comment]

Try =

Replace ( Lower ( text ) ; 1 ; 1 ; Upper ( Left ( text ; 1 ) ) )

[ttmail]

Excellent Thank You....works a treat.

[FMPierce]

If you wanted it to be "The quick Fox is an FBI agent" (Keeping everything already uppercase, uppercase), you could take out the Lower ( ).

And, you can use Trim ( ) on the text so the calc doesn't upper case a space (which would mean it would do nothing).

So in the end the calc would be like:

Replace ( Trim ( text ) ; 1 ; 1 ; Upper ( Left ( text ; 1 ) ) )

[bcooney]

Automatic message

This topic has been moved from "Database Schema & Business Logic → Custom Functions" to "Database Schema & Business Logic → Calculation Engine (Define Fields)".