Need a Clever Person! Will donate maple syrup!

This topic has 8 replies, 3 voices, and was last updated 10 years, 9 months ago by Alzir.

Viewing 9 posts - 1 through 9 (of 9 total)

Author

Posts
July 17, 2013 at 5:06 pm #20198

TurksMeister
Participant

Hi Chaps.

I need to get the following information in to an Excel file, with each entry in the correct column, but cannot get it to “Text to columns” properly. Anyone clever enough in the art of data reformatting?!

http://mapapi.winnipeg.ca/mapapi/wfs.ashx?maptypeid=2&featurelist=13706&where=where%20startdate%26gt;=’01-jan-2012’%20and%20enddate%26lt;=’31-dec-2012′

As above, will pay in maple syrup, but you will have to collect it yourself!

July 17, 2013 at 5:18 pm #85265

TurksMeister
Participant

So every },{ marks the end of a line… well the }, bit does…

Hmm might be able to do this myself

July 17, 2013 at 8:46 pm #85266

Alzir
Keymaster

If you can’t before i’m sober enough to think this is a challenge, i’ll be disappointed in you turks, disappointed.

July 17, 2013 at 9:36 pm #85267

TurksMeister
Participant

My life is a dissapointment! I eagerly await your solution!

July 17, 2013 at 10:47 pm #85268

Alzir
Keymaster

Well I’m home and I’m confused by what you want exactly. I thought the link might make it clearer but it’s a big pile of shite (i’m still sobering up btw). What do you need in an excel file and how do you need it organised?

July 18, 2013 at 5:51 pm #85269

TurksMeister
Participant

I sorted it myself! Do I win something?!

July 18, 2013 at 6:28 pm #85270

bmstalker
Participant

Go get yourself some maple syrup

July 19, 2013 at 1:35 pm #85271

TurksMeister
Participant

Whoop!

July 19, 2013 at 4:33 pm #85272

Alzir
Keymaster

Nice one turks, tried to find something yesterday and it was a real pain. Good effort sorting it.
Author

Posts

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic.