In ClarisWorks, if you use the Save As command to save a database in another file format, the resulting file will contain data from only the found (visible) set of records. Because of this, you can limit which records are saved by performing a Find prior to using Save As. However, if you use Save As, the resulting file will always contain the data from every field in the found set of records.
If you want to limit which fields are used in the "export" file, the trick is to use Copy and Paste instead of Save As. Perform the following steps:
1. Create a layout in the database which has only the fields which you want to "export" and make it the current layout.
2. If appropriate, perform a Find so that only the desired records are visible.
3. Press the Enter key (on the far right of your keyboard, in the numeric keypad) to ensure that no individual record or field is selected or active.
4. Choose Select All from the Edit menu (Command-A on Mac, Ctrl A on Windows).
5. Choose Copy from the Edit menu (Command-C on Mac, Ctrl C on Windows).
6. Create a new, blank Spreadsheet document (Command-N, down arrow 3 times, then press Return on Mac; Ctrl N, down arrow 3 times, then press Enter on Windows).
7. Choose Paste from the Edit menu (Command-V on Mac, Ctrl V on Windows). At this point, you will have an Untitled ClarisWorks spreadsheet document which contains only the desired data.
8. Choose Save from the File menu (Command-S on Mac, Ctrl S on Windows), select the desired format, name the file, choose the desired location for the file to be saved to, and press Return (Mac) or Enter (Windows), and there you have it.
If you want this data in a format not available for spreadsheets (e.g. WordPerfect or Microsoft Word), in step 6, create a new word processing document instead of a spreadsheet and then follow steps 7 and 8. This will result in a text file with the data in tab separated format. If you want the data in comma separated format, use the Find/Change command to replace the tabs with commas before proceeding to step 8.
All or much of this process can be automated with a macro as well.