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
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_bpZK8QHeHx5 kw7ZC/view?usp=sharing
Best,
DF
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_bpZK8QHeHx5 kw7ZC/view?usp=sharing
Best,
DF
Reply to #2:
It works as i need it. Thank you very much for your help.
Shawn
It works as i need it. Thank you very much for your help.
Shawn