Thread:RusTORK/@comment-30967537-20171122195134

Hi,

I don't know if you are familiar with Power Query? It can be very useful.

I just pulled the Track data from your Profile page!

For most of my scripts I get my hands dirty and code directly with the Advanced Editor BUT for quickly retrieving data to see if it might be of use I always use the visual interface ... it took only a few steps to retrieve the data and format the Track Length as a number.

let Source = Web.Page(Web.Contents("http://rr3.wikia.com/wiki/User:RusTORK")), Data0 = Source{0}[Data], #"Changed Type" = Table.TransformColumnTypes(Data0,{{"Track Country", type text}, {"Track", type text}, {"Track  variant", type text}, {"Track  Length", type text}}), #"Promoted Headers" = Table.PromoteHeaders(#"Changed Type", [PromoteAllScalars=true]), #"Replaced Value" = Table.ReplaceValue(#"Promoted Headers"," km","",Replacer.ReplaceText,{"Track Length"}), #"Changed Type1" = Table.TransformColumnTypes(#"Replaced Value",) in #"Changed Type1"

That code was automatically generated, you can then edit it if you wish BUT you have to make sure to refer to the exactly named instance or it will stop working!

Good luck,

Nick 