Shell Programming and Scripting

H#A#B#C
D#A#B#C
T#A#B#C

#!/bin/bash
i=0
cat sample.csv | while read fileline
do
echo "$fileline"
row[i]=$fileline
i=$i+1
done

*** parse all rows in row array ***

A
B
C

awk -F"#" '/^D/ {print $2,$3,$4}' infile
A B C

$> cat infile
H#A#B#C
D#A#B#C#D#E
T#A#B#C
$> awk -F# '/^D/ {for(a=2; a<=NF; a++){print $a}}END{printf"\n"}' ORS=" " infile
A B C D E

$> arr=(`awk -F"#" '/^D/ {print $2,$3,$4}' infile`)
$> echo ${arr[*]}
A B C
$> echo ${arr[1]}
B

$> LINE=`grep ^D infile`
$> echo ${LINE#*#}| tr -s '#' ' '
A B C

cut -d# -f1 sample.csv >> firstcolumn.csv

H
D
T
.
.
.

cut -d# -f2 sample.csv >> secondcolumn.csv

cut -d# -f1,2 sample.csv >> firstandsecondcolumn.csv

Record Type#Batch Job ID#Batch Number#FileCreation Date#FileCreation Time#Production/Test Fileindicator#File Character
H#0002#0002#20100218#17.25#P#barani

Record Type#A#B#C#D#E#F#G#H#J#K#L
1#2#3#4#5#6#7#8#9#10#11

Record Type#NumberOFRecords
T#4500

N

#!/bin/bash
i=0
cat 1.csv | while read fileline
do
echo "$fileline"
row[i]=$fileline]
i=$(($i+1))
done

j=0
while [ $j -le $i ]
do
col1=$( cut –f 2-7  -d '#' –s $row[i])
echo "first char done"
col2=$( cut –f 1,3-7  -d '#' –s $row[i])
echo "sec char done"
col3=$( cut –f 1-2,4-7  -d '#' –s $row[i])
echo "3rd char done"
echo "$col1,$col2,$col3"
j=$(($j+1))
done

# you can parse the line using IFS and array
IFS="#" flds=( $fileline )
nrofflds=${#flds[@]}

fld1="${flds[0]}"  
fld=0
while (( fld<nrofflds ))
do
       #...  
       ((fld+=1))
done