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












3














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
















3














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














3












3








3







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

11.9k23064




11.9k23064










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


















6














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.






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





















4














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',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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
});


}
});














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















Required, but never shown

























2 Answers
2






active

oldest

votes








2 Answers
2






active

oldest

votes









active

oldest

votes






active

oldest

votes









6














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.






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


















6














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.






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
















6












6








6






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.






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.







share|improve this answer














share|improve this answer



share|improve this answer








edited Dec 16 at 21:36









Rui F Ribeiro

38.9k1479129




38.9k1479129










answered Aug 10 at 16:31









choroba

26.3k44672




26.3k44672












  • 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















4














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
















4














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














4












4








4






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

24218




24218












  • 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




















































Thanks for contributing an answer to Unix & Linux Stack Exchange!


  • 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.





Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


Please pay close attention to the following guidance:


  • 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.




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















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







-

Popular posts from this blog

Morgemoulin

Image
Morgemoulin — miejscowość i gmina — Państwo   Francja Region Grand Est Departament Moza Okręg Verdun Kod INSEE 55357 Powierzchnia 6,82 km² Populacja  (1990) • liczba ludności 75 • gęstość 11 os./km² Kod pocztowy 55400 Położenie na mapie Francji Morgemoulin 49°14′N   5°35′E / 49,233333   5,583333 Portal Francja Morgemoulin – miejscowość i gmina we Francji, w regionie Grand Est, w departamencie Moza. Według danych na rok 1990 gminę zamieszkiwało 75 osób, a gęstość zaludnienia wynosiła 11 osób/km² (wśród 2335 gmin Lotaryngii Morgemoulin plasuje się na 970. miejscu pod względem liczby ludności, natomiast pod względem powierzchni na miejscu 848.). Bibliografia | Francuski urząd statystyczny ( fr. ) . p   •   d   •   e Gminy okręgu Verdun Abaucourt-Hautecourt • Aincreville • Ambly-sur-Meuse • Amel-sur-l'Étang • Ancemont • Arrancy-sur-Crusne • Aubréville • Autré...
Read more

Scott Moir

Image
Scott Moir Tessa Virtue i Scott Moir w 2016 r. Reprezentacja   Kanada Data i miejsce urodzenia 2 września 1987 London Wzrost 180 cm Konkurencja Pary taneczne Partner sportowy Tessa Virtue Trener Marie-France Dubreuil, Patrice Lauzon, Romain Haguenauer Poprzednio: Marina Zujewa, Oleg Epstein, Igor Szpilband, Johnny Johns, Carol Moir, Paul MacIntosh, Suzanne Killing Klub Montreal International School of Skating Poprzednio: Arctic Edge FSC Ilderton Skating Club Lokalizacja treningowa Montreal Poprzednio: Canton Kitchener Rekordy życiowe ISU przed sezonem 2018/2019 Nota łączna 206,07 Igrzyska Olimpijskie 2018 Taniec krótki 83,67 Igrzyska Olimpijskie 2018 Taniec dowolny 122,40 Igrzyska Olimpijskie 2018 Dorobek medalowy Reprezentacja   Kanada Igrzyska olimpijskie Złoto Vancouver 2010 pary taneczne Złoto Pjongczang 2018 pary taneczne Złoto Pjongczang 2018 drużynowo Srebro S...
Read more

Souastre

Image
Souastre — miejscowość i gmina — Herb Państwo   Francja Region Hauts-de-France Departament Pas-de-Calais Okręg Arras Kod INSEE 62800 Powierzchnia 7,18 km² Populacja  (1990) • liczba ludności 352 • gęstość 49 os./km² Kod pocztowy 62111 Położenie na mapie Francji Souastre 50°09′N   2°34′E / 50,150000   2,566667 Portal Francja Souastre – miejscowość i gmina we Francji, w regionie Hauts-de-France, w departamencie Pas-de-Calais. Według danych na rok 1990 gminę zamieszkiwały 352 osoby, a gęstość zaludnienia wynosiła 49 osób/km² (wśród 1549 gmin regionu Nord-Pas-de-Calais Souastre plasuje się na 887. miejscu pod względem liczby ludności, natomiast pod względem powierzchni na miejscu 507.). Bibliografia | Francuski urząd statystyczny ( fr. ) . p   •   d   •   e Gminy okręgu Arras Ablain-Saint-Nazaire Ablainzevelle Acheville Achicourt Achiet-le-Grand Achiet-le-Pe...
Read more