Title export match between extraction and tag download#577

Right now the titles are formatted differently between the extraction download and the tag download, making it inconvenient to use functions like VLOOKUP to synchronize the tag and extraction data for studies that are missing PMID or DOIs. The extraction titles have incorrect characters in them (which I assume come from differences in how the text encoding is being interpreted), so it would be nice to have the current tag titles in both downloads, but the most useful thing would be to have them match, either way!

I don’t quite understand– could you be more specific with the export(s) you’re trying to unify and which column headers (or cells) are not lining up properly? Feel free to email me if there’s sensitive data in play.

I’ll send you some examples from recent nests, the two exports I’m looking at are the MA extraction download from study inspector and the export of all tags under Synthesis. The title columns for the same study have different text strings in some cases.

Thanks! This is a character encoding issue– specifically some of the titles contain UTF-8 non-breaking spaces (C2 A0). It would seem our CSV writer (used in making the MA Extraction export) is interpreting the titles as Latin-1 encoded, which means C2 is being converted to a A with circumflex and A0 to another non-breaking space (vs. just a space for) as it writes out UTF-8.

Release 1.101.1 upgrades all our sheet-based exports to XLSX. Thanks Erin!

Awesome, thank you!