How about running the data from the select statement into a temp table.  Make the needed data changes there and then create the file from the temp table.

I've been dealing with PeopleSoft for the past six years and have found them to be extremely sparse in giving out information. One of the reasons for that is...