วีดีโอ

It looks like you are trying to run a powershell script but windows has powershell disabled for security reasons. Out of curiosity did you change your default terminal in the steps at 0:43?

This is awesome! I remember when I decided to first post these videos I was working a COOP and they had me looking at massive Excel files (12+ tabs & 4000+ rows) for links to other workbooks. When I first started it was done all by hand so I decided to make a Python script to search the Excel files. I remember thinking of other ways I could automate manual processes and I heard from a friend renaming a massive amount of PDFs by hand. That's when I thought to make a video on it. I'm glad it managed to help someone... never thought a trial attorney would be using Python! I've seen people in some of my fourth-year Computer Science classes that didn't even know how to code in it (congrats!), it is a very useful tool that can do so much. Enjoy all that time back :)

Sorry, I'm getting around to replying to some of the comments that have been coming in the last few days. I don't have a discord but maybe that would be something to look into. To be honest I haven't used discord much since I graduated. However, in the meantime if you have a video suggestion I would always be down to investigate it. I did start my full-time job recently but I love to solve these types of problems in my free time so suggest away :)

Hi Martin, did you install PyMuPDF? The command is in the github under "Steps". If you're getting that error it means that library ins't installed.

Hi, Thanks for the comment! Yes, extracting certain pages from a PDF is possible with PyMuPDF. Extracting text from a scanned PDF is doable but the last time I tried to do it not all the text was extracted properly (it depends on the scan quality of the PDF). I took a brief look online and it does look like it could be done with another library (I would have to do more research). Unfortunatly I just started my last semester of University so I'm a bit swamped at the moment with coding projects, so it might be awhile before I can take a better look.

@@stephencodes thank you for reply..

Hi Michael, Thanks! I think it should be possible. Just so I understand, say I have the following text (I want to extract what comes after orderID): Name: Bob Phone #: xxxxxxxx orderID: XAOP/1232232 Email: string@gmail.com You would only want to extract XAOP1232232? (not including the "/").

Excel Viewer by GrapeCity: prnt.sc/boDFbB7aRXhp

@@stephencodes thank's

This error was due to problems with indentation. My rename() function was tabbed over one too many placing it under the "with open" block instead of the for loop block. If anyone else makes this mistake, double check that your indentation matches the indentation on line 14 at time stamp 6:46 in the video.

I believe that error happens if you're trying to rename the pdf while it is open. Operating systems have restrictions on how data can be accessed/changed. If one process is reading a file (you having the pdf open) and another is trying to modify an attribute of the file (the python script changing the filename) the operating system won't allow it. If you try opening the pdf in any viewer, like adobe acrobat and try running the script, I think you'll get that same error.

Hi Kick, the reason for using a virtual environment is to keep packages separate for different projects. If we didn't use a virtual environment we would be installing packages globally across the operating system which could cause issues if different projects use different versions of the same package. Another reason is I sometimes mess up installations and it is a pain to try and fix a package that is installed globally (in this case I just re-create the virtual environment). Although I only really used one package I do it more out of habit and convenience. I believe the reason for using PyMuPDF over pypdf2 was because pypdf2 messed up the document structure when grabbing the contents of PDFs. I tried a couple other packages but PyMuPDF was the one that worked.

I have a video up that does something like this with regex. If you want to pull a name without using a format structure (grabbing text that comes after a certain word for example), then you may need to use another library. Is this what you're trying to do?

Are trying to create file folders in this example? (Leal v. Bedel et al). Another question; is your Case Name, DocumentNumber, FilingData, LastName and FilingType on separate lines in the PDF?This shouldn't be too hard to implement, let me know and I can try and make a video.

@@stephencodes now i want to scrape multiple text from pdf like(name,casenumber) and i want to save like that: c:/stephen/45236476/.pdf

