GetFontFamily ( text )

Returns the font of a text

Average rating: 4.4 (29 votes) Log in to vote

Joe Gold - Show more from this author
Angel City Data
http://www.angelcitydata.com

Sample input:

GetFontFamily( FirstName)

Sample output:

Arial

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*
GetFontFamily function (Not a recursive function)

Author: Joe Gold

Format: GetFontFamily(text)

Parameter: text - any text expression or text field

Data type returned: text

Description: Returns the font of a text. 

*/

Let ([ SizeStart=Position (GetAsCSS(text);"font-family";1;1);
        SizeEnd=Position(GetAsCSS(text);";";SizeStart;1)-1;
         FontFamily=Middle(GetAsCSS(text);SizeStart+14;SizeEnd-(SizeStart+14))];

If(SizeStart*SizeEnd;
    FontFamily;""))

Returns the font of a text

Comments

		NeuronNerd, Smithfield Jun 27, 2011
This seems simple enough, but on implementation, I get nothing. I've tried putting fields names as well as typing text in quotes, and nothing. Any ideas? This will be perfect for me if I get it to work.

		Joe Gold, Angel City Data Jun 27, 2011
It only works when a font is explicitly chosen. So if you highlight the text, and choose Arial, then the fucntion should return Arial. If you simply type text, and don't choose any font, the function doesn't work.

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

GetFontFamily ( text )

Comments

Support this website.

Support this website.