Renaming multiple file names inside a folder

Question

Post reply

Renaming multiple file names inside a folder

hussainismail

SSC Enthusiast

Points: 174
More actions
September 16, 2014 at 4:41 pm

#310949

Hi,
I have a folder contains 3 files with 3 different file names ending _datestamp.txt.
for example in my folder c:\filesfolder has companyAllDemo_09162014.txt, companyAllProd_09162014.txt & companyAllTrans_09162014.txt. i need to rename them & remove the date stamp, inside the same folder so the file names changes to companyAllDemo.txt, companyAllProd.txt & companyAllTrans.txt. any help, comment and feedback would be deeply appreciated.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Mr. Cursor Old Hand Points: 385 More actions · Answer 1

I'd use a script task and make use of the methods in the My.Computer.FileSystem namespace.

hussainismail SSC Enthusiast Points: 174 More actions · Answer 2

Hi Grasshopper,

i am very new in ssis and is there a way, i can get an example. i tried to search but everyone is moving files then renaming it.

marc.heidemann SSC-Addicted Points: 484 More actions · Answer 3

Are you trying to automate this as a daily task or a one off?

Personally I would create a script, either vbs or batch that renamed the files and schedule the script to run daily in task scheduler or an agent job, but that's just the way I have always done it.

hussainismail SSC Enthusiast Points: 174 More actions · Answer 4

not daily basis but i guess i also use c# script to rename the files. thanks everyone..i do appreciate everyone's input..

wahidhaq7 Newbie Points: 9 More actions · Answer 5

I suggest everyone to try KrojamSoft BatchRenameFiles program. It’s really work for me.

Michael L John One Orange Chip Points: 27060 More actions · Answer 6

REN *_09162014.txt *.txt

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 7

Michael L John (1/3/2015)
REN *_09162014.txt *.txt

+1000. I love the "old ways". So simple.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)