Some cool text formatting custom FileMaker functions

From Dwayne Wright PMP, PMI-ACP, CSM
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

Recently, I wanted to have a listing of the cool text formatting functions for a project I was working on. The super custom function site at briandunning.com doesn’t have much in the way of organization options and its search capabilities are pretty basic. So I made a listing myself and then thought I might as well share the list to you via a blog. So here you go!

Dwayne

-----

ActualLineCount ( Text ; CharsPerLine )
Jonathan Stark, Jonathan Stark Consulting - http://jonathanstark.com/
Determine if text is overflowing field bounds on layout.

http://www.briandunning.com/cf/802

---------------------

CaseStatus ( theText )
Michael Pease, KPM
Determines if text is all upper case, all lower case, or mixed case (ignoring non a-Z chars)

http://www.briandunning.com/cf/848

================

GetFontFamily( text )
Joe Gold, Angel City Data - http://www.angelcitydata.com
Returns the font of a text

http://www.briandunning.com/cf/633

==================

GetFontStyle( text )
Joe Gold, Angel City Data - http://www.angelcitydata.com
returns style of a text

http://www.briandunning.com/cf/636

====================

GetStyledWords ( text ; style )
Daniele Raybaudi, ACI - www.aci.it
Returns all the styled words ( in list view ) within the given text

http://www.briandunning.com/cf/664

======================

RemoveDuplicates ( Text )
Andrew Persons, Excelisys - http://www.excelisys.com
Removes duplicate values from a value list.

http://www.briandunning.com/cf/492

=========================
Supertrim ( text )
Debi Fuchs, Aptworks Consulting - http://www.aptworks.com
Speedily (and with no recursion) remove leading and trailing white space (including spacing, tabs and returns) from a text string.

http://www.briandunning.com/cf/904

===========================
Trim4 ( text )
Ray Cologon, NightWing Enterprises - http://www.nightwing.com.au/FileMaker
Removes *all* leading and trailing white space from the supplied text, including tabs, carriage returns, spaces and non-breaking spaces.

http://www.briandunning.com/cf/166

===========================
=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2008 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.