Remove characters after file extension

[markp]

Hello

Happy New Year to Everyone

I have an issue where for some obscure reason when I moved the files in windows, a shed load of files where characters have been inserted after the file extension basically the file name is just a mess e.g.

0.1 Student Arrival Process-2.xlsx.vsdx-2-1-2

I would like the file name to be Student Arrival Process.xlsx (removing the characters before the name and after the file extension. I've been trying to work out how to do this using pattern matching but nothing works. I'm a novice, I know nothing about scripts etc. can anyone help because I have a 30,000 files like this to fix.

Would appreciate any help you can give. Thanks Mark

[Mr_Noodle]

Can you post what kind of patterns you've tried? How do you know what part of the name is the part you want to save?