Rename software | Excel function? | please help!

Soldato
Joined
30 Aug 2003
Posts
14,225
Location
Straya
Hi all

In quite a bit of a pinch at the moment and need something done for work urgently, that is holding up launch of a clients site!

I have a bunch of images (see below for example) that I need renaming.

Code:
10169452.104593314.rgb.jpg
10175696.92213957.rgb.jpg
13555_RetouchMenu.99559625.cmyk.jpg
13620_Sugar_.99559627.cmyk.jpg
18.05.2007.101680122.zip
200025447-001.93107065.rgb.jpg
200025447-001.93498414.rgb.jpg
200025447-001.jpg
200112272-001.94422443.rgb.jpg
I need everything excluding the file extention, that falls after the first fullstop i.e.

10169452.104593314.rgb.jpg turns into 10169452.jpg

Can anyone do this for me (if I list all the files here) or could tell me how to do it?

MANY thanks!
 
I think you could get a plugin for excel that will allow for regex find and replace... so you could use that if you find a plugin.

Not an excel guru or anything.
 
Back
Top Bottom