find help

There are the following file names in table 1, i want to get the name in table 2, but i won't write this to run the script。
table 1:
werwe_ehgswer_gdg_dfwef.dwg
jl452lk3j4_dfjlksanlwekt5_lafkjwoefng.dwg
awek_dkjflawe_fwe3r2o3nfan_dfklwesdefawebh.dwg
table 2:
werwe_ehgswerf.dwg
jl452lk3j4_dfjlksanlwekt5.dwg
awek_dkjflawe.dwg
Reply to #1:
It seems that there is no one to help, then I will take it slow and change it manually first
It is better to ask yourself than to ask others,, and finally solved it.