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
Fun exercise
Spoiler
Process:
- Identify PMID (Tokenize on "PMID.\s(\d{8})")
- Identify Authors (Tokenize on "FAU\s-\s(.+)")
- Add "|" after each author
- Remove Null records
- Add field "Author"
- Copy down PMID to null records
- Actions above are to allow for crosstab
- Crosstab on '1' (PMID), with Author as Name and Field_11 as Value
- Split "Author" to field for each author
- Remove leading comma from authors
- Replace Nulls with empty cell
- Cleanup and sort
- Identify PMID (Tokenize on "PMID.\s(\d{8})")
- Identify Authors (Tokenize on "FAU\s-\s(.+)")
- Add "|" after each author
- Remove Null records
- Add field "Author"
- Copy down PMID to null records
- Actions above are to allow for crosstab
- Crosstab on '1' (PMID), with Author as Name and Field_11 as Value
- Split "Author" to field for each author
- Remove leading comma from authors
- Replace Nulls with empty cell
- Cleanup and sort
