I'm new here and I'm hoping that someone would be kind enough to help out with a dilemma that I've been wrestling with for the past few hours. I would be EXTREMELY greatful
Here it goes:
I am trying to rename a couple hundred doc and docx scientific abstract files which were collected from an online submission form. I have a tab delimited "readme" file which which includes the submiter's first and last name, file name, and the type of abstract submitted. There are up to 4 types of abstracts that can be submitted which are listed in a column as well. They include the following:
-"Abstract Upload (for Oral presentation):"
-"Poster Abstract Upload:"
-"Poster Abstract Upload 2:"
-"Poster Abstract Upload 3:"
*w/o quotes
*many individuals submit more than one type
What I would like to accomplish is renaming the existing files to the following: "lastname"_"firstname"_"abstracttype"."doc or docx"
*I will rename the above four types to just oral, post, post2,post3.
I have found some vba scripts which function by replacing the existing file name for another defined file name. I'm not sure if I should be looking for a way to create the desired file type in a new column first then run such a script or is there a script that can do everything in one step? I'm really a newbie when it comes to this kind of thing.
Any help would be greatly appreciated.
The following illustrates what I want:
Name: "Test, Joe,"
Type: "Poster Abstract Upload:"
Original File Name: "Raw Abstract.doc"
Final File Name: "test_joe_poster.doc"
The tab delimited file is structured as such and includes the quotes:
"test,joe" / Abstract Upload (for Oral presentation): / Oral Abstract.doc
"test2, joe2" / Poster Abstract Upload 2: / Poster Abstract 2.docx
and so on....
/ = new column
Here it goes:
I am trying to rename a couple hundred doc and docx scientific abstract files which were collected from an online submission form. I have a tab delimited "readme" file which which includes the submiter's first and last name, file name, and the type of abstract submitted. There are up to 4 types of abstracts that can be submitted which are listed in a column as well. They include the following:
-"Abstract Upload (for Oral presentation):"
-"Poster Abstract Upload:"
-"Poster Abstract Upload 2:"
-"Poster Abstract Upload 3:"
*w/o quotes
*many individuals submit more than one type
What I would like to accomplish is renaming the existing files to the following: "lastname"_"firstname"_"abstracttype"."doc or docx"
*I will rename the above four types to just oral, post, post2,post3.
I have found some vba scripts which function by replacing the existing file name for another defined file name. I'm not sure if I should be looking for a way to create the desired file type in a new column first then run such a script or is there a script that can do everything in one step? I'm really a newbie when it comes to this kind of thing.
Any help would be greatly appreciated.
The following illustrates what I want:
Name: "Test, Joe,"
Type: "Poster Abstract Upload:"
Original File Name: "Raw Abstract.doc"
Final File Name: "test_joe_poster.doc"
The tab delimited file is structured as such and includes the quotes:
"test,joe" / Abstract Upload (for Oral presentation): / Oral Abstract.doc
"test2, joe2" / Poster Abstract Upload 2: / Poster Abstract 2.docx
and so on....
/ = new column
Last edited: