我有两个文件
FileA.txt
ID
479432_Sros_4274
330214_NIDE2792
517722_CJLT1_010100003977
257310_BB0482
...
FileB.txt(**仅用于帮助您识别匹配项)
members category
6085.XP_002168109,**479432_Sros_4274**,4956.XP_002495993.1,457425.SSHG_03214,51511.ENSCSAVP000 P
7159.AAEL006372-PA,**257310_BB0482** J
**517722_CJLT1_010100003977**,701176.VIBRN418_17773,9785.ENSLAFP00000010769,28377.ENSACAP00000014901,4081.Solyc03g120250.2.1,3847.GLYMA18G02240.1 U
500485.XP_002561312.1,1042876.PPS_0730,222929.XP_003071446.1,**330214_NIDE2792** S
...
预期产量
Output.txt
ID category
479432_Sros_4274 P
330214_NIDE2792 S
517722_CJLT1_010100003977 U
257310_BB0482 J
...
基于对其他问题的回答,我已经在awk和R中尝试了一些代码,但无法获得所需的输出。