echo "ID BUDGET_MON BUDGET_AMT"
while read ID MONTHS VAL
do
read -a M_ARRAY <<EOF
$( IFS=","; echo $MONTHS )
EOF
[ "$ID" = "ID," ] && continue
for MTH in ${M_ARRAY[@]}
do
echo $ID $MTH $((VAL/${#M_ARRAY[@]}))
done
done < budget.txt
This User Gave Thanks to Chubler_XL For This Post:
while(<DATA>){
next if $.==1;
chomp;
my @tmp = split;
my @ids=split(",",$tmp[1]);
foreach(@ids){
print $tmp[0]," ",$_," ",$tmp[2]/($#ids+1),"\n";
}
}
__DATA__
This User Gave Thanks to summer_cherry For This Post: