antiFilter (textToFilter ; filterAllow ; filterSubChar ; start ; stop ; textBuilt )
replace any character not specified in the allowed list with the substitute character - Submitted by Michael Rauch

Tue, 22 Apr 2008 08:07:06 -0700

SmarterProper ( inText; prevCase; textSoFar; prefixList )
Similar to the Proper function, but handles names with prefixes better - Submitted by David Tremmel

Mon, 21 Apr 2008 07:16:46 -0700

SetDueDate ( StartDate ; DueDay ; Occ ; Freq )
Set due dates according to Frequency, occurences and Month's day defined - Submitted by Romain Dunand

Sun, 20 Apr 2008 15:27:16 -0700

QuarterRoundTS ( mytimestamp )
Rounds a timestamp to the nearest quarter hour. - Submitted by Jeff Morrison

Tue, 15 Apr 2008 13:28:56 -0700

TextFormatRemove ( text )
Type: Text Formatting

Result: Text

Description: Removes all formatting from the text supplied.

Example 1: TextFormatRemove( Customer::Address )
removes all text formatting to the supplied field or text

Versions: 8, 8.5, 9

Reference: FileMaker's Online Help

Tomorrow's Function: TextSize ( text; fontSize )

Thu, 08 May 2008 07:01:00 GMT

TextFontRemove ( text {; fontToRemove; fontScript} )
Type: Text Formatting

Result: Text

Description: Removes all fonts from the supplied text, or removes the font specified by fontName or the combination of fontName and fontScript. Spellings for font names must be correct and are case-sensitive. Text formatting options are lost if the data type returned is something other than text. fontToRemove should be wrapped in quotes. FontScript options are [Roman, Greek, Cyrillic, CentralEurope, ShiftJIS, TraditionalChinese, SimplifiedChinese, OEM, Symbol, Other]

Example 1: TextFontRemove( MyStyledField )
removes all fonts from the supplied field or text

Versions: 8, 8.5, 9

Reference: FileMaker's Online Help

Tomorrow's Function: TextFormatRemove ( text )

Wed, 07 May 2008 07:01:01 GMT

TextFont ( text; fontName {; fontScript} )
Type: Text Formatting

Result: Text

Description: Applies the font specified in fontName to the text supplied. The optional {fontScript} can be used to narrow the possible matches. Spellings for font names must be correct and are case-sensitive. Text formatting options are lost if the data type returned is something other than text. fontName should be wrapped in quotes. fontScript options are [Roman, Greek, Cyrillic, CentralEurope, ShiftJIS, TraditionalChinese, SimplifiedChinese, OEM, Symbol, Other]

Example 1: TextFont( FirstName; "Arial" )
applies the Arial font to the contents of the FirstName field

Versions: 7, 8, 8.5, 9

Reference: FileMaker's Online Help

Tomorrow's Function: TextFontRemove ( text {; fontToRemove; fontScript} )

Tue, 06 May 2008 07:01:00 GMT

TextColorRemove ( text {; RGB( red; green; blue )} )
Type: Text Formatting

Result: Text

Description: Removes all colors for the specified text. Specify an optional color to only remove that one color. The default color used in Layout mode will be used if additional coloring has been removed.

Example 1: TextColorRemove( MyColoredTextField )
will default to the color specified on the field in Layout mode.

Versions: 8, 8.5, 9

Reference: FileMaker's Online Help

Tomorrow's Function: TextFont ( text; fontName {; fontScript} )

Mon, 05 May 2008 07:01:00 GMT