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 #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