if statement in export script

[concrete]

I post this here, because it has more to do with scripting than with exporting.

I have a persons database

Each entry has a "details?" field with "yes" or "no" value.

I need to export this database to a tab delimited txt file for other sources

but for the entries with "details?"="no" i don't want to include some fields in this export.

say i have 10 fields for each entry

for the "yes" entries i need to export all 10 of them, for the "no" entries I only need to export 3 of them.

but there should be a space instead (so this exported file can be imported in excel)

I don't have a clue where to start

I hope this is a little clear

[BobWeaver]

For the 7 fields that you want to export conditionally, create 7 calculated fields with these formulae:

cExportField1:= Case(Details="yes",Field1,"")

cExportField2:= Case(Details="yes",Field2,"")

cExportField3:= Case(Details="yes",Field3,"")

etc.

Then use these export fields instead of the originals.

[concrete]

thx bob

very simple, but very usefull