Challenge #36: Data Cleansing Extract Authors

[SJKIM]

Done

[caltang]

Done & Dusted!

Spoiler

[mithily]

Spoiler

not too bad 

[Computernerd]

The proposed solution was a little more efficient but my way worked fine.

[olivier_newman]

tough 

[Computernerd]

Attached is my solution

[Tgigs]

My solution attached.

Used formula tool to identify PMID and FAU lines, then regex to extract the PMID number / author name, then used filter, cross tab, join, dynamic rename.

[olga_strubbe]

Thank you, @GeneR !  This was a nice challenge. 

[MatthewGrant12]

Solution

[hmaddy1]

Here's my solution!