• Coffee House
  • Bapu's (and others) random thoughts for the day. (p.6365)
2017/11/24 21:10:30
jamesg1213
You are a GOD Craig!
2017/11/24 21:12:50
synkrotron
I've just made another post, and this one makes two!
2017/11/24 21:13:10
synkrotron
Ha! TOTP!!
 
 
2017/11/24 21:38:41
craigb
On Page 40 (186 posts and above).
 
Taking a lot longer than it should because I made the mistake of copying everything instead of pasting text only.  Each page takes a while to paste into Excel with the images which I don't care about anyway!
 
Going to stop after page 40 and do some rearranging then I might add some more without images and be done with it.
2017/11/24 21:44:26
bapu
woof woof
 
 
 
oh, Jyemz said GOD
 
 
I'll get me coat
2017/11/24 21:47:33
drewfx1
craigb
On Page 40 (186 posts and above).
 
Taking a lot longer than it should because I made the mistake of copying everything instead of pasting text only.  Each page takes a while to paste into Excel with the images which I don't care about anyway!
 
Going to stop after page 40 and do some rearranging then I might add some more without images and be done with it.




You just need to search for lines containing "/Posts":
 
 <a href="/Posts/Username">Postcount</a>
 
I don't think any of them wrap or anything, so am I missing something?
 
 
EDIT:
 
Just run find at a Windows command prompt, append redirect (>>) to a .txt file, import into Excel, text > columns, and get rid of the extra chars.
 
i.e.:
find "/Posts" "Member List _ Cakewalk Forums.html" >> postcount.txt
2017/11/24 21:49:38
synkrotron
bapu
 
I'll get me goat




What are you doing with a goat?
2017/11/24 21:50:02
bapu
I'm having difficulty sussing out the database table with the users in it. Seems so simple but I'm beginning to think they (MyBB forum developers) have it hidden somehow.
2017/11/24 22:11:53
drewfx1
bapu
I'm having difficulty sussing out the database table with the users in it. Seems so simple but I'm beginning to think they (MyBB forum developers) have it hidden somehow.




I can just pull each page, do a find on "uid=" (in that forum's case) to get each line and parse that in Excel if you want.
 
And I'm not going to load each page manually either, so it's not particularly labor intensive if it's not a really simple DB query for you.
2017/11/24 22:15:54
bapu
drewfx1
bapu
I'm having difficulty sussing out the database table with the users in it. Seems so simple but I'm beginning to think they (MyBB forum developers) have it hidden somehow.




I can just pull each page, do a find on "uid=" (in that forum's case) to get each line and parse that in Excel if you want.
 
And I'm not going to load each page manually either, so it's not particularly labor intensive if it's not a really simple DB query for you.


Sure, I've got a lot going on right now. That would be helpful.
© 2026 APG vNext Commercial Version 5.1

Use My Existing Forum Account

Use My Social Media Account