Scrap the entire thread's text into document/excel sheet

[abunickabhi]

Hi,

I want to compile all the contributions made in this thread (https://www.speedsolving.com/threads/daily-letter-quads.80224/) into an offline excel sheet. Any web based solution in php, css or any other language to copy up all the posts in that thread and put in a document or an excel sheet?

 

[qwr]

It will be tricky because the entries aren't in a consistent machine-readable format.
What I would do is use beautifulsoup to parse just the readable text or just copy and paste it into a document, then run a regex that finds lines that are 4 letters then a dash then an explanation. You will miss some that need to be manually entered. I would not use excel for any kind of data processing and instead use something simple like CSV or any kind of database for easy querying.

 

[abunickabhi]

It will be tricky because the entries aren't in a consistent machine-readable format.
What I would do is use beautifulsoup to parse just the readable text or just copy and paste it into a document, then run a regex that finds lines that are 4 letters then a dash then an explanation. You will miss some that need to be manually entered. I would not use excel for any kind of data processing and instead use something simple like CSV or any kind of database for easy querying.

Yes I have used the beautifulsoup library in python.

I will give it a shot!

 

[qwr]

Yes I have used the beautifulsoup library in python.

I will give it a shot!

It is probably faster to copy and paste lists then run a regex than try to parse forum posts, even only the text within a post.

In the future you can ask people to post in standardized form, such as 4 letters, space, dash, space, explanation

 

[abunickabhi]

It is probably faster to copy and paste lists then run a regex than try to parse forum posts, even only the text within a post.

In the future you can ask people to post in standardized form, such as 4 letters, space, dash, space, explanation

Yes standardised input from each post will be easier to parse via regex.

I guess there is no workaround with the forum software then.