Newest functions Upload a function Leave a tip My account

There are 2,521 functions in this library.

TruncateText ( Text ; TextLength )

Truncates long text with three dots...

Average rating: 4.5 (31 votes) Log in to vote

Robert Olsson
Mallverkstan AB
http://www.mallverkstan.se

Sample input:

TruncateText ( "I like custom functions!" , 13 )

Sample output:

I like custom...

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

Let(t = Substitute ( Text ; "¶" ; " " );
Case(
IsEmpty(Text);"";
Length(Text)>TextLength;Left(t;TextLength) & "...";
t
)
)

Truncates long text with three dots at the end. Add the textfield as the first parameter and the length that you want to keep of the text as the second parameter.

Comments

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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth:

Nope