Add fullstop before second capital letter.

[TomTom]

Hi.

I have a list of filenames such as

JoeBlogs_Export_0001.pst

I need them to read

Joe.Blogs@domain.com.001.pst


I haven't used regular expressions to any extent. Is this possible? I'm happy to do some reading, but have absolutely no knowledge/experience in this area.


Many thanks


Tom

[Stefan]

FROM:
JoeBlogs_Export_0001.pst
TO:
Joe.Blogs@domain.com.001.pst

That's:
- add an dot before upper case letter
- replace "_0" with nothing
- replace "_Export" by "@domain.com."

Seams possible:
If all your file names has the very same pattern!
* only two upper case letters before the first underscore
* all have four digits after the second underscore to be shorted to three
* for all the middle between first and second underscore is to replaced by your @dom string
If that is the truth, we can try to solve this.

[Stefan]

I wanted to add: "provide more examples of your real file names"

but i was not able to modify my post. The "edit"-button is gone.



.

[TomTom]

Hi.

Thanks so much for getting back to me!

The file name convention at the moment is [Firstname][Secondname](underscore)[Export](underscore)[a four digit umber starting at 0001 with leading zeros][.pst]

There'll be several of these files for each user, so the number will be incremented.


As long as the new filename starts with [firstname].[secondname]@domain.com. then the number can be more or less anything, it won't matter about the leading zeros. (I think!)

Other (made up) examples are:

JimSmith_Export_0001.pst
JimSmith_Export_0002.pst
DaveJones_Export_0001.pst
MikeBrown_Export_0023.pst



Thanks again.


Tom