Hi

I try to export the 2 fields one at a time, but the data from the next record overwrites the previous records. Is there a way to add fields from each record to a file? Many Thanks.

K.C.

Why not use a standard export?

Thank you for your reply.

In each export, sometimes I only need to export one filed, another time I need to export two fields. See attachment. Thanks.

Export Field Contents is typically used for exporting images, not text.

Have you tried a standard export of both fields? It should be fine -- or is there a problem you are trying to solve involving a mismatch between the author and ID fields?

Thank you for your reply. There is no mismatching in the author IDs. It just that on the first record, I only want to export the author and leave out the coauthor because it's blank. And in the second records, I want to export the sql statement for the author and co-author, for example. Thanks.

Maybe I should copy these data to another table and then do an export... Thanks.

Regards,

K.C.

I saw from your previous screenshot what fields you are wanting to export, but your new screenshot gives me a another hint of what you're trying to do. Maybe you should change your sql field calculations (or make new calculated fields) so that they are empty when the corresponding author fields are empty.

Are you wanting 2 fields from one record to export to 2 records? Maybe you want to look into a plugin that can write to a text file such as Troi File.

Or as you said, move the data to another table to stage the export.