Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
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
