Hi, i have a file called sc.txt
cat sc.txt
ecf0183.sh
ecf1002.sh
ecf1011.sh
ecf1020.sh
another file callled All.csv
Type,S Name,Mem Lib,S Id,S Table,App,Group
Reg sch,ecf1002,Link from 1,pcor1,EER,ecf1002.sh,ECF-D-LND-AMZ-A
Reg sch,ecf1002a,Link from 2,pcor1,EER,ecf1002.sh,ECF-D-LND-AX-B
Reg sch,ecf1011ab,Link from 4,pcor1,EER,ecf1011.sh,EW-G-LND-AX-C
Reg sch,ecf1020rt,Link from 9,pcor1,EER,ecf1020.sh,EW-G-JYD-GEX-D
i need to take the sc.txt as a reference and need to compare with All.csv and then need to create a file as below. please help me with the code
sc S Name S id Group
ecf0183.sh NA NA NA
ecf1002.sh ecf1002 pcor1 ECF-D-LND-AMZ-A
ecf1002a pcor1 ECF-D-LND-AX-B
ecf1011.sh ecf1011ab pcor1 EW-G-LND-AX-C
ecf1020.sh ecf1020rt pcor1 EW-G-JYD-GEX-D