Shell Programming and Scripting

ID,Value,Description
1,A,Active
1,I,Inactive
2,S,Started
1,N,None
2,C,Completed
2,F,Failed

#!bin/bash
IDList=`awk -F"," '{print $1}' File1.txt | sort -u`
for i in $IDList
do
description=`awk -F"," 'if ($1 == $i) {print $3}' File1.txt | sort -u`
echo $description > myfile$i.txt
done

description=`awk -F"," 'if ($1 == 1) {print $3}' File1.txt | sort -u`

awk -F, 'NR>1{F="myfile" $1 ".txt";print $3 >> F;close(F)}' File1.txt

awk '
        NR > 1 {                        # If total records read > 1 (Skip Header)
                F = "myfile" $1 ".txt"  # Set variable F = "myfile" $1 ".txt" (Construct file name)
                print $3 >> F           # Append output to file (F)
                close(F)                # Close the open file
        }
' File1.txt

awk -F, '
        NR > 1 {
                A[$1] = A[$1] ? A[$1] RS $3 : $3
        }
        END {
                for ( k in A )
                        print "RuleID" k ":" RS A[k]
        }
' File1.txt