• Re: Editing PDF files [Paid options?]

    From Maria Sophia@mariasophia@comprehension.com to alt.comp.os.windows-11,alt.comp.os.windows-10,comp.text.pdf on Sun Oct 4 17:09:25 2026
    From Newsgroup: comp.text.pdf

    Paul wrote:
    Didn't the ABBYY product have password cracking for PDF ?
    I think that's one reason people bought a copy.

    Long ago, like really long ago, I posted a tutorial for password removal. That's not the same as cracking, but the effect is the same per document.

    Essentially, you edit the PDF in a program that doesn't respect the passwd. Voila! Save it and there's no password.

    Dunno if something that simple still works though, as it was just too easy.
    I used GSView and Ghostscript, at the time, but dunno if that still works.
    --- Synchronet 3.22a-Linux NewsLink 1.2
  • From Carlos E. R.@robin_listas@es.invalid to alt.comp.os.windows-11,alt.comp.os.windows-10,comp.text.pdf on Sun Oct 4 22:31:15 2026
    From Newsgroup: comp.text.pdf

    On 2026-10-04 22:09, Maria Sophia wrote:
    Paul wrote:
    Didn't the ABBYY product have password cracking for PDF ?
    I think that's one reason people bought a copy.

    Long ago, like really long ago, I posted a tutorial for password removal. That's not the same as cracking, but the effect is the same per document.

    Essentially, you edit the PDF in a program that doesn't respect the passwd. Voila! Save it and there's no password.

    Dunno if something that simple still works though, as it was just too easy.
    I used GSView and Ghostscript, at the time, but dunno if that still works.

    No, AFAIR it was some kind of bug or misfeature.
    --
    Cheers,
    Carlos E.R.
    ESEfc-Efc+, EUEfc-Efc|.
    --- Synchronet 3.22a-Linux NewsLink 1.2
  • From Maria Sophia@mariasophia@comprehension.com to alt.comp.os.windows-11,alt.comp.os.windows-10,comp.text.pdf on Sun Oct 4 23:50:22 2026
    From Newsgroup: comp.text.pdf

    Carlos E. R. wrote:
    Dunno if something that simple still works though, as it was just too easy. >> I used GSView and Ghostscript, at the time, but dunno if that still works.

    No, AFAIR it was some kind of bug or misfeature.

    Actually, as I recall (as it was long ago!) the password needed was for
    things like copying and/or printing, which was too easy to circumvent.

    For that, Ghostscript's pdfwrite mechanism would rewrite the PDF into a
    brand new file, rather than merely editing the original in place.
    <https://www.ghostscript.com/releases/>

    What you're talking about, and which I forgot to make the distinction for,
    is the encryption password, which is different than for the permissions.

    One other trick that is just too easy that we may as well discuss is that
    we can show in the clear those passwords which show up as "dots" using
    <https://www.nirsoft.net/utils/bulletspassview.zip>
    But that is likely too easy to work for anything in the Adobe PDF realm.
    --
    I avoid complex solutions when a simpler one already solves known issues.
    --- Synchronet 3.22a-Linux NewsLink 1.2
  • From Maria Sophia@mariasophia@comprehension.com to alt.comp.os.windows-11,alt.comp.os.windows-10,comp.text.pdf on Mon Oct 5 13:34:05 2026
    From Newsgroup: comp.text.pdf

    MikeS wrote:
    With the exception of PDFGear (which is free, and really very good), all
    of these have expensive annual subscriptions, which is something I
    avoid. I don't feel cheated if I've shelled out for a lifetime license
    and don't use it much, but that's intolerable with a subscription.

    What I actually want is something that will extract the transactions
    from bank statements (notoriously chaotically formatted internally) and
    export them to Excel. I'm currently playing with Power Query, but it's
    laborious due to the irregular internal structure of the documents.

    Have you checked which option(s) your bank offers for downloads? Many
    now provide alternatives to pdf specifically to facilitate importing
    data into spreadsheets or accounting software.

    Calibre will convert a normal PDF to RTF or HTML or Text or MS Word, etc., where you might be able to get that to csv and then to Excel if you want.

    But maybe it's just better to use a table extractor such as Tabula (free)
    or Camelot which are designed to pull tables out of PDFs into CSV/Excel.
    --
    Knowledge is best shared, like Italian pizza & German beer, among friends.
    --- Synchronet 3.22a-Linux NewsLink 1.2
  • From Philip Herlihy@nothing@invalid.com to alt.comp.os.windows-11,alt.comp.os.windows-10,comp.text.pdf on Tue Oct 6 15:35:14 2026
    From Newsgroup: comp.text.pdf

    In article <11a0jhs$13us$1@nnrp.usenet.blueworldhosting.com>, mariasophia@comprehension.com says...
    Calibre will convert a normal PDF to RTF or HTML or Text or MS Word, etc., >where you might be able to get that to csv and then to Excel if you want.

    But maybe it's just better to use a table extractor such as Tabula (free)
    or Camelot which are designed to pull tables out of PDFs into CSV/Excel.



    Thanks for this. I've played with Tabula, which is quite impressive. However, like a lot of bank statement PDFs I've examined the main
    problem is that the internal structure is hideously complex, and while
    Tabula is an option, the output will still require quite a lot of
    cleaning-up. I'm currently exploring using Power Query, though which
    will end up with the least work is still open.

    I did try asking CoPilot to do one for me, and it did it perfectly and effortlessly. However, the owner of these statements doesn't want any
    of this personal information to be shared with any AI engine. So the
    third option we're looking at is redacting the files and then uploading
    them to CoPilot.

    The jury's still out on which is going to be the least work for a clean
    set of Excel files!
    --
    --
    Phil, London
    --- Synchronet 3.22a-Linux NewsLink 1.2
  • From Maria Sophia@mariasophia@comprehension.com to alt.comp.os.windows-11,alt.comp.os.windows-10,comp.text.pdf on Tue Oct 6 12:39:02 2026
    From Newsgroup: comp.text.pdf

    Philip Herlihy wrote:
    But maybe it's just better to use a table extractor such as Tabula (free) >>or Camelot which are designed to pull tables out of PDFs into CSV/Excel.



    Thanks for this. I've played with Tabula, which is quite impressive.

    Good to know that you've used the free Tabula as a table extractor, and
    that your particular statements don't lend themselves to Tabula freeware.

    I'm a freeware hound, so I really only know how to use free programs
    although in my Silicon Valley professional life, I used payware a lot.

    I worked with some of the most complicated datasets on the planet.
    So I've imported and exported using million-dollar tools many times.

    One point I'll make that I don't think anyone here who has been on
    computers since the 1960s will disagree with, which is (almost) every
    single conversion I've ever done (and I can't count how many I've done) has "some kind of post-processing" issue that I've had to do to clean it up.

    A bit of post processing is to be expected, is my main advice to anyone.

    Since Tabula is the only freeware PDF-to-Excel that I'm aware of, there's
    also supposedly these, but I have zero experience with them. Caveat Emptor.
    1. Able2Extract Professional
    2. Tungsten Power PDF (formerly Kofax Power PDF)
    3. Adobe Acrobat Pro
    4. ABBYY FineReader PDF
    5. Nitro PDF Pro

    I think most (if not all?) have already been discussed, so let's just say something about each of them, as they're each different in many ways. .

    1. Able2Extract Professional
    It lets you manually define rows/columns when automatic conversion
    gets the table wrong, and it has OCR for scanned PDFs.
    2. Tungsten Power PDF (formerly Kofax Power PDF)
    Advanced adds OCR and batch processing.
    3. Adobe Acrobat Pro
    Adobe specifically supports exporting PDFs to XLS/XLSX while
    preserving tables and formatting.
    4. ABBYY FineReader PDF
    Good if your PDFs are scanned documents, because OCR is one of
    its major strengths.
    5. Nitro PDF Pro
    Excel conversion, OCR and batch capabilities
    --
    On Usenet, experience is meant to be passed along, not hoarded.
    --- Synchronet 3.22a-Linux NewsLink 1.2
  • From Maria Sophia@mariasophia@comprehension.com to alt.comp.os.windows-11,alt.comp.os.windows-10,comp.text.pdf on Tue Oct 6 23:29:43 2026
    From Newsgroup: comp.text.pdf

    MegaNZ wrote:
    On 06/10/2026 16:05, Philip Herlihy wrote:
    Thanks for this. Foxit seems to be the most capable, but I don't see a
    perpetual license, and the annual one is expensive.

    Most people will find that the old version of Adobe Acrobat Professional
    XI is sufficient. It's a perpetual licence and includes almost all the features of the free software available online, plus more!

    I agree with MegaNZ, but the caveat is you have to have the installer.
    Adobe Acrobat Standard 6.0

    I just looked and I have all the Acrobat professional installers from
    Acrobat 4 to 7, which I bought while I was still working in the valley.

    Acrobat Pro 6 is what I use today mostly for when I need to do minor edits. (Note that in those days the reader didn't exist, so it doesn't say "pro".)

    Also I use it to convert an entire web page hierarchy to a linked PDF.

    I don't use the Acrobat 7 because it required an Internet connection full
    time, which was absurd at the time and is absurd even now when I have it.

    In summary, if the OP (or the lurkers) have an old copy of Adobe Acrobat
    Pro, it has a perpetual license which doesn't cause problems up to 6.

    Dunno how it works after 7 though, but I see it looks like it's similar
    (but I'm sure it requires the Internet after 7 since 7 requires it).

    Also note that it works differently on Windows 11 in that I can't set Adobe Acrobat Standard 6.0 to be the default PDF editor for some reason.

    But on Windows 10, it works like it should (and always did).
    Dunno what's wrong with Windows 11 but that's on my spouse's laptop.
    --
    On Usenet we can have intelligent discussions with well-meaning people.
    --- Synchronet 3.22a-Linux NewsLink 1.2
  • From Philip Herlihy@nothing@invalid.com to alt.comp.os.windows-11,alt.comp.os.windows-10,comp.text.pdf on Wed Oct 7 11:39:04 2026
    From Newsgroup: comp.text.pdf

    In article <11a34mm$2fro$1@nnrp.usenet.blueworldhosting.com>, mariasophia@comprehension.com says...
    1. Able2Extract Professional
    It lets you manually define rows/columns when automatic conversion



    Thanks for this. I tried the Able2Extract online service - which seems
    to be free - and it did at least as good a job as any I've tried, though
    I need to try Tabula again with my "processed" PDFs (pages deleted,
    headers cropped and combined into one file).

    For general use, rather than this specific one-off need, I think the
    free PDFGear is compelling!
    --

    Phil, London
    --- Synchronet 3.22a-Linux NewsLink 1.2
  • From Maria Sophia@mariasophia@comprehension.com to alt.comp.os.windows-11,alt.comp.os.windows-10,comp.text.pdf on Wed Oct 7 13:32:44 2026
    From Newsgroup: comp.text.pdf

    Philip Herlihy wrote:
    I also have an old copy of Acrobat Pro (V9), and I've found that has
    some useful batch processing capabilities which have allowed me to
    delete the first page of a batch of statements and also crop off much of
    the heading, which will simplify the files for subsequent processing

    The best part of the Acrobat Pro payware, nowadays anyway, since freeware abounds, is the control+shift+o which will take as input any web page URL.

    Then, if you let it, it will put the entire web site onto that PDF.
    With links.

    So you have to bound it a bit.
    I usually only let it go down a couple of layers.

    Otherwise, the entire Internet is saved into a single clickable PDF file.
    --
    On Usenet, we pass along knowledge that once we had to learn ourselves.
    --- Synchronet 3.22a-Linux NewsLink 1.2