Hi,
I have a list of files in a directory. I want to sort them based on a section of their name. All files have the same format where the x could be any amount of digits. How would i go about sorting them based on what is in the second set of parenthesis?
(xxxxxxx)(xxxxxx)(xxxxxxxx).xlsx
I was looking to use regex but i am unsure of the syntax needed.
Thanks for the help