Python Forum
Search Results
Post Author Forum Replies Views Posted [asc]
    Thread: How to properly format rows and columns in excel data from parsed .txt blocks
Post: RE: How to properly format rows and columns in exc...

I've tried to add an additional blank line to the end of the block description field in the pattern like this but when I add it, the excel file ends up being empty so I assume its because this pattern...
jh67 General Coding Help 7 1,900 Dec-12-2022, 08:22 PM
    Thread: How to remove footer from PDF when extracting to text
Post: RE: How to remove footer from PDF when extracting ...

(Dec-12-2022, 05:59 PM)Gribouillis Wrote: Try with the re.DOTALL flag footer_pattern = re.search("(?s)^JOHN.*Confidential$", text) Just added the (?s) and re.DOTALL and got the same result. Footer i...
jh67 General Coding Help 3 5,117 Dec-12-2022, 06:26 PM
    Thread: How to remove footer from PDF when extracting to text
Post: How to remove footer from PDF when extracting to t...

Hi, I'm trying to take a footer out of a 550 page pdf and then extract everything left to a .txt file. The extraction is working but the footer is still there. I'm not understanding why this isn't wor...
jh67 General Coding Help 3 5,117 Dec-12-2022, 05:20 PM
    Thread: How to properly format rows and columns in excel data from parsed .txt blocks
Post: RE: How to properly format rows and columns in exc...

Yes, there's always a blank line after the description block, regardless of if there is anything in the description field. Also, there is always a period at the end of the description field when there...
jh67 General Coding Help 7 1,900 Dec-12-2022, 01:47 PM
    Thread: How to properly format rows and columns in excel data from parsed .txt blocks
Post: RE: How to properly format rows and columns in exc...

Holy cow, this worked brilliantly. Thank you so much. It exported to excel flawlessly. I do have one further question. I should have detailed it in my original post but the last field (Description) i...
jh67 General Coding Help 7 1,900 Dec-11-2022, 12:11 AM
    Thread: How to properly format rows and columns in excel data from parsed .txt blocks
Post: RE: How to properly format rows and columns in exc...

One sample block. It's worth noting that there are over 400 pages of these blocks in the text file but after the table of contents and a brief appendix at the end, these blocks are the only data in th...
jh67 General Coding Help 7 1,900 Dec-10-2022, 06:38 PM
    Thread: How to properly format rows and columns in excel data from parsed .txt blocks
Post: How to properly format rows and columns in excel d...

Hi. I'm trying to create an excel sheet using data made up from specific, recurring blocks of text in a .txt file and ignoring all other data in the file (table of contents, etc). The blocks of text a...
jh67 General Coding Help 7 1,900 Dec-09-2022, 08:00 PM

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020