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
Solved! Go to 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.
Nice, both works. Thanks so much!
Kamen