@@greenlight4056 Sorry for another question, I want to make sure I understand what you're saying. I'm a bit confused by your (\)s. Say I have this PDF file: Case name: Leal v. Bedel et al Document number: #026 Filing date: 2022-07-02 Last name: Staedter Filing Type: Motion for Extension of Time to File Answer I wouild first create a folder called "Leal v. Bedel et al": prnt.sc/GLgg2tlZbyvm Then I would save a pdf like so (inside the above folder): prnt.sc/5b1A2OP6YX_y

@@stephencodes yes

@@stephencodes Hi Stephen! could you please make a video on how to do it and especially when there is for instance invoice number and OCR number then pick OCR. also if I could save it with an underscore between them. Ex: OCRnumber_comapnyname. I really appreciate your support and time!

I've managed it (i think) with this code: new_file_name = text.splitlines()[15] rename(pdf, new_file_name + '.pdf')

@@robertcenusa8636 Glad you got it working! Yeah I think that should work, just keep in mind splitlines() will split on the following characters, not just newline characters: www.programiz.com/python-programming/methods/string/splitlines (probably be rare you encounter any of the other characters though).

I have experience with APIs although this might be a bit more complicated, I did read something this morning that did sound promising though. Do you have a specific application in mind?

@@stephencodes Chrome, for a financial website. Getting a number from a cell in excel, clicking some buttons in the website then inputting the number in a field, then clicking some more buttons, then going to the next row in excel. OR how about automating going to various sites to download the most recent pdf from a list? I can go on and on, idk if you really wanna read a whole wishlist lol

​@@TacosYBurritos8P I actually made a Python script that did this for a IP hosting website (minus the excel part). The script worked for about a year before the website introuduced a captcha system at login I'll try and take a look again, I was reading and there appears to be a way to get past the captcha system maybe. It might take a bit longer to figure out though

Just an update, I'm still trying to make this video... sorry it is taking so long, work and life has been busy

Video is now up with code... Sorry again for these long delays between requests. I hope the video isn't too confusing, if it is I can try to re-create the steps I took in brand-new project.

Hi Mohamed, you can just call me Stephen, I think this should be doable. You're talking about the print size right? Like A1, A2, A3... paper size?

Yeah that would definitely be possible! Are you able to provide some dummy lines from the excel file and dummy PDFs/names of the PDFs you're trying to rename so I have a clearer picture? By dummy I mean generic data so you you aren't revealing your actual data

@@stephencodes ok i have a data of 2000+ pdfs and i have to break them into single page pdfs and rename them differently using excel sheet data. the pdf name should be in particular order like 2022_(ID)_(name).you could take any name and numbers to show the example.just help me how with a feasible solution where i have to do it 2000 times.

@@shubhamchavan9287 Okay, that makes more sense now, I'll try working on something

New video is up, let me know if it addressed your problem.

Haha, first time for everything! I probably won't setup a Patreon unless I manage to do this a bit more seriously. Fortunately, I've already passed calculus 1 & 2 (somehow, haha). Feel free to make another request, I do enjoy making these videos!

Hi stephen, how do I make this, but the line after? I´m a litle bit confused... Thanks

@@stefaniamarques9979 Hi Stefania, if we were trying to capture the "Purchase method" line we would uise this regex (I've also included a link at the end of this comment): Order #:.*[ ](.+) Keep in mind we would have to change our code on line 21 (see github) to include .group(1) instead of just .group() (if I did this correctly, I did test it a bit). Refer to this link which explains it better: stackoverflow.com/questions/65503992/how-to-extract-the-next-line-after-a-specific-keyword-when-there-are-words-in-be

New video covers this (just uploaded, sorry for delay)

Yes, I'll try and make a video doing some examples of regular expressions. It might take a week or so since I have to bursh up on it.

Sorry, I haven't forgotten about this request. I've just been really busy with school and job searching for the summer. During reading week (this week) I will try and do a video.

Again, sorry for the delay but the new video + code is up.

@@stephencodes bro is the most responsible youtuber I've ever seem. Also, thank you a lot for making these videos!

This should be possible. I'm currently finishing up my exams but I'll take a look soon.

New video on how to do this is posted. Sorry for the delay! (It might need some time for HD to complete).