UNIX for Dummies Questions & Answers

Hi i want to cut the first field of this output obtained form sql script

more dxlocks_test.log.1

SID SERIAL# SPID
---------- ---------- ---------
25 18356 1029
78 39370 1025
136 14361 1027

================================
cut -f1 dxlocks_test.log.1 > compare
================================
more compare
SID SERIAL# SPID
---------- ---------- ---------
25 18356 1029
78 39370 1025
136 14361 1027
==================================
i thought the delimiter was tab, then i tried with space
cut -d' ' -f1 dxlocks_test.log.1 > compare
=================================
more compare

----------




====================================
This is the output.. i want to acutallly want to store each of the SID's in separate variable? So the approach i thought of was to first cut the coloum of sids, and then take 1 sid at a time and assign them in a variable.. can someone help with the cut command or any better way that i should look at

It would be slight easier if you said in you SQL

Code:

heading off

to remove the SID SERIAL
and -------- lines

Then you could say

Code:

X=1
while read SID everything_else; do
  eval SIDS[$X]=$SID
  let X=$X+1
done < my_sids_list

Then you can access the SIDs as:

Code:

echo ${SIDS[1]}
...

thanks .. actually wanted the heading.. dont matter will run another querry forthe output file..

will try an let u know how it works..