From the course: FileMaker Pro Essential Training (2019)
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Text manipulation and functions - FileMaker Pro Tutorial
From the course: FileMaker Pro Essential Training (2019)
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…
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 functions3m 55s
-
(Locked)
Date and time functions4m 37s
-
(Locked)
Analytic text functions2m 59s
-
(Locked)
Text manipulation and functions4m 48s
-
(Locked)
Logic functions: The If function3m 26s
-
(Locked)
Logic functions: The Case function4m 10s
-
(Locked)
-
-
-