CODEWITHSUNDEEP
htmlgoogle-sheetsimport
Josh Thomas
Josh Thomas

Reputation: 1

ImportHTML Pulling Through Text As Number In Google Sheets

I am scraping data from a website for a spreadsheet I'm putting together. I have used the same formulae to pull the same data from multiple different pages of the website however I have stumbled across a page where it has stopped pulling through correctly.

https://docs.google.com/spreadsheets/d/1041JPTfPYTzVaSAmA4e1UMsUn2gRi3lE1-GaMImM8o4/edit?usp=sharing

Above is a link to show the problem I'm having. A-D is pulling through exactly as I want. F to I is pulling the column headers and nothing else. By removing the condition in the Query I can get it to pull through in K to N however it only pulls through the 3 number values in the 4th column and is not pulling through values about 950 that are written as 1K, 2K etc.

I can't seem to put any conditions on the query solely for this specific page. Am I doing something wrong? Or is this web page, despite all surface appearances, somehow different?

Any help would be greatly appreciated.

Upvotes: 0

Views: 308

Answers (1)

player0
player0

Reputation: 1

try:

=ARRAYFORMULA(QUERY(TO_TEXT(IMPORTHTML(
 "https://www.futbin.com/players?page=1&version=all_nif&club=5&sort=ps_price&order=asc",
 "table", 1)),
 "select * where Col5 <> '0'"))

Upvotes: 1

Related Questions