Upcctns script to replace a entry in ldif file

Scenario : There were two files("test", "test.ldif"), in 1st file("test") there were two fields, one field contained a numeric value(i.e. 772760042) and other field contained a string value(i.e. test str). In the 2nd file("test.ldif") there was a entry like "cn: 772760042".

"test" file:-

772760042, test str

"test.ldif" file:-

dn: uid=772760042,ou=upcctns.gov.in,dc=upcctns,dc=gov,dc=in

objectClass: top

objectClass: inetOrgPerson

objectClass: qmailUser

cn: 772760042 <---

sn: 772760042

mail: 772760042@upcctns.gov.in

accountStatus: active

mailMessageStore: upcctns.gov.in/772760042

uid: 772760042

mailHost: mail.upcctns.gov.in

deliveryMode: noforward

What was needed is we had to read the numeric value(i.e. 772760042) from 1st file("test") and search it in the 2nd file("test.ldif") and then replace the entry("cn: 772760042") with the 2nd field("test str") from 1st file("test")

After running the script the "test.ldif" file should look like

dn: uid=772760042,ou=upcctns.gov.in,dc=upcctns,dc=gov,dc=in

objectClass: top

objectClass: inetOrgPerson

objectClass: qmailUser

cn: test str <---

sn: 772760042

mail: 772760042@upcctns.gov.in

accountStatus: active

mailMessageStore: upcctns.gov.in/772760042

uid: 772760042

mailHost: mail.upcctns.gov.in

deliveryMode: noforward

Script:-

  #!/bin/bash
  INPUT_FILE=/home/tetra/Downloads/rakesh/test
  OUTPUT_FILE=/home/tetra/Downloads/rakesh/test.ldif
  #count=1
  while IFS=, read -r f1 f2 
  do
  #echo "cn: $f1" "cn: $f2"
  #echo $count pass
  #count=$(( $count + 1 ))
  awk -v old="cn: $f1" -v new="cn: $f2" '{ sub(old,new); print $0 }' "$OUTPUT_FILE" > ex
  cat ex > "$OUTPUT_FILE"
  done < $INPUT_FILE