Delete .pdf files only if .xlsx files in directory have same filename?

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP











up vote
3
down vote

favorite












I have folders with hundreds of pdf and xls(x) files that were mass exported from legal e-discovery systems. The filenames in these exports correspond to bates # such as ABCD_00000001.pdf, ABCD_00000002.pdf, ... , ABCD_00002000.pdf. These mass exports include a blank pdf file for every single xls(x) file - with both having the exact same filename. E.g., ABCD_00000005.xlsx is the xlsx file that was produced in the ediscovery system and ABCD_00000005.pdf is an extraneous blank pdf file that was created in the mass export.



These extraneous .pdf files probably result from a user error on the part of the people running these mass exports, but I don't usually have control over that side of the process. So I wanted to know if any relatively straightforward way to delete these extraneous .pdf without forcing someone to go through them manually.






bash shell files directory rm







share|improve this question



















  • 1




    Are they .xls or .xlsx? Or could they be either? Why can't you just delete all pdf files in that directory? Are there some pdf files you would like to save?
    – Jesse_b
    Aug 10 at 16:28














up vote
3
down vote

favorite












I have folders with hundreds of pdf and xls(x) files that were mass exported from legal e-discovery systems. The filenames in these exports correspond to bates # such as ABCD_00000001.pdf, ABCD_00000002.pdf, ... , ABCD_00002000.pdf. These mass exports include a blank pdf file for every single xls(x) file - with both having the exact same filename. E.g., ABCD_00000005.xlsx is the xlsx file that was produced in the ediscovery system and ABCD_00000005.pdf is an extraneous blank pdf file that was created in the mass export.



These extraneous .pdf files probably result from a user error on the part of the people running these mass exports, but I don't usually have control over that side of the process. So I wanted to know if any relatively straightforward way to delete these extraneous .pdf without forcing someone to go through them manually.






bash shell files directory rm







share|improve this question



















  • 1




    Are they .xls or .xlsx? Or could they be either? Why can't you just delete all pdf files in that directory? Are there some pdf files you would like to save?
    – Jesse_b
    Aug 10 at 16:28












up vote
3
down vote

favorite









up vote
3
down vote

favorite











I have folders with hundreds of pdf and xls(x) files that were mass exported from legal e-discovery systems. The filenames in these exports correspond to bates # such as ABCD_00000001.pdf, ABCD_00000002.pdf, ... , ABCD_00002000.pdf. These mass exports include a blank pdf file for every single xls(x) file - with both having the exact same filename. E.g., ABCD_00000005.xlsx is the xlsx file that was produced in the ediscovery system and ABCD_00000005.pdf is an extraneous blank pdf file that was created in the mass export.



These extraneous .pdf files probably result from a user error on the part of the people running these mass exports, but I don't usually have control over that side of the process. So I wanted to know if any relatively straightforward way to delete these extraneous .pdf without forcing someone to go through them manually.






bash shell files directory rm







share|improve this question















I have folders with hundreds of pdf and xls(x) files that were mass exported from legal e-discovery systems. The filenames in these exports correspond to bates # such as ABCD_00000001.pdf, ABCD_00000002.pdf, ... , ABCD_00002000.pdf. These mass exports include a blank pdf file for every single xls(x) file - with both having the exact same filename. E.g., ABCD_00000005.xlsx is the xlsx file that was produced in the ediscovery system and ABCD_00000005.pdf is an extraneous blank pdf file that was created in the mass export.



These extraneous .pdf files probably result from a user error on the part of the people running these mass exports, but I don't usually have control over that side of the process. So I wanted to know if any relatively straightforward way to delete these extraneous .pdf without forcing someone to go through them manually.






bash shell files directory rm




bash shell files directory rm






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Aug 10 at 16:28









Jesse_b

10.5k22659




10.5k22659










asked Aug 10 at 16:26









ck_chicago

161




161







  • 1




    Are they .xls or .xlsx? Or could they be either? Why can't you just delete all pdf files in that directory? Are there some pdf files you would like to save?
    – Jesse_b
    Aug 10 at 16:28












  • 1




    Are they .xls or .xlsx? Or could they be either? Why can't you just delete all pdf files in that directory? Are there some pdf files you would like to save?
    – Jesse_b
    Aug 10 at 16:28







1




1




Are they .xls or .xlsx? Or could they be either? Why can't you just delete all pdf files in that directory? Are there some pdf files you would like to save?
– Jesse_b
Aug 10 at 16:28




Are they .xls or .xlsx? Or could they be either? Why can't you just delete all pdf files in that directory? Are there some pdf files you would like to save?
– Jesse_b
Aug 10 at 16:28










