I need to create an ascii file. The data for the ascii file is contained in a number of tables as follows.

*Header line - info comes from policy master file table
*next line is policy information for policy identified in header record - info comes from policy detail table
*next line is location information for policy identified in header - info from policy location table
In all there are about 7 different lines of information associated with the header line. Then another header record for another policy and all the associated detail and so on until all policies are reported.

I have considered using "Text - Endtext" and "copy to xxxx sdf" to create the ascii file with my preference being "text-endtext".

Before I start, I was wondering if anyone had any other suggestion that I should consider.

Thanks in advance.

Gaylen






Each line in the file has a different format