Remove all dots from a file name except dots from a date

Hi everybody,

i have some files with a date in the middle of the name (dd.mm.yy) and all spaces in the name are also points like "filename.10.08.2024.output.machine1.laboratory.d.csv" and i want to remove all dots from the filename execpt dots from date.

How can i realize it.

many thanks

Shawn

Reply to #1:

Hi Shawn, welcome,

An easy way to do that would be to replace all the periods with spaces first, then change the spaces in the dates back to periods using the date pattern as a guide for ARen, like this:

REPLACE method 1:

Replace: . (just a period, nothing else)
Replace with: " " (no quotes, just a space
Make sure regular expressions are off and Occurrence is "All".
Applies to: Name

REPLACE method 2:

Replace: (\d\d) (\d\d) (\d{4})
Replace with: $1.$2.$3
Regular Expressions: Checked

Here's the result:
https://drive.google.com/file/d/1G1RiEiYBpWJ9dz8 _bpZK8QHeHx5kw7ZC/view?usp=sharing

Best,
DF

Reply to #2:

It works as i need it. Thank you very much for your help.

Shawn