Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #78: Find the Best Housing Markets

SeanAdams
17 - Castor
17 - Castor

Thanks for the challenge @NicoleJohnson

 

Spoiler

Took a different approach than most others - instead of taking the file into a string and then parsing, I just dumped it into a temp file, and then used the "Fixed Width File" option which takes care of the variable length of the rows by putting in nulls.

Then just had to do a bit of cleanup for the row overruns, and job done.

2017-10-08_20-25-08.png


edorlando07
7 - Meteor

Challenge #78 has been conquered!  Slightly different solution.

LandonG
8 - Asteroid

Solution attached.

PhilipMannering
16 - Nebula
16 - Nebula

Solution attached.

 

Spoiler
My AppMy App
ggruccio
ACE Emeritus
ACE Emeritus

Getting better with parsing all the time....

samN
10 - Fireball

regex for the win

jamielaird
14 - Magnetar

Solution attached, including a catch for the pesky newline issue.

 

Spoiler
solution_78.png
Natasha
9 - Comet

Didn't build the app but practiced Regex

Spoiler
Screen Shot 2017-12-29 at 21.56.35.png
jasperlch
12 - Quasar

Solution attached.

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed