From the course: FileMaker Pro 15 Essential Training

Unlock the full course today

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

Use text functions

Use text functions - FileMaker Pro Tutorial

From the course: FileMaker Pro 15 Essential Training

Start my 1-month free trial

Use text functions

- [Voiceover] The largest group of functions in FileMaker Pro pertain to investigating and manipulating text strings. These are the text functions. Unlike some groups of functions which only have a few that are used on a regular basis, I would say nearly half of the text functions are of primary application and quite frankly, most of them are used while being nested or in conjunction with other text functions. These are the types of functions that are vital to the process of parsing data, for example. In this movie, I'm going to introduce you to the syntax of some of the core text functions. So if we go into file, manage, database, I have one that's called TextCalc down on the bottom. If we hit options, we can get rid of the quote quote that's already in there. Now the easiest to understand of all the text functions probably length because text functions really break down into two categories. There are text functions that return numeric results, like for example length where what it's…

Contents