Should be easy answer.

[CallisterUK]

Okay, lets say I have a webpage and it has 4 columns: Rank, Player, Level, and Experience.

Preferably I want to copy everything from the "Player" column, but due to limitations on the website, I'm pretty sure you can't.

 

I can copy and paste the 4 entire tables into Excel, but they aren't automatically assigned individual tables (making it easy to copy+paste the "Player" column.

 

Are there any programs that will allow with me to do this? tried Excel, Notepad, and Notepad++. Can't think of anything else, lack of experience :(.

[79wjd]

Maybe try inspecting the page? It might be laid out in a way that's more conducive to copying just the data you want. 

[CallisterUK]

1 minute ago, djdwosk97 said:

Maybe try inspecting the page? It might be laid out in a way that's more conducive to copying just the data you want. 

Tried this, and viewing the page source. All the usernames are mixed together, not in a List. 

[Enderman]

http://www.excel-easy.com/examples/import-export-text-files.html

 

You can import into excel all the columns and separate them by space or comma or whatever.

Then just delete the columns you don't need.

[Guest]

Which website?

[79wjd]

Just now, CallisterUK said:

Tried this, and viewing the page source. All the usernames are mixed together, not in a List. 

Have you tried highlighting the entire table, and then selecting 4 columns in Excel and pasting (and then just clearing three of the columns)?

[CallisterUK]

Just now, dexxterlab97 said:

Which website?

Embarrassingly

http://services.runescape.com/m=hiscore/ranking?category_type=0&table=15&date=1472161518831&time_filter=0&page=1

 

 

[CallisterUK]

2 minutes ago, djdwosk97 said:

Have you tried highlighting the entire table, and then selecting 4 columns in Excel and pasting (and then just clearing three of the columns)?

Yea, but it's a slow process. Too many pictures etc appear, sometimes my Excel goes to "Not Responding" for 5-10 seconds despite a pretty good PC.

[Guest]

5 minutes ago, CallisterUK said:

Embarrassingly

http://services.runescape.com/m=hiscore/ranking?category_type=0&table=15&date=1472161518831&time_filter=0&page=1

 

 

Something like this?

http://imgur.com/a/I978W

[CallisterUK]

3 minutes ago, dexxterlab97 said:

Something like this?

http://imgur.com/a/I978W

Yeah, that'd be fine as long as it takes 2-5 seconds max to appear. Haven't tried using Word, thought Excel would be better. 

 

UPDATE: Word, seems to be a lot better than Excel for this. Thanks for the suggestion, I guess this can be used for now. Thx.

[Guest]

Just now, CallisterUK said:

Yeah, that'd be fine as long as it takes 2-5 seconds max to appear. Haven't tried using Word, thought Excel would be better. 

Just copy paste entire table from the site to word. Then just select the column you need

[Squish4058]

8 minutes ago, CallisterUK said:

Embarrassingly

http://services.runescape.com/m=hiscore/ranking?category_type=0&table=15&date=1472161518831&time_filter=0&page=1

 

 

So you want the entire player list.

I get that when you want a player list

I can convert multi column tables into lists, I however do not know how to copy 50,000 pages of a table at once

[CallisterUK]

1 minute ago, kris2340k said:

So you want the entire player list.

I get that when you want a player list

I can convert multi column tables into lists, I however do not know how to copy 50,000 pages of a table at once

Hmm interesting. Yeah, I'm not too sure either unfortunately. Completely inexperienced, although what you're saying does indeed sound plausible.

[elpiop]

I don't think that the RS API supports grabbing the entire list of players unfortunately. You can only retrieve data on a single player or a list of players in a certain clan, not skill. For just one page though, the suggestion above is a good way to do it. 

 

/edit: actually you can retrieve the top 50 with an api request. 

here it is for mining: http://services.runescape.com/m=hiscore/ranking.json?table=15&category=0&size=50

 

and you can paste the json into this site: https://konklone.io/json/ and download the formatted csv to get everything in columns. 

 

Here is the api documentation - http://runescape.wikia.com/wiki/Application_programming_interface#ranking 

[CallisterUK]

23 minutes ago, elpiop said:

I don't think that the RS API supports grabbing the entire list of players unfortunately. You can only retrieve data on a single player or a list of players in a certain clan, not skill. For just one page though, the suggestion above is a good way to do it. 

 

/edit: actually you can retrieve the top 50 with an api request. 

here it is for mining: http://services.runescape.com/m=hiscore/ranking.json?table=15&category=0&size=50

 

and you can paste the json into this site: https://konklone.io/json/ and download the formatted csv to get everything in columns. 

 

Here is the api documentation - http://runescape.wikia.com/wiki/Application_programming_interface#ranking 

Holy shit that's really good. Is there a way to extend the results higher than 50? as I'm looking for hundreds, potentially thousands.

 

Also: Is there a reason you can only receive the TOP 50? I tried extending the number, and the results don't change. I'm very inexperienced as stated above, but this is very interesting.

[elpiop]

13 minutes ago, CallisterUK said:

Holy shit that's really good. Is there a way to extend the results higher than 50? as I'm looking for hundreds, potentially thousands.

 

Also: Is there a reason you can only receive the TOP 50? I tried extending the number, and the results don't change. I'm very inexperienced as stated above, but this is very interesting.

You can only request at most the top 50 players. I would guess it is to limit the impact it would have on the servers as requesting potentially millions of entries could be taxing on them. What exactly do you need this for, if you don't mind me asking?

[CallisterUK]

3 minutes ago, elpiop said:

You can only request at most the top 50 players. I would guess it is to limit the impact it would have on the servers as requesting potentially millions of entries could be taxing on them. What exactly do you need this for, if you don't mind me asking?

I'm just looking to compile a list of "Display Names" for a future project I have in mind. With the help of a few friends.

[elpiop]

9 minutes ago, CallisterUK said:

I'm just looking to compile a list of "Display Names" for a future project I have in mind. With the help of a few friends.

Ah. Well, I can't really offer much more help. Not entirely sure how you could get the full list of display names.

 

However... if you just need a list of names that were once in use (potentially in use now if someone took the name), this forum thread has a list of millions of inactive usernames that were cleared up a few years ago (only names starting with A-M unforunately... can't seem to find the other batches for some reason). So if you just need a bunch of names... take a look at these csv's: http://services.runescape.com/m=forum/forums.ws?254,255,385,65452510

[CallisterUK]

1 minute ago, elpiop said:

Ah. Well, I can't really offer much more help. Not entirely sure how you could get the full list of display names.

 

However... if you just need a list of names that were once in use (potentially in use now if someone took the name), this forum thread has a list of hundreds of thousands of names that were cleared up a few years ago (only ones A-M unforunately... can't seem to find the other batches for some reason). So if you just need a bunch of names... take a look at these csv's: http://services.runescape.com/m=forum/forums.ws?254,255,385,65452510

Thanks a lot, i appreciate it.

[elpiop]

No problem, good luck with your project .