From the course: FileMaker Pro Essential Training (2019)

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Text manipulation and functions

Text manipulation and functions - FileMaker Pro Tutorial

From the course: FileMaker Pro Essential Training (2019)

Start my 1-month free trial

Text manipulation and functions

- [Instructor] Within the group of text functions, we've got a subset which are commonly referred to as text manipulation functions. These, unlike the analytic versions of text functions, don't give us numbers. Instead, they give us a result that's text, usually text that we're extracting from a string. I'm going to show you some of the more commonly used text manipulation functions, but I'm also going to show them to you in unconventional ways, meaning I'm not going to do calculation fields, I'm going to show you some other uses of calculation functions. So, the first one I want to show you is Trim. And what's the problem that the Trim function would solve? Well, we've got text string here, which is the Company Name, but let's say that our users are also putting in a whole bunch of leading and trailing spaces. This is actually more common when you're copying and pasting text from other areas, where if you're importing text in from maybe other database systems that are kind of older…

Contents