Exrpession to clean up dates

Fellow Forum Members,

I need help with writing an expression that will do the following:

2009 . 01 . 16 . Georgia

Change to :

2009.01.16 Georgia

I tried:

/d . /d

but it does not work because the "period" character conflicts with the expression itself.

Any help will be appreciated.

---

Reply to #1:

You want to do two things together: replace space-period-space between digits only AND between digits and char.
So I would do this in two steps with two Replace Methods:

1.) Replace "space period space" by an period

Replace Method
Find : " \. "
Replace: "."
Occ : All
[X] RegEx

Result:
2009.01.16.Georgia


2.) Replace "period followed by an non-Digit" by that non-Digit sign

Replace Method
Find : "\.(\D)"
Replace: ".$1"
Occ : All
[X] RegEx

Result:
2009.01.16 Georgia

.

.

---