2 Answers
2






active

oldest

votes

















up vote
6
down vote













Loop over the pdf files, use parameter expansion to extract the basename:



#!/bin/bash
for pdf in *.pdf ; do
 basename=$pdf%.pdf
 if [[ -f $basename.xls || -f $basename.xlsx ]] ; then
 rm "$pdf"
 fi
done


Update: I got the logic backwards, should be fixed now. Sorry.






share|improve this answer






















  • Added slightly more efficient alternative. If this folder is extensive, it could make a difference in processing time.
    – Xalorous
    Aug 10 at 17:00










  • @Xalorous: But your "alternative" removed the files my solution tried to keep.
    – choroba
    Aug 10 at 17:01











  • It's possible that I pasted the wrong one. I'll post a separate answer with the more efficient version.
    – Xalorous
    Aug 10 at 17:04










  • I agree with your decision to reject the suggested edit — new answers should be posted as new answers, not edits.  But I believe that Xalorous got it right and you (choroba) got it backwards.  If ABCD_0000005.xlsx and ABCD_0000005.pdf both exist, your code leaves ABCD_0000005.pdf alone.  But if important.pdf exists, and there’s no corresponding spreadsheet, your code deletes important.pdf.
    – G-Man
    Aug 10 at 17:43











  • Actually, I missed that his logic is inverted. Taking out the ! would fix it though. The real question is what if there's a pdf without matching xls(x). What does OP want to happen then? If they want them gone, then they need to just rm -rf *.pdf. If not, then my answer. Reading the question strictly, we're only to delete pdf files with matching xls(x) files.
    – Xalorous
    Aug 10 at 17:51


















up vote
3
down vote













Loop over the .xls(x) files and remove matching pdf files.



for xls in *.xls* ; do
 /bin/rm -f "$xls%.xls*"".pdf"
done


If there's no matching pdf it won't hurt anything.






share|improve this answer




















  • You don’t really need the ""; i.e., you could do /bin/rm -f "$xls%.xls*.pdf".  But this looks like it should work.
    – G-Man
    Aug 10 at 17:42










  • I tried it both ways, the match failed without the "" in the middle. Or maybe I made a different mistake at the same time. I'm new to bash.
    – Xalorous
    Aug 10 at 17:46










Your Answer







StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "106"
;
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',
convertImagesToLinks: false,
noModals: false,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);













 

draft saved


draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f461844%2fdelete-pdf-files-only-if-xlsx-files-in-directory-have-same-filename%23new-answer', 'question_page');

);

Post as a guest

















2 Answers
2






active

oldest

votes








2 Answers
2






active

oldest

votes









active

oldest

votes






active

oldest

votes








up vote
6
down vote













Loop over the pdf files, use parameter expansion to extract the basename:



#!/bin/bash
for pdf in *.pdf ; do
 basename=$pdf%.pdf
 if [[ -f $basename.xls || -f $basename.xlsx ]] ; then
 rm "$pdf"
 fi
done


Update: I got the logic backwards, should be fixed now. Sorry.






share|improve this answer






















  • Added slightly more efficient alternative. If this folder is extensive, it could make a difference in processing time.
    – Xalorous
    Aug 10 at 17:00










  • @Xalorous: But your "alternative" removed the files my solution tried to keep.
    – choroba
    Aug 10 at 17:01











  • It's possible that I pasted the wrong one. I'll post a separate answer with the more efficient version.
    – Xalorous
    Aug 10 at 17:04










  • I agree with your decision to reject the suggested edit — new answers should be posted as new answers, not edits.  But I believe that Xalorous got it right and you (choroba) got it backwards.  If ABCD_0000005.xlsx and ABCD_0000005.pdf both exist, your code leaves ABCD_0000005.pdf alone.  But if important.pdf exists, and there’s no corresponding spreadsheet, your code deletes important.pdf.
    – G-Man
    Aug 10 at 17:43











  • Actually, I missed that his logic is inverted. Taking out the ! would fix it though. The real question is what if there's a pdf without matching xls(x). What does OP want to happen then? If they want them gone, then they need to just rm -rf *.pdf. If not, then my answer. Reading the question strictly, we're only to delete pdf files with matching xls(x) files.
    – Xalorous
    Aug 10 at 17:51















up vote
6
down vote













Loop over the pdf files, use parameter expansion to extract the basename:



#!/bin/bash
for pdf in *.pdf ; do
 basename=$pdf%.pdf
 if [[ -f $basename.xls || -f $basename.xlsx ]] ; then
 rm "$pdf"
 fi
