Title
Parsing data
Post
I need to parse out a text field that may have one or many sets of numbers. If there area multiple sets, they are separated by commas, but can be 5 or 6 digits long. I would like to duplicate the other fields in the record for each of the sets of numbers in this field.
Is there an easy way to script this?
This is one of those little "gems" unique to FileMaker (as far as I know) it results in using a field with a return separated list as a kind of "hidden join table" for a potentially many to many relationship. It works and has its uses, but also has significant limitations. If this is only for a "transitory step" it is likely that this is a workable option.