Andrew Longland wrote:but what if there are an unlimited and unknown number of subvalues within each field?
I don't know. What if there are? What do you want to happen?
Providing an example record from your data set was a nice starting point. But you didn't tell us what the fields in the record are, whether there's a fixed number or a variable number, how you wanted the resulting fields named, or if you wanted them to be rows in a (field,value) pair sort of table, and then there are similar questions with all the sub fields of the sub fields. The example record itself, being mostly meaningless codes, provides no answers to these questions.
So I have no idea what you want. If that's your example record, what do you want the OUTPUT to look like? How are we supposed to tell you how to get your desired output if you don't tell us what your desired output IS?
Alternatively, you could look up the subfield() function in the help text. It describes two different modes of use. Dragonauta demonstrates the first, when you can assign a specific subfield to a specific field. There's another mode where you can create a ROW of data for every sub field. I suspect that some combination of the two is what you're after.
Here's what is essentially a random example of subfields with subfields. I have no idea if this is what you're after.
