From the course: Advanced FileMaker Pro 12

Unlock the full course today

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

Understanding the Left, Right, and Middle functions

Understanding the Left, Right, and Middle functions - FileMaker Pro Tutorial

From the course: Advanced FileMaker Pro 12

Start my 1-month free trial

Understanding the Left, Right, and Middle functions

We talked about text functions that provide a numeric result when used in a formula, and in this movie I want to show you a family of functions that return a text value as the result of the text function. These families of functions are commonly used to extract or parse text out of another text string and we like to call them the left, right and middle functions, sort of a group or a family of functions together. Let's take a look at these. First, the Left function has two different parameters the text that's going to be parsed and the number of characters that we want to extract from the left. So it returns a string that contains the first left, however many numbers that we indicate. So example "Hickory, dickory, dock" returns H-i-c-k or the word "Hick." Now writes the same thing conversely, it will return the Right number of characters that we specify. So for example here we might say "Hickory, dickory, dock" again, number 4, meaning the number of characters we want to extract and…

Contents