done


Update: I got the logic backwards, should be fixed now. Sorry.






share|improve this answer






















  • Added slightly more efficient alternative. If this folder is extensive, it could make a difference in processing time.
    – Xalorous
    Aug 10 at 17:00










  • @Xalorous: But your "alternative" removed the files my solution tried to keep.
    – choroba
    Aug 10 at 17:01











  • It's possible that I pasted the wrong one. I'll post a separate answer with the more efficient version.
    – Xalorous
    Aug 10 at 17:04










  • I agree with your decision to reject the suggested edit — new answers should be posted as new answers, not edits.  But I believe that Xalorous got it right and you (choroba) got it backwards.  If ABCD_0000005.xlsx and ABCD_0000005.pdf both exist, your code leaves ABCD_0000005.pdf alone.  But if important.pdf exists, and there’s no corresponding spreadsheet, your code deletes important.pdf.
    – G-Man
    Aug 10 at 17:43











  • Actually, I missed that his logic is inverted. Taking out the ! would fix it though. The real question is what if there's a pdf without matching xls(x). What does OP want to happen then? If they want them gone, then they need to just rm -rf *.pdf. If not, then my answer. Reading the question strictly, we're only to delete pdf files with matching xls(x) files.
    – Xalorous
    Aug 10 at 17:51













up vote
6
down vote










up vote
6
down vote









Loop over the pdf files, use parameter expansion to extract the basename:



#!/bin/bash
for pdf in *.pdf ; do
 basename=$pdf%.pdf
 if [[ -f $basename.xls || -f $basename.xlsx ]] ; then
 rm "$pdf"
 fi
done


Update: I got the logic backwards, should be fixed now. Sorry.






share|improve this answer














Loop over the pdf files, use parameter expansion to extract the basename:



#!/bin/bash
for pdf in *.pdf ; do
 basename=$pdf%.pdf
 if [[ -f $basename.xls || -f $basename.xlsx ]] ; then
 rm "$pdf"
 fi
done


Update: I got the logic backwards, should be fixed now. Sorry.







share|improve this answer














share|improve this answer



share|improve this answer








edited Aug 10 at 21:28

























answered Aug 10 at 16:31









choroba

24.5k34168




24.5k34168











  • Added slightly more efficient alternative. If this folder is extensive, it could make a difference in processing time.
    – Xalorous
    Aug 10 at 17:00










  • @Xalorous: But your "alternative" removed the files my solution tried to keep.
    – choroba
    Aug 10 at 17:01











  • It's possible that I pasted the wrong one. I'll post a separate answer with the more efficient version.
    – Xalorous
    Aug 10 at 17:04










  • I agree with your decision to reject the suggested edit — new answers should be posted as new answers, not edits.  But I believe that Xalorous got it right and you (choroba) got it backwards.  If ABCD_0000005.xlsx and ABCD_0000005.pdf both exist, your code leaves ABCD_0000005.pdf alone.  But if important.pdf exists, and there’s no corresponding spreadsheet, your code deletes important.pdf.
    – G-Man
    Aug 10 at 17:43











  • Actually, I missed that his logic is inverted. Taking out the ! would fix it though. The real question is what if there's a pdf without matching xls(x). What does OP want to happen then? If they want them gone, then they need to just rm -rf *.pdf. If not, then my answer. Reading the question strictly, we're only to delete pdf files with matching xls(x) files.
    – Xalorous
    Aug 10 at 17:51

















  • Added slightly more efficient alternative. If this folder is extensive, it could make a difference in processing time.
    – Xalorous
    Aug 10 at 17:00










  • @Xalorous: But your "alternative" removed the files my solution tried to keep.
    – choroba
    Aug 10 at 17:01











  • It's possible that I pasted the wrong one. I'll post a separate answer with the more efficient version.
    – Xalorous
    Aug 10 at 17:04










  • I agree with your decision to reject the suggested edit — new answers should be posted as new answers, not edits.  But I believe that Xalorous got it right and you (choroba) got it backwards.  If ABCD_0000005.xlsx and ABCD_0000005.pdf both exist, your code leaves ABCD_0000005.pdf alone.  But if important.pdf exists, and there’s no corresponding spreadsheet, your code deletes important.pdf.
    – G-Man
    Aug 10 at 17:43











  • Actually, I missed that his logic is inverted. Taking out the ! would fix it though. The real question is what if there's a pdf without matching xls(x). What does OP want to happen then? If they want them gone, then they need to just rm -rf *.pdf. If not, then my answer. Reading the question strictly, we're only to delete pdf files with matching xls(x) files.
    – Xalorous
    Aug 10 at 17:51
















