From the course: FileMaker Pro Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Text manipulation text functions - FileMaker Pro Tutorial
From the course: FileMaker Pro Essential Training
Text manipulation text 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 a 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 or if you're importing text in…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
(Locked)
What are calculations?3m
-
(Locked)
Touring the calculation dialog window4m 35s
-
(Locked)
Number functions in FileMaker3m 55s
-
(Locked)
Date and time functions4m 37s
-
(Locked)
Analytic text functions2m 59s
-
(Locked)
Text manipulation text functions4m 48s
-
(Locked)
Logic functions: The If function3m 26s
-
(Locked)
Logic functions: The Case function4m 10s
-
(Locked)
-
-
-