The following FileMaker example file is useful in many situations to demonstrate how to “parse” or analyze text into its component parts so that you can make use of the information in more meaningful ways.
For example, you may have an email form that contains addresses, phone numbers, names, etc. but FileMaker doesn’t know how to get at that information easily.
We created a custom function to pull items out of any text. It will look for a return, tab, space, or no delimiter between the BeginText and the start of the field info.
ParseText(Text, BeginText, EndText)