Challenge #36: Data Cleansing Extract Authors

[PeterH23]

My Solution

Spoiler

[Soonyeon_Kim]

I was shocked because of

"apostrophe"

I couldn't imagine it.!

Plus How can I use the Spoiler which is covered images in this reply?

Could anyone give me the way? 🙂

[grossal]

Time to work on these challenges!

Spoiler

This took me way too long and many tools, but my mind wasn't able to get it done with less.

[Soonyeon_Kim]

Thank you for your interest and give a better way.

I absolutely agree with using "Left function" in the second tool, multi-row formula.

I also thought to use "Left" at first, but I would like to use the regex that is more general. That's why mine is longer than I expected.

[GaneshBo]

My Solution:

[joshuaburkhow]

Loved seeing how so many different solutions present themselves!

[steven4320555]

Given the format of the column name, an easier way is to use text to column. But I have tried to use running total, and multi-row formula as a practice.

Spoiler

[steven4320555]

Hi @Soonyeon_Kim 

Just in case you still haven't found the answer for your spoiler question.

Spoiler

"

Spoilers are another popular option. Click the Insert a Spoiler Tag icon to create a spoiler container. This is essentially a mini response box that will be collapsed so as not to give away any tricks for those who haven’t solved yet.

Many folks like to insert a screen capture of their workflow. Make sure your cursor is in the spoiler box and use the “Photo” icon to upload an image.

"

https://community.alteryx.com/t5/Weekly-Challenge/How-to-Respond-to-a-Weekly-Challenge/td-p/429291 

[Jean-Balteryx]

Here is my solution !

[JeremyGonzva]

.