Shell Programming and Scripting

# The following types can be a problem for Linux:
CS 1 for non MBC
CHAP 6 for MBC 
CHAP 11 for BCCH on OL
etc.
# Better would be CS_1_for_non_MBC, etc. (or camel case)

#!/bin/bash
###############################################################################
# Use these commands to strip carriage returns from input files
# sed -i 's|\r$||g' CNAI_DUMP_RAW1.txt
# sed -i 's|\r$||g' parameters.txt
###############################################################################
dumpfil="./CNAI_DUMP_RAW1.txt"
parmsfil="./parameters.txt"
outfil="./csv.out"
> $outfil

hdr=($(head -n 1 $dumpfil))
lnum=0
while read raw
do
    lnum=$(( $lnum + 1 ))
    [ $lnum -lt 3 ] && continue     # skip header and row separators
    while read parm1 parm2
    do
        fnum=0  # lookup actual values
        for fld in ${hdr[*]};
        do
            fnum=$(( $fnum + 1 ))
            if [[ $fld == ${parm1,,} ]]; then   # field headers are lower case
                break
            fi
        done
        cell=$(echo $raw | cut -d ' ' -f 4 2>&1)
        act_val=$(echo $raw | cut -d ' ' -f $fnum 2>&1)
        printf "%s,%s,%s,%s\n" "$parm1" "$parm2" "$cell" "$act_val" | tee -a $outfil
    done < $parmsfil
done < $dumpfil

# output
# ------
# CCMIN,RANGES,RBR201A,100
# CCHPWR,33,RBR201A,33
# CCHPWR,30,RBR201A,33
# ATT,YES,RBR201A,YES
# CB,NO,RBR201A,NO
# CBQ,HIGH,RBR201A,HIGH
# ...
# ...
# etc.

# real    2m8.955s
# user    1m59.455s
# sys   0m12.274s