You are asking for:
fmp:COL(1) // <== this is square brackets, changed to prevent munging while reply-by-email
Look at the RAW XML for such an export and repeating or related fields can have multiple DATA elements for a COL.
You might consider exporting from the child records as well and bring in related Parent fields.
Thanks. I have made the following changes but now all the first column cells are blank in the csv. ( Round brackets used in example below but actual code uses square brackets)
I used COL(1), but do not know which column/field (in export order) is the one with related fields (you have several in your "Export field order.PNG"). Look at your raw XML to see what I mean. I thought the "Agent" field (1 in export order) was the problem.
also, you may need this:
fmp:COL(x)/fmp:DATA(1) // 'x' being the correct column/field
Many thanks....I have managed to get it working now.