Batch rename files using correspondent values
I have a folder full of files, with names composed of 7 digits number. For each of these numbers, I have a correspondent name, saved in an excel file, separated into two columns. Usually, I check line by line and rename file by file, but since the numbers are correspondent, is there a way for me to mass rename the files, using their correspondent values in the table? If needed I can save the table in a txt file separated by tabulation.
windows-7 batch batch-rename
asked Feb 14 at 14:31
Vinícius SimõesVinícius Simões
701111
add a comment |
I have a folder full of files, with names composed of 7 digits number. For each of these numbers, I have a correspondent name, saved in an excel file, separated into two columns. Usually, I check line by line and rename file by file, but since the numbers are correspondent, is there a way for me to mass rename the files, using their correspondent values in the table? If needed I can save the table in a txt file separated by tabulation.
windows-7 batch batch-rename
asked Feb 14 at 14:31
Vinícius SimõesVinícius Simões
701111
You should be able to do this but I'd say show an example of the exported data in csv format and show an example of the file names or whatever that correlate to the data from the csv file and then show a before and after example to make it super clear what you are trying to accomplish. You may be able to do with a batch file easily but your detail needs clarified a little more for someone like me to help with a solution.
– Pimp Juice IT
Feb 14 at 14:53
add a comment |
I have a folder full of files, with names composed of 7 digits number. For each of these numbers, I have a correspondent name, saved in an excel file, separated into two columns. Usually, I check line by line and rename file by file, but since the numbers are correspondent, is there a way for me to mass rename the files, using their correspondent values in the table? If needed I can save the table in a txt file separated by tabulation.
windows-7 batch batch-rename
asked Feb 14 at 14:31
Vinícius SimõesVinícius Simões
701111
I have a folder full of files, with names composed of 7 digits number. For each of these numbers, I have a correspondent name, saved in an excel file, separated into two columns. Usually, I check line by line and rename file by file, but since the numbers are correspondent, is there a way for me to mass rename the files, using their correspondent values in the table? If needed I can save the table in a txt file separated by tabulation.
windows-7 batch batch-rename
windows-7 batch batch-rename
asked Feb 14 at 14:31
Vinícius SimõesVinícius Simões
701111
asked Feb 14 at 14:31
Vinícius SimõesVinícius Simões
701111
asked Feb 14 at 14:31
Vinícius SimõesVinícius Simões
701111
asked Feb 14 at 14:31
Vinícius SimõesVinícius Simões
701111
asked Feb 14 at 14:31
Vinícius SimõesVinícius Simões
701111
701111
You should be able to do this but I'd say show an example of the exported data in csv format and show an example of the file names or whatever that correlate to the data from the csv file and then show a before and after example to make it super clear what you are trying to accomplish. You may be able to do with a batch file easily but your detail needs clarified a little more for someone like me to help with a solution.
– Pimp Juice IT
Feb 14 at 14:53
add a comment |
You should be able to do this but I'd say show an example of the exported data in csv format and show an example of the file names or whatever that correlate to the data from the csv file and then show a before and after example to make it super clear what you are trying to accomplish. You may be able to do with a batch file easily but your detail needs clarified a little more for someone like me to help with a solution.
– Pimp Juice IT
Feb 14 at 14:53
You should be able to do this but I'd say show an example of the exported data in csv format and show an example of the file names or whatever that correlate to the data from the csv file and then show a before and after example to make it super clear what you are trying to accomplish. You may be able to do with a batch file easily but your detail needs clarified a little more for someone like me to help with a solution.
– Pimp Juice IT
Feb 14 at 14:53
You should be able to do this but I'd say show an example of the exported data in csv format and show an example of the file names or whatever that correlate to the data from the csv file and then show a before and after example to make it super clear what you are trying to accomplish. You may be able to do with a batch file easily but your detail needs clarified a little more for someone like me to help with a solution.
– Pimp Juice IT
Feb 14 at 14:53
add a comment |
1 Answer
1
active
oldest
votes
What I normally do is use Excel's (or LibreOffice's) CONCAT function to generate valid commands (along the line of REN "numberedfile" "newfilename"), then I copy-paste this column into a text file and rename it to .bat and execute it.
Basically I move the harder work of fiddling filenames in cmd to the easier work of fiddling them in Excel.
answered Feb 14 at 14:41
Eugen RieckEugen Rieck
11.2k22429
Interesting idea. I'll try it later.
– Vinícius Simões
Feb 14 at 15:56
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1405717%2fbatch-rename-files-using-correspondent-values%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
What I normally do is use Excel's (or LibreOffice's) CONCAT function to generate valid commands (along the line of REN "numberedfile" "newfilename"), then I copy-paste this column into a text file and rename it to .bat and execute it.
Basically I move the harder work of fiddling filenames in cmd to the easier work of fiddling them in Excel.
answered Feb 14 at 14:41
Eugen RieckEugen Rieck
11.2k22429
Interesting idea. I'll try it later.
– Vinícius Simões
Feb 14 at 15:56
add a comment |
What I normally do is use Excel's (or LibreOffice's) CONCAT function to generate valid commands (along the line of REN "numberedfile" "newfilename"), then I copy-paste this column into a text file and rename it to .bat and execute it.
Basically I move the harder work of fiddling filenames in cmd to the easier work of fiddling them in Excel.
answered Feb 14 at 14:41
Eugen RieckEugen Rieck
11.2k22429
Interesting idea. I'll try it later.
– Vinícius Simões
Feb 14 at 15:56
add a comment |
What I normally do is use Excel's (or LibreOffice's) CONCAT function to generate valid commands (along the line of REN "numberedfile" "newfilename"), then I copy-paste this column into a text file and rename it to .bat and execute it.
Basically I move the harder work of fiddling filenames in cmd to the easier work of fiddling them in Excel.
answered Feb 14 at 14:41
Eugen RieckEugen Rieck
11.2k22429
What I normally do is use Excel's (or LibreOffice's) CONCAT function to generate valid commands (along the line of REN "numberedfile" "newfilename"), then I copy-paste this column into a text file and rename it to .bat and execute it.
Basically I move the harder work of fiddling filenames in cmd to the easier work of fiddling them in Excel.
answered Feb 14 at 14:41
Eugen RieckEugen Rieck
11.2k22429
answered Feb 14 at 14:41
Eugen RieckEugen Rieck
11.2k22429
answered Feb 14 at 14:41
Eugen RieckEugen Rieck
11.2k22429
answered Feb 14 at 14:41
Eugen RieckEugen Rieck
11.2k22429
11.2k22429
Interesting idea. I'll try it later.
– Vinícius Simões
Feb 14 at 15:56
add a comment |
Interesting idea. I'll try it later.
– Vinícius Simões
Feb 14 at 15:56
Interesting idea. I'll try it later.
– Vinícius Simões
Feb 14 at 15:56
Interesting idea. I'll try it later.
– Vinícius Simões
Feb 14 at 15:56
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1405717%2fbatch-rename-files-using-correspondent-values%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
You should be able to do this but I'd say show an example of the exported data in csv format and show an example of the file names or whatever that correlate to the data from the csv file and then show a before and after example to make it super clear what you are trying to accomplish. You may be able to do with a batch file easily but your detail needs clarified a little more for someone like me to help with a solution.
– Pimp Juice IT
Feb 14 at 14:53