Skip to content

Instantly share code, notes, and snippets.

@afermg
Created June 30, 2025 19:32
Show Gist options
  • Select an option

  • Save afermg/58e0d4c0066b2d35475647db3354738a to your computer and use it in GitHub Desktop.

Select an option

Save afermg/58e0d4c0066b2d35475647db3354738a to your computer and use it in GitHub Desktop.
Convert the Carpenter-Singh lab format for author details into the biorxiv format.
awk 'BEGIN {FS="\t"; OFS="\t";}; {if (NR > 4) {corr=""; if (NR==11) corr="X"; print $9,$6,$2,$3,$4,"",corr,"","",$7;}}' cp\ measure\ authors.xlsx\ -\ Authors.tsv | iconv -f utf8 -t ascii//TRANSLIT//IGNORE | cat (printf "Email\tInstitution\tFirst Name\tMiddle Name(s)/Initial(s)\tLast Name\tSuffix\tCorresponding Author\tHome Page URL\tCollaborative Group/Consortium\tORCiD\n" | psub) - > cp_measure_authors.tsv
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment