Count again… 175?
I've got 1821… so far… only got Q2851 to Q3100 to finish off; so maybe another 100 to be found!
I've tried to attached a subset of my spreadsheet as a csv file but it doesn't seem to like csv or xls format when i post?
That'll save you looking for the other 1650… if you give me a format to post file in
I'd suggest using right($x$n,1)=" " to identify them all, once you've got posts separated into 1 line per cell.
It's also a good cross-check on how accurately posts have been copied to spreadsheet!
So have I over the last almost 3 years.
I copy them from Qanon.pub because:
a) That also holds Chan ID, which is also used in decodes,
b) The time is a consistent EST,
c) It is the closest match to the original qntmpkts.keybase.pub
I scrape from top left to bottom so inherently get each space as held there!
Let's compare a few samples, which you can look up on qanon.pub by simply highlighting the post to see the spaces at end of lines:
Q2850 has 1
Q2849 has 3
Q2844 has 2
Q2843 has 2
Q2842 has 4
Q2838 has 1
Q2837 has 2
Q2836 has 1
ETA - Out of interest, did your methods pick up the initial blank line on Q2807.
Not challenging just interested to know.
Am also interested in how you store the "(/pb)"s? With the post number they reply to or without?
I store the "post number replied to" in a separate field to differentiate what Q has actually typed and what 8kun inserts into the post.
I'd note that getting this right is also important because of the post content character count which is another way to find a linked post… so missing a space or two reduces the post character count from say 55 to 53, meaning one misses a link to "Look to Twitter…"