Monkeybread Software - MBS FileMaker Plugin: Text.CapitalCase

Topics All Mac OS X (Only) Windows (Only) Linux (Only, Not) iOS (Only, Not)
Components Crossplatform Mac & Win Server Client Old Guides Examples
New in version: 7.1 7.2 7.3 7.4 7.5 8.0 8.1 8.2 8.3 8.4 Statistic

Text.CapitalCase

Converts text to capital case letters.

Component	Version	macOS	Windows	Server	FileMaker Cloud	FileMaker iOS SDK
Text	5.1	Yes	Yes	Yes	Yes	Yes

MBS( "Text.CapitalCase"; Text )

Parameters

Parameter Description Example value

Text The text to process. "hello WORLD"

Parameter	Description	Example value
Text	The text to process.	"hello WORLD"

Result

Returns text or error.

Description

Converts text to capital case letters.
First letter of a word is made upper case, all others to lower case.
Often people enter in forms all kinds of upper/lower case letters and you may want to normalize using this function.

See also Text.UpperCase, Text.LowerCase and Text.RemoveAccents.

Examples

Fix HAMBURG:

MBS( "Text.CapitalCase"; "HAMBURG" )
MBS( "Text.CapitalCase"; "HAMBurg" )

Example result: Hamburg

Fix Schleswig-Holstein:

MBS( "Text.CapitalCase"; "SCHLESWIG-HOLSTEIN" )

Example result: Schleswig-Holstein

Example Databases

Text functions/Change Letter Case

Created 10th March 2015, last changed 11st December 2016

Text.AppendTextFile - Text.Character

Feedback: Report problem or ask question.