Importing txt from web

[Neico]

Hello,

I'm having issues to import and properly format the following file:

http://weather.rap.ucar.edu/surface/stations.txt

Any suggestions how that could be done are highly appreciated!

[wwatson · Accepted solution]

I pulled this together, I hope it does what you want.

This would have made for a great weekly challenge 🙂

[Neico]

Thank you very much! This is a great start and definitely is helpful.

It just appears that the data stops at "Mexico". Any idea why not the whole data is imported?

[wwatson]

It looks like the countries after Mexico don't have the title row starting CD.

An additional parse would be required for those countries.

Can you handle that or do you need help with it?

[Neico]

I'm not sure how to account for that. Would be great if you could show. Thank you!

[ImadZidan · Accepted solution]

Hello @Neico ,

I have looked at @wwatson  workflow and did a little change to the formula.

Check if it does the job.

I hope its ok with you @wwatson .

I hope it helps.

[wwatson]

@Neico please mark my solution as an accepted solution as well as the one submitted by @ImadZidan . It contains 95% of the solution and I just didn't have time to make the minor adjustment required.

Thanks

[Neico]

of course, you're absolutely right! Thanks again!