Challenge #36: Data Cleansing Extract Authors

[htrivedi123]

Here is my approach. I am not comfortable with Regex like many of you have used so I utilized more tools than most but finally got there. 

Mental note, - learn Regex!!!

[amcollen]

There may be better ways to do this... but mine works.

[amcollen]

Noticed I was getting some bad data.  Tweaked my solution to fix.  Downloaded someone else's solution (who was complaining that it was inefficeint), ran in 8 seconds.  My sort alone takes almost a minute: I need to learn more tools.

[Vikash_kumar]

Thanks for this challenge question, i added one more tool in my armour called "Multi-Row-Formula".

Solution really helped me to learn and implement this new tool.

[DavidLane]

Relatively straightforward one with the use of regex tools.

Spoiler

[Oren_Soloman]

There are two solutions for this.  The first one works but I can't figure out why, so I redid it a second way.  

[AlexC2]

Solution attached

[maazinh]

Getting better with the multi row formula

[MikeMcFadden]

Spoiler

My solution

[Nicholas_Norton]

I accidentally deleted my original solution, so I had to re-do it! Nevertheless, shout out to user htrivedi123 for giving me the idea of how to tackle this problem! I too have yet to fully understand Regex, but by using his approach, I was able to learn how to use the Multi-Row Formula a bit. 🙂 

Spoiler