Shell Programming and Scripting

--------------------------------------------------------------------------------

Hi,
I am getting values from oracle database and splitting with "|".
When i loop thru the $OUTPUT i am getting so many new line characters.

Please help me why i am getting so many line and how to get rid of the same.


below is the code i am using.

OUTPUT=`sqlplus -s <<-!
$DBLOGIN
whenever sqlerror exit failure
set pages 0 feed off echo off
select SEQNO,'|',MESSAGE_ID,'|'
from triton.cims_msg_out;
exit
!`

let count=0
IFS="|"
for variable in $OUTPUT
do
echo "variable ======= $variable"
#file=$(echo $variable | awk '{FS = "." } {print $1}')
#ext=$(echo $variable | awk '{FS = "." } {print $2}')
file=${variable%.*}
ext=${variable#*.}

done