awk 匹配，记录

目的，c11对应的第一列的值匹配vm-resourece的第一列后添加到一列，也可以是其他列

awk -F, 'NR==FNR{gsub(/"/, "", $2); a[$1]=$2; next} {gsub(/"/, "", $1); if($1 in a)print a[$1] "," $0}' c11.csv vm-resouce.csv > out1.csv

 more c11.csv 
y1_tzfx11_oradb00111,数据处业务
y1_tzfx11.jxpg_ap00111,数据处业务
y1_tzsj11_oradb00111,数据处业务


 more vm-resouce.csv 
主机名,主机状态,cpu,内存,操作系统,IP,,磁盘,ESXI_IP,创建时间,磁盘容量
y1_jrsc11_sczj_db001,poweredOn,32,64,rhel 7,10.114.24.219,10.4.24.29,Hard disk 1/150.0; Hard disk 2/4096.0,10.18.144.41,2023/7/27 6:42,4246
y1_tzsj11_oradb001,poweredOn,16,128,rhel 7,10.115.25.1,110.5.25.1,Hard disk 1/150.0; Hard disk 2/4096.0,10.18.44.223,2023/8/2 3:23,4246
y1_tzfx11_oradb001,poweredOn,16,128,rhel 7,10.115.25.2,110.5.25.2,Hard disk 1/150.0; Hard disk 2/4096.0,10.18.44.223,2023/8/2 3:23,4246

效果