Converter dia da semana em número

Question

fabricante de texto,

como posso alterar o dia da semana do conteúdo do arquivo para exibir o número:

Segunda = 2, Terça = 3... Sábado = 7, Domingo = 1

Meu código

\documentclass{article}
\usepackage{filecontents}
\begin{filecontents*}{file.tex}
%Type =1,2...10
No,Dayofweek,Name
1,Monday,A
2,Tuesday,B
3,Wednesday,D
30,Thursday,C
31,Friday,M
131,Saturday,N
132,Sunday,K

\end{filecontents*}

\usepackage{datatool}

\DTLloaddb[autokeys=false]{file}{file.tex}

\begin{document}
Display Dayofweek => Number 

\DTLforeach*
    {file}% Database
    {\No=No,\Dayofweek=Dayofweek,\Name=Name}{%
    \noindent\Dayofweek \quad \Name\par

  }% 

\end{document}

Answer 1

Se eu entendi a pergunta corretamente...

\documentclass{article}
\usepackage{filecontents}
\begin{filecontents*}{file.tex}
%Type =1,2...10
No,Dayofweek,Name
1,Monday,A
2,Tuesday,B
3,Wednesday,D
30,Thursday,C
31,Friday,M
131,Saturday,N
132,Sunday,K

\end{filecontents*}
\usepackage{datatool}
\DTLloaddb[autokeys=false]{file}{file.tex}
\newcommand\Sundaycode{1}
\newcommand\Mondaycode{2}
\newcommand\Tuesdaycode{3}
\newcommand\Wednesdaycode{4}
\newcommand\Thursdaycode{5}
\newcommand\Fridaycode{6}
\newcommand\Saturdaycode{7}
\newcommand\daycode[1]{\csname #1code\endcsname}
\begin{document}
Display Dayofweek $=>$ Number 

\DTLforeach*
    {file}% Database
    {\No=No,\Dayofweek=Dayofweek,\Name=Name}{%
    \noindent\daycode{\Dayofweek} \quad \Name\par

  }% 
\end{document}