Repeating fields, lists, et. al.

Discussion created by barenose on Jul 3, 2012
Latest reply on Jul 3, 2012 by comment

I'm converting an old file with several repeating fields. I'm trying to split these into separate records while matching the correct values in each record.


For example,

One field is Mon, Tues, Wed, etc.

Next is A, B, C, D etc.

Finally there's Orange, Yellow, Blue, Green


There are five values in each repeating field, but not all the values are applied, i.e.


Record one could be Tues, C, Green

Record two might be Mon, A, Orange


and so on.


I've tried using the List () to get the values in one field and then the GetValue (field;x) to identify the correct values in the following fields. I keep getting a List of all the values in the resulting fields.


Any help is appreciated.


All the best,