Data manipulation during Export
I have no idea if what i wanna do is doable or not, but what i wanna do is...
I have 2 fields to export to a Tab Delimited file. Let's call them "English" and "French". If there's more than one entry in the English field (separated by a carriage return IN THE SAME FIELD), and only one in the French field, all those English entries must be equivalent to the French entry.
English_Main French_Main English_Sub1 English_Sub2 English_Sub3 English_Sub4
The above exemple must look like this once exported :
English_Main French_Main English_Sub1 French_Main English_Sub2 French_Main English_Sub3 French_Main English_Sub4 French_Main
But, here's the problem; sometimes, i can have multiple sub-entries in the French field, but only the FIRST one must be used during the exportation. So basically, this :
English_Main French_Main English_Sub1 French_SubX English_Sub2 French_SubY English_Sub3 French_SubZ
... must look like this in the exported file :
English_Main French_Main English_Sub1 French_Main English_Sub2 French_Main English_Sub3 French_Main
And the other problem is that i must NOT modify the content of the DB itself, that manipulation must be done only while exporting. When the export is done, it must be like it was before the export manipulation.
So, am i shooting in the dark here or there's a way to do this in FM ?
My first idea was to simply duplicate the DB, do the manipulation and then delete the dup, but that doesn't answer my question about moving/copying the data to make it look like what i need in the exported file.