Change date format in file name and format file name

I have files named, "2017.07.21 My File Name"

I want to rename to, "20170721 - My File Name"

Any help??

---

Reply to #1:
I think you could do it in two steps:

Using "Replace"
Text to be replaced: -
Replace with:

.... and leave the "Replace with" section empty. You can verify this under new file name. Run this edit.

second step
Using "Replace"
Text to be replaced: My File Name
Replace with: - My File Name

Edit:

As long as all of your dates are the same length, you can use "Add" with - at the specific index (spot) of the file name

---

Reply to #1:
Another Option is to make a list of the files in excel (pretty easy) and then use a tool to remove the "."

You can use text to columns to separate the different portions of the file name and then "concatenate" to stitch everything together in the way you want. Save as a csv and use the import in AR to rename. But there is probably an easier way someone else knows.

Edit: Don't use this option, it is much easier to use the "Add" for put the dash in where you want it

---

Reply to #1:

The previous solution does not appear to deal with the change in date (dots).

You can try this (no quotes) -

REMOVE PATTERN (same idea with "Replace Method")
Pattern: "."
Replace with: empty

ADD
Add: " -"
At Index: "<Word:1>"

---