Weekly Challenges

cgoodman3 · ‎06-14-2019

I found this post really helpful as I usually do lots of text to columns to parse out the tags, but by searching for the last instance of a tag you can then get the text after this, which saved some tools.

Challenge 40.PNG

I found this post really helpful as I usually do lots of text to columns to parse out the tags, but by searching for the last instance of a tag you can then get the text after this, which saved some tools.

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com

RWvanLeeuwen · ‎06-18-2019

I think I solved it although I am unsure about a few records... It seems I am missing a few physicians but I'll be needing an expert opinion on where these records went.

My workflow:

Spoiler

joemkcarr · ‎06-21-2019

Enjoyed this one

Hannah_Lissaman · ‎06-24-2019

Another challenge where RegEx does a lot of heavy lifting! Here's my solution:

Greg_Murray · ‎06-27-2019

Solution attached

KaleyVolk1 · ‎07-01-2019

I just started using this application (love it btw) and here is my solution!

KaleyVolk1 · ‎07-01-2019

I just started using this application (love it btw) and here is my solution!

AndrewRein · ‎07-02-2019

Johnny_Analytics · ‎07-10-2019

Spoiler

smoskowitz · ‎07-15-2019

It's crude and not elegant -- but it gets the job done.

Weekly Challenges

IDEAS WANTED

Challenge #40: Parsing a HTML File