[Tex/LaTex] tabular – changing column separator

tables

Is it possible to change default column separator character (&) for tabular environment ? I find it convenient to edit content of table in LibreOffice Calc and save it as csv file. This csv file I include in tex code like this:

\begin{table}[H]
    \begin{tabulary}{\textwidth}{*{6}{L}}
        \toprule
        \input{data.csv}
    \end{tabulary} \hfill \
\end{table}

It is possible to change column separator when first saving csv file so this is not problem. But when opening already created csv file, editing it and saving, LibreOffice without asking uses default column separator which is semicolon (;) and rewrites previous separator (&). So for me it would be better to switch latex to using semicolon as column separator character instead of ampersand.

Best Answer

A solution with cvssimple:

\begin{filecontents*}{\jobname.csv}
11.0; 12.3; one; two
1.2; 33.11; five; six
\end{filecontents*}

\documentclass{article}
\usepackage{booktabs,tabulary}
\usepackage{csvsimple}

\begin{document}
\begin{tabulary}{\textwidth}{*{4}{L}}
\toprule
1 & 2 & 3 & 4 \\
\midrule
\csvreader[
  separator=semicolon,
  no head,
  late after line=\\,
]{\jobname.csv}{}{%
  \csvcoli & \csvcolii & \csvcoliii & \csvcoliv
}
\bottomrule
\end{tabulary}

\bigskip

\end{document}

enter image description here

Related Question