Shell Programming and Scripting

awk -F= '
  {
    split($1,K,/,/)
    O[K[1]]
    A[$1]=$2
  } 

  K[1]==1 {
    F[NR]=K[2]
    n=NR
  }  

  END {
    for(i in O) {
      s=i
      for(j=1; j<=n; j++)
        s=s OFS A[i OFS F[j]]
      print s
    }
  }
' OFS=, file

2,2000,Providence,steve,jobs,User002
1,1000,CedarparkHospital,john,doe,User001

awk -F, '{gsub(/.*\=/,X,$2);A[$1]=A[$1]?A[$1] OFS $2:$2} END{for(u in A){print u OFS A[u]}}' OFS=, Input_file

1,1000,CedarparkHospital,john,doe,User001
2,User002,2000,steve,jobs,Providence

$ cat infile
1,ID=1000
1,Org=CedarparkHospital
1,cn=john
1,sn=doe
1,uid=User001
2,uid=User002
2,ID=2000
2,cn=steve
2,sn=jobs
2,Org=Providence

$ cat parse.awk
BEGIN{
	# Modify this variable if you want to change field order or if you want to remove any field
	order = "id,org,cn,sn,uid"

	# Header variable
	header = "RECORD"

	# Field Sep
	FS="[,=]"


	hn    = split(order,ORDER,/,/)
	
}
{
	A[$1,tolower($2)] = $3
	if(!tmp[$1]++)
	{
		SEQ[++c] = $1
	}
}
END{
	delete tmp;
	
	for(i=1; i<=c; i++)
	{
		str = SEQ[i]
		for(j=1; j<=hn; j++)
		{
			if(!Is_header_printed)
			{
				header = header OFS toupper(ORDER[j])
			}
			
			key = SEQ[i] SUBSEP ORDER[j] 
	
			if( key in A )
			{
				str = str OFS A[key]
				delete A[key]
			}else
			{
				str = str OFS "NaN"
			}    
		}
		
		if(!Is_header_printed)
		{
			print header
			Is_header_printed = !Is_header_printed
		}

		print str
	}
}

$ awk -vOFS="," -f parse.awk infile
RECORD,ID,ORG,CN,SN,UID
1,1000,CedarparkHospital,john,doe,User001
2,2000,Providence,steve,jobs,User002

sort -k 1 col2rodata -o col2rodata

ro=1
lines=
sort -k 1 "${@}" | while read line
do