Shell Programming and Scripting

abc   ,def ghi      ,jkl
mno  ,pqr stu      ,vwx

Field 1: 
abc
mno
Field 2: 
def ghi
pqr stu
Field 3: 
jkl
vwx

for i in `cat file.txt`
do
  Field1=`echo $i | awk -F ',' '{print $1}'| sed 's/^ *// ; s/ *$//'`
  Field2=`echo $i | awk -F ',' '{print $2}'| sed 's/^ *// ; s/ *$//'`
  Field3=`echo $i | awk -F ',' '{print $3}'| sed 's/^ *// ; s/ *$//'`
  echo "$Field1";
  echo "$Field2";
  echo "$Field3";
done

echo "field 1:";cut -d"," -f1 infile;echo "field 2:";cut -d"," -f2 infile;echo "field 3:";cut -d"," -f3 infile

for i in $(seq 1 14); do
    echo "Field ${i}:"
    cut -d',' -f${i} infile
done

for i in $(seq 1 14)
do
    echo "Field ${i}:"
    awk -F',' "{print \$${i}}" file.txt | sed 's/^ *//; s/ *$//'
done

for i in $(seq 1 14); do
    echo "Field ${i}:"
    cut -d',' -f${i} infile
done

Field 1;
abc def
mno pqr
Field 2;
abc def
mno pqr
Field 3;
abc def
mno pqr

for i in $(seq 1 14)
do
    echo "Field ${i}:"
    awk -F',' "{print \$${i}}" file.txt | sed 's/^ *//; s/ *$//'
done

Field 1;
abc def
mno pqr
Field 2;

Field 3;

chirel@linux$ cat file.txt
abc   ,def ghi      ,jkl      ,     abc, def, ghi, jkl, mno, pqr, stu, vwx, yz, 012, 345
MNO  ,PQR STU      ,VWX      ,     ABC, DEF, GHI, JKL, MNO, PQR, STU, VWX, YZ, 012, 345
Abc   ,Def Ghi      ,Jkl      ,     Abc, Def, Ghi, Jkl, Mno, Pqr, Stu, Vwx, Yz, 012, 345
chirel@linux$ for i in $(seq 1 14); do echo "Field ${i}:"; awk -F',' "{print \$${i}}" file.txt | sed 's/^ *//; s/ *$//'; done
Field 1:
abc
MNO
Abc
Field 2:
def ghi
PQR STU
Def Ghi
Field 3:
jkl
VWX
Jkl
Field 4:
abc
ABC
Abc
Field 5:
def
DEF
Def
Field 6:
ghi
GHI
Ghi
Field 7:
jkl
JKL
Jkl
Field 8:
mno
MNO
Mno
Field 9:
pqr
PQR
Pqr
Field 10:
stu
STU
Stu
Field 11:
vwx
VWX
Vwx
Field 12:
yz
YZ
Yz
Field 13:
012
012
012
Field 14:
345
345
345
chirel@linux$

#!/usr/bin/ksh
for i in $(seq 1 14)
do 
  $col1=echo "col ${i}:"; awk -F',' "{print \$${i}}" file.txt | sed 's/^ *//; s/ *$//'
  $col2=echo "col ${i}:"; awk -F',' "{print \$${i}}" file.txt | sed 's/^ *//; s/ *$//'
  sqlplus -s  user/password@oracleinstance <<eof
INSERT INTO table (col1, col2, ...)
VALUES
#($col1, $col2,... )
#commit;
#exit;
#eof