Get or Extract the Main Filename

[KamenRider]

Hi,

Can I ask for your ideas on how to get those main files and their duplicates. The exact number of characters is 38. For example, for those list below:

BWM Rainy Peace Orions 2021.12.14.xlsm
BWM Rainy Peace Orions 2022.07.18.xlsm
BWM Rainy Peace Orions 2022.07.18.xlsm error
BWM Rainy Peace Orions 2022.07.18.xlsm_error
BWM Rainy Peace Orions 2024.03.14.xlsm
BWM Rainy Peace Orions 2024.03.14.xlsm_bad
BWM Rainy Peace Orions 2024.03.14.xlsm_new
BWM Rainy Peace Orions 2024.03.14.xlsm_orig
BWM Rainy Peace Orions 2024.03.14.xlsm - New
BWM Rainy Peace Orions 2024.03.14.xlsm_Johnny

I would like to list only as follows:

BWM Rainy Peace Orions 2021.12.14.xlsm

BWM Rainy Peace Orions 2024.03.14.xlsm

Hope to see your ideas.

Thanks,

Kamen

[usmanbashir · Accepted solution]

@KamenRider - I provided two options to filter the file names.

1) length([filename]) = 38

2) REGEX_Match([filename], 'BWM Rainy Peace Orions \d{4}.\d{2}.\d{2}.xlsm')

Please also see attached workflow. Let me know if this isn't what you were looking for.

[KamenRider]

Nice, both works. Thanks so much!

Kamen