Added slightly more efficient alternative. If this folder is extensive, it could make a difference in processing time.
– Xalorous
Aug 10 at 17:00




Added slightly more efficient alternative. If this folder is extensive, it could make a difference in processing time.
– Xalorous
Aug 10 at 17:00












@Xalorous: But your "alternative" removed the files my solution tried to keep.
– choroba
Aug 10 at 17:01





@Xalorous: But your "alternative" removed the files my solution tried to keep.
– choroba
Aug 10 at 17:01













It's possible that I pasted the wrong one. I'll post a separate answer with the more efficient version.
– Xalorous
Aug 10 at 17:04




It's possible that I pasted the wrong one. I'll post a separate answer with the more efficient version.
– Xalorous
Aug 10 at 17:04












I agree with your decision to reject the suggested edit — new answers should be posted as new answers, not edits.  But I believe that Xalorous got it right and you (choroba) got it backwards.  If ABCD_0000005.xlsx and ABCD_0000005.pdf both exist, your code leaves ABCD_0000005.pdf alone.  But if important.pdf exists, and there’s no corresponding spreadsheet, your code deletes important.pdf.
– G-Man
Aug 10 at 17:43





I agree with your decision to reject the suggested edit — new answers should be posted as new answers, not edits.  But I believe that Xalorous got it right and you (choroba) got it backwards.  If ABCD_0000005.xlsx and ABCD_0000005.pdf both exist, your code leaves ABCD_0000005.pdf alone.  But if important.pdf exists, and there’s no corresponding spreadsheet, your code deletes important.pdf.
– G-Man
Aug 10 at 17:43













Actually, I missed that his logic is inverted. Taking out the ! would fix it though. The real question is what if there's a pdf without matching xls(x). What does OP want to happen then? If they want them gone, then they need to just rm -rf *.pdf. If not, then my answer. Reading the question strictly, we're only to delete pdf files with matching xls(x) files.
– Xalorous
Aug 10 at 17:51





Actually, I missed that his logic is inverted. Taking out the ! would fix it though. The real question is what if there's a pdf without matching xls(x). What does OP want to happen then? If they want them gone, then they need to just rm -rf *.pdf. If not, then my answer. Reading the question strictly, we're only to delete pdf files with matching xls(x) files.
– Xalorous
Aug 10 at 17:51













up vote
3
down vote













Loop over the .xls(x) files and remove matching pdf files.



for xls in *.xls* ; do
 /bin/rm -f "$xls%.xls*"".pdf"
done


If there's no matching pdf it won't hurt anything.






share|improve this answer




















  • You don’t really need the ""; i.e., you could do /bin/rm -f "$xls%.xls*.pdf".  But this looks like it should work.
    – G-Man
    Aug 10 at 17:42










  • I tried it both ways, the match failed without the "" in the middle. Or maybe I made a different mistake at the same time. I'm new to bash.
    – Xalorous
    Aug 10 at 17:46














up vote
3
down vote













Loop over the .xls(x) files and remove matching pdf files.



for xls in *.xls* ; do
 /bin/rm -f "$xls%.xls*"".pdf"
done


If there's no matching pdf it won't hurt anything.






share|improve this answer




















  • You don’t really need the ""; i.e., you could do /bin/rm -f "$xls%.xls*.pdf".  But this looks like it should work.
    – G-Man
    Aug 10 at 17:42










  • I tried it both ways, the match failed without the "" in the middle. Or maybe I made a different mistake at the same time. I'm new to bash.
    – Xalorous
    Aug 10 at 17:46












up vote
3
down vote










up vote
3
down vote









Loop over the .xls(x) files and remove matching pdf files.



for xls in *.xls* ; do
 /bin/rm -f "$xls%.xls*"".pdf"
done


If there's no matching pdf it won't hurt anything.






share|improve this answer












Loop over the .xls(x) files and remove matching pdf files.



for xls in *.xls* ; do
 /bin/rm -f "$xls%.xls*"".pdf"
done


If there's no matching pdf it won't hurt anything.







share|improve this answer












share|improve this answer



share|improve this answer










answered Aug 10 at 17:04









Xalorous

22118




