Exporting a list
I have a field defined as:
ValueListItems ( Get ( FileName ) ; "Upsells" )
The ValueList itself is defined in the database and takes its values from related fields.
When I look at the results in a list layout, everything is exactly as I would expect - there is a little list of the related records in the field.
When I try to export it, Filemaker is running all the values together so that I just get a long string of numbers in the Upsells column of the export.
I tried redefining the field to replace the line breaks in the list with something else:
Substitute ( ValueListItems ( Get ( FileName ) ; "Upsells" ) ; "¶"; "|" )
And, again, the list is now separated by pipes when I look at it on screen, but, again, when I export it, Filemaker is running all the list items together.
I've tried exorting as tab-delimited, comma-separated and Excel with the same results each time. I've attached a little picture - the upper bit is a screen shot from Filemaker and the lower bit, the same records by the time they've made their way to Excel (I didn't export the middle column of the Filemaker bit).
I'm sure I'm doing something obvioulsy wrong, but, whilst I still have some hair left, could someone point it out to me?
Thanks in advance,