Help creating a pipe delimited file

All,

I need to build an extract file from the I that will end up being a
pipe delimited text file. My issues are as follows;

1. There are multiple record types (with unique formats per
record type).

2. The delimited file needs to be ordered by employee and record
type

I am struggling to come up with an efficient way of doing this. Any
thoughts or suggestions would be much appreciated.

Sincerely,

Richard Reeve