Convert dayofweek to number

Question

Texmaker,

how i can change dayofweek of filecontent to diplay number:

Monday = 2, Tuesday = 3...Saturday = 7, Sunday = 1

My code

\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

If I understood the question correctly...

\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}