gmd

I'm not sure if I am expressing my question correctly. I can export the records fine to any of the types from file>>export records. That is not what I am asking. I want to export an entire layout (ie The header, footer, etc) to ideally tab-delimited but if not then excel. I do not see how this can be done by changing the type in the export records dialog box because it exports RECORDS ONLY. Maybe this is impossible, but I am asking because it would be very convenient for what I need to do.

Yes, I have looked there but the only options listed on that help page are for exporting data only (except for one or two that also export field names). On the bottom of the page it sites that Layouts can be saved as PDFs, but this cannot satisfy my need. What I am asking is if there is a way to Export or Save an entire layout's text and field contents to excel or tab-delimited format.

I have played with a few of the formats in exporting. I believe the export menu you are refering to is the "Export Records..." menu under File (in the windows version at least), but all most all of the export formats take data only. The only export format I have found to export the entire layout is PDF which does not suit out needs. As it is I can export all of the data I need to xls and then copy and paste it with the other things I needed, then export that as tab delimited, but it would save a lot of time to be able to just shoot it out in the right format in the first place. Let me know if you have any ideas or if I am missing something. -Gerard

I need to export to a tab delimited text file (excel would be an ok alternative if that works) to upload into a seperate server that I cannot control. In order for this to work, the data needs to have a specific header information and spacing that is easy to do manually in excel. I can write reports that look like I need but exporting them to excel it strips out all but field contents and the data and .txt strips out all but the field contents. Does anybody know a way to have the full report exported at tab delimited text or .xls?

Nevermind, I wasn't running into a loop problem, I just didn't have the script terminating

I am a beginner so this may be very simple but I am having problems. I have a found set and I want to omit lines that have a single field the same. When I use Constrain Found Set to omit a search for ! for the field, it removes every line in the found set if it has a duplicate anywhere in the database. I am a beginner with FM but have coded in many languages for years. I have tried writing scripts to loop through the data and compare each field, omitting duplicates, but something is definately wrong because my script never ends. I memory and cpu are not eaten so I wonder if something is simply wrong rather than going into an infinate loop... Thanks for any advice!