The Original FileMaker Community
Business Templates - Demo Apps - Video Tutorials -Samples - Help - 46000 Member Forum

The Leading Filemaker Developer Tools

Must Have FileMaker Custom Functions: Text Cleanup

This FileMaker training video covers a few of our favorite Custom Functions with regards to cleaning up text. This is the second video in a series that will highlight several of our ‘must have’ Custom Functions.

Watch the first video in the series here:

Whether you are familiar with Custom Functions or not, these should save you some time and frustration when developing a solution that could potentially have text formatting issues.

Generally speaking, Custom Functions are a way to take something complex, repetitive, or confusing, and replace it with one simple function call.

While we would love text to always be entered properly, the reality is that there will be times where some cleanup is necessary. Using a Custom Function to harness the power of FileMaker built-in functions can make the entire process appear to be automatic which takes less time and decreases frustration at troubleshooting strange outcomes.

Sometimes the simplest things can make a major difference when creating or debugging your solution.

Even if you don’t have an immediate need for these specific Custom Functions, this tutorial video may give you ideas of other places in your solution that can be simplified.

FileMaker Functions utilized in these conversions:
Trim ()
Left ()
Right ()
Middle ()
Length ()
Filter ()
Let ()
If ()
PatternCount ( )
Case ( )
GetValue ()

► LINKEDIN:            

Please subscribe if you like this content or want to stay informed on more Productive Computing and FileMaker training videos.

► Auto Subscribe:

Thanks for watching!

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More

Privacy & Cookies Policy