Re: Editing a output file

Stacey I guess you could use awk or perl. But why dont you just edit your SQL command? Thats much easier. Change: select TKID, TKINIT, TKFIRST, TKLASTto select TKID, TKINIT, TKFIRST || ' ' || TKLAST HTH Sujit Stacey Windsor <swindsor@verner.com> on 12/03/99 10:49:15 AM To: "<" <informix-list@iiug.org> cc: (bcc: Sujit Pal) Subject: Editing a output file I have a SQL command that runs each night against my database to generate an output file, but the output is not quite right. The output format is as follows: TKID | TKINIT | TKFIRST | TKLAST 1 | RAB | Robert A. | Banks | 2 | DEC | David R.| Cunningham | 3 | MRD | Mathew R. | Donaldson | Is the a way to write a script, use VI or a third party program to edit this file to remove the pipe symbol (and extra space) from between the TKFIRST and TKLAST so that the final format looks like this: 1 | RAB | Robert A. Banks | 2 | DEC | David R. Cunningham | 3 | MRD | Mathew R. Donaldson | Stacey Windsor x6071