FileMaker Expressions (Text extraction via calculation)
As I've said in the past, "If you've got the time and inclination, learn how to use regular expressions. It's one of the most empowering tools you'll use for any text processing." Of course, you may not have the time or immediate need to learn this age-old programmer's technology. Maybe you don't see yourself as a programmer but rather a database developer.
No matter how you see yourself when working with FileMaker Pro, there's one thing for sure. You WILL have the need to process text. This includes appending, extracting and all kinds of 'ing' words! In this video I present a very powerful set of custom functions which can extract text based on using regular 'ole FileMaker functions. The concept is very powerful and can be used in a variety of ways. Hold on to your hat as we take a look at this powerful custom function from Fabrice Nordmann!