UNIX for Beginners Questions & Answers

empname,place,empdep
aaaa ,city1,001
bbbb,city2,sign-1
dddd,city1,005
ffff,city5,sign-2
hhhh,city7,sign-1

empname ,new
aaaa ,001 
bbbb,002
cccc,003
dddd ,005
eeee,006
ffff,007
gggg,008
hhhh,009

empname,place,empdep
aaaa ,city1,001
bbbb,city2,002
dddd,city1,005
ffff,city5,007
hhhh,city7,009

awk -F, 'NR==FNR {T[$1]=$2; next} $3 ~ /^sign/ {$3=T[$1]} 1' OFS=, file2 file1
empname,place,empdep
aaaa ,city1,001
bbbb,city2,002
dddd,city1,005
ffff,city5,007
hhhh,city7,009

awk -F| 'NR==FNR {T[$1]=$2; next} $7 ~ /^Sync/ {$7=T[$1]} 1' OFS=| file2.csv file1.csv

awk: A flag requires a parameter: F
Usage: awk [-u] [-F Character][-v Variable=Value][-f File|Commands][Variable=Value|File ...]
ksh: NR==FNR {T[$1]=$2; next} $7 ~ /^Sync/ {$7=T[$1]} 1:  not found.

awk 'BEGIN{ FS=OFS="|" }; NR==FNR {T[$1]=$2; next} $7 ~ /^sign {$7=T[$1]} 1' OFS="|" file1.csv file2.csv> final.csv

 xfsgdh|gdjshd|bbbb|20191228|230||sign-1|14420|44766|||||||20191228 ---  original 

xfsgdh|gdjshd|bbbb|20191228|230|||14420|44766|||||||20191228 -  result after code