Shell Programming and Scripting

Hi All,

I am writing a shell script to extract oracle table into a pipe dilemited flat file. Below is my code and I have attached two files that I have abled to generate so far.

1. Table.txt ==> database extract file
2. flat.txt ==> pipe delimited after some manipulation of the original db extract (Table.txt) file.

My challenges:

The table I am extracting has 13 columns, I want all the columns (null or not null) to be pipe delimited. Problem is that after the last column that is not null (for example say 9th column out of 13th) in the flat file is not coming out with pipe '|', rather it shows up as empty space. I am struggling with this and need your kind help to resolve the issue . This is very urgent and I need to have the code ready by next week. Thank you in advance for your help!



#!/bin/ksh

FILE="Table.txt"
FLAT_FILE="flat.txt"
sqlplus -s user/password@DB <<EOF

SET HEADING OFF
SET PAGESIZE 50000
SET COLSEP "|"
SET LINESIZE 200
SPOOL $FILE
select * from activity;
SPOOL OFF
EXIT
EOF
sed -e '/^\s*$/d' -e 's/^ *//' -e 's/ *| */|/g' $FILE > $FLAT_FILE