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.
Analytic text functions - FileMaker Pro Tutorial
From the course: FileMaker Pro Essential Training (2019)
Analytic text functions
- [Instructor] The largest group of calculation functions in FileMaker Unlike some groups of functions, in which only a few are used on a regular basis, I'd say that about nearly half of the text function group are of primary application and importance. Text functions also break into two different categories. Analytic text functions, and text manipulation text functions, which extract or manipulate text from the reference string. If we go inside File, Manage, Database you'll see at the very bottom of our list in the Customer table, I have a field called Text Calc, which is set to calculation and we can add a formula here. On the right hand side I'm going to isolate of the text functions available to us. But focusing on the analytic ones, the ones that are going to return numeric data on about reference text, I'm going to show you really a few different examples. One of the most common ones is length. I'm going to reference the CompanyName field, which we see over here on the left hand…
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)
-
-
-