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 #209: Parsing Insurance Claims

NicoleJohnson
ACE Emeritus
ACE Emeritus

My solution! RegEx for the win, once again 🙂

 

Spoiler
WeeklyChallenge209.JPG

Cheers!

NJ 

balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1588359148467.png

 

JonMcMillin
8 - Asteroid

Thanks for the Challenge!

 

Spoiler
JonMcMillin_0-1588895423818.png

 

Laszlo_D
8 - Asteroid
Spoiler
image.png
VizChic
11 - Bolide

Great work @JonMcMillin 🙂

soha-elghany
8 - Asteroid

🙂

FlorianC
Alteryx
Alteryx

@KevinTang Nice try but your regular expression is not accounting for the last header which does not contain a trailing space.

 

Because there are eight separate elements on the header row, this did not cause an error but "Annual Claims" is not an actual header but rather, I assume, the title of the table. This is causing your headers to be misaligned with the corresponding data.

Florian Carrier
Strategic Solution Consultant
Alteryx
mattreynolds
9 - Comet

Great fun with RegEx!

hanykowska
11 - Bolide

Finally! That took a while...

 

Not the most elegant but fairly automatic (not as automatic as I'd like it to be though. I'll have a look at the solution now and see how you can make it better

 

Spoiler
hanykowska_0-1590129733640.png

 

hanykowska_1-1590129751213.png

 

Amin
8 - Asteroid

Really took me quite some time to do this! Really wish I can use lesser tools though! Attempted Regex, and then resorted to not using it at all.

 

Spoiler
209_Amin.PNG