\documentclass{article}

\usepackage[a4paper]{geometry}

\title{ Uploading scanned letters with Pattypan }

\author{ Sam Wilson }

\date{ 2023 January 2 (Monday), 2:30AM }

\begin{document}
\maketitle
\tableofcontents

Pattypan\footnote{\url{https://commons.wikimedia.org/wiki/Commons:Pattypan}} is a great tool for uploading lots of files to Commons. I'm using it today for a set of scans of airgraphs. I scanned them all yesterday, and gave them hopefully-useful filenames that contain a prefix, date, and bit of info about each. These documents all look pretty much the same when viewed as thumbnails, so it's important to be able to determine at least something by glancing at the filename. That said, it's never good to ''rely'' on metadata being in the filename nor on all files having the same structure to their names.

Anyway, after creating the spreadsheet for these files, I did some tweaking to the data columns:

\begin{enumerate}

\item Filled the \texttt{source} column based on the name column:

\begin{itemize}

\item Formula: \texttt{=CONCAT("{{HMW|wiki=",B2,"}}")}

\item Result: \texttt{{{HMW|wiki=Airgraph 1943-12-30 Adele to Murray}}}

\end{itemize}
\item Extracted the date:

\begin{itemize}

\item Formula: \texttt{=REGEX(B3,"[0-9]{4}-[0-9]{2}-[0-9]{2}")}

\item Result: \texttt{1943-12-30}

\end{itemize}
\item Crucially, any column that uses a formula needs to be copied to a new column with ''values only'' (i.e. "Edit / Paste special / Values only"). Otherwise Pattypan can't see the formula result.

\end{enumerate}

\end{document}