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
Right, no problems here, just some nice parsing.
Spoiler
I used the sample tool to skip the first line, and then used "Text to Columns" to split the field into two columns using the "-".
I then used the "Data Cleansing" tool to strip out the leading whitespaces.
I used the "Multi-row formula" tool to assign the PMID value to all rows within a record, then filtered to only show the FAU rows. I then used the "Multi-row Formula" tool to assign the author number then cross-tabbed into the right format.
I then used the "Data Cleansing" tool to strip out the leading whitespaces.
I used the "Multi-row formula" tool to assign the PMID value to all rows within a record, then filtered to only show the FAU rows. I then used the "Multi-row Formula" tool to assign the author number then cross-tabbed into the right format.
Oh Boy!
This was actually a bit tougher than I thought, but I finally made it
Spoiler
It ain't pretty, but it works.
Seems like my FAU filter also included an address and that did mess up the result.
So after a lot of filtering and so forth, it came to look like this
The Workflow
Seems like my FAU filter also included an address and that did mess up the result.
So after a lot of filtering and so forth, it came to look like this
The Workflow
Still on my way to the Lhotse Face
/Verakso
This brings back memories of writing science papers and learning anything possible from pubmed papers :-D
