Do you mean that in the example shown, the only data you wish to retain is the very last line of text? "89/11 Emergency...."
Hi Phil, thanks for your response. Yes to your question above. Any idea where one could read up and learn more about manipulating text?
Comment over on fmforums.com provided a script that worked beautifully:
What they recommended seems excellent. If the text you want to keep always contains the text "emergency contacts", that might also be used to parse out only the text at the bottom of the field. All such methods rely on some basic consistency to how the data is organized inside your field from record to record.
All of the functions shown in the above example can be looked up in FileMaker help. So I suggest looking up any function names that are unfamiliar as the first step. From there you are welcome to ask questions about specific details if any part of this calculation still does not make sense. I'm sure the FM Forums folks would also be willing to explain.
Also, if you have FileMaker Advanced, you can enter the above expression into the Data Viewer as a watch expression. Then you can dissect it by adding/removing different parts of the expression as a way to better understand how each part of the calculation works.