Hi, I have a requirement in which i have to read a csv file and put data in certain set of variables:
File content:
VP-DTL-REC-CNT, ,854840,0.00,VP-PAID-AMT, ,0,32280885.17,VP-PAT-PAID-AMT, ,0,9930244.32,VP-PAID-REV-CNT, ,484927,0.00,VP-REJ-CNT, ,369913,0.00, , ,0,0.00, , ,0,0.00, , ,0,0.00, , ,0,0.00,CYCL_SRCE_DT, ,01/25/2010 00:00:00,1
This is the code i have written:
var=`cat ${INFA_BALANCING_DETAILS}`
for i in 0 1 2 3 4 5 6 7 8 9
do
for j in 1 2 3 4
do
v=`expr 4 \* $i + $j`
u=`expr $i + 1`
case "$j" in
1 ) ACTN_0${u}_NM=`echo $var|cut -d"," -f"$v"` ; exit ;;
2 ) ACTN_0${u}_CD=`echo $var|cut -d"," -f"$v"` ;;
3 ) ACTN_0${u}_CNT=`echo $var|cut -d"," -f"$v"` ;;
4 ) ACTN_0${u}_AMT=`echo $var|cut -d"," -f"$v"` ;;
* ) exit ;;
esac
done
echo "$ACTN_0${u}_NM" "$ACTN_0${u}_CD" "$ACTN_0${u}_CNT" "$ACTN_0${u}_AMT"
done
My problem: The assignment is not working since the LHS of the assignment is also varying.
Error: ACTN_01_NM=VP-DTL-REC-CNT: not found
Its trying to execute this statement.
Can anyone suggest me how to do this using korn shell script, is it possible to use a varying value on LHS of assignment?
Quick help is appreciated.