22118











  • You don’t really need the ""; i.e., you could do /bin/rm -f "$xls%.xls*.pdf".  But this looks like it should work.
    – G-Man
    Aug 10 at 17:42










  • I tried it both ways, the match failed without the "" in the middle. Or maybe I made a different mistake at the same time. I'm new to bash.
    – Xalorous
    Aug 10 at 17:46
















  • You don’t really need the ""; i.e., you could do /bin/rm -f "$xls%.xls*.pdf".  But this looks like it should work.
    – G-Man
    Aug 10 at 17:42










  • I tried it both ways, the match failed without the "" in the middle. Or maybe I made a different mistake at the same time. I'm new to bash.
    – Xalorous
    Aug 10 at 17:46















You don’t really need the ""; i.e., you could do /bin/rm -f "$xls%.xls*.pdf".  But this looks like it should work.
– G-Man
Aug 10 at 17:42




You don’t really need the ""; i.e., you could do /bin/rm -f "$xls%.xls*.pdf".  But this looks like it should work.
– G-Man
Aug 10 at 17:42












I tried it both ways, the match failed without the "" in the middle. Or maybe I made a different mistake at the same time. I'm new to bash.
– Xalorous
Aug 10 at 17:46




I tried it both ways, the match failed without the "" in the middle. Or maybe I made a different mistake at the same time. I'm new to bash.
– Xalorous
Aug 10 at 17:46

















 

draft saved


draft discarded















































 


draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f461844%2fdelete-pdf-files-only-if-xlsx-files-in-directory-have-same-filename%23new-answer', 'question_page');

);

Post as a guest
































































-

Popular posts from this blog

Peggy Mitchell

Image
EastEnders character This article is about the soap opera character. For the British tennis player, see Peggy Michell. For the author, see Margaret Mitchell. Peggy Mitchell Barbara Windsor as Peggy Mitchell (2008) EastEnders character Portrayed by Jo Warne (1991) Barbara Windsor (1994–2016) Duration 1991, 1994–2010, 2013–2016 First appearance Episode 650 30 April 1991  ( 1991-04-30 ) Last appearance Episode 5286 17 May 2016  ( 2016-05-17 ) (appearance) Episode 5287 19 May 2016 (voiceover) Introduced by Michael Ferguson (1991) Barbara Emile (1994) Louise Berridge (2004) Kate Harwood (2005) Lorraine Newman (2013) Dominic Treadwell-Collins (2014) Spin-off appearances The Mitchells - Naked Truths (1998) Classification Former; regular Profile Other names Peggy Butcher Occupation Barmaid Businesswoman Pub landlady Jo Warne as Peggy Mitchell (1991) Family Family Mitchell Father Jack Martin Mother Lily Martin Sisters Aunt ...
Read more

Palaiologos

Image
Palaiologos Παλαιολόγος Palaeologus, Palaeologue Imperial Family Double-headed eagle with the family cypher Country Byzantine Empire, Duchy of Montferrat (remaining lineage after Empire annexed by Ottomans) Founded 11th century  ( 11th century ) Founder Nikephoros Palaiologos (first known) Final ruler Constantine XI Palaiologos (Byzantine Empire) Margaret Paleologa (Montferrat) Titles Byzantine Emperor Marquess of Montferrat Style(s) "Augustus" "Basileus" "Autokrator" Traditions Greek Orthodoxy (predominantly) Roman Catholicism (remaining lineage in Montferrat) Dissolution 1533  ( 1533 ) Cadet branches Claimants: House of Kastrioti (defunct) House of Rurik (defunct) Palaiologan dynasty Chronology Michael VIII 1259–1282 with Andronikos II as co-emperor, 1261–1282 Andronikos II 1282–1328 with Michael IX (1294–1320) and Andronikos III (1321–1328) as co-emperors Andronikos III 1328–1341 John...
Read more

The Forum (Inglewood, California)

Image
The Forum "LA Forum" Prairie Ave. façade of The Forum in 2014 Full name The Forum, presented by Chase Former names The Forum (1967–1988) Great Western Forum (1988–2003) Address 3900 W. Manchester Blvd Location Inglewood, California Coordinates Coordinates: 33°57′29″N 118°20′31″W  /  33.95806°N 118.34194°W  / 33.95806; -118.34194 Public transit     Downtown Inglewood station Owner The Madison Square Garden Company Operator MSG Entertainment Seating type Reserved Capacity 17,500 Half-bowl: 8,000 Construction Broke ground July 1, 1966  ( 1966-07-01 ) Opened December 30, 1967  ( 1967-12-30 ) Renovated 1988, 2012–2014 Construction cost $16 million Renovation: 2014: $76.5 million Architect Charles Luckman Associates (original) Brisbin Brook Beynon (renovation) Structural engineer Johnson & Nielsen Associates (original) Severud Associates (renovation) Genera...
Read more