CSV-Sorter

https://t-f-s.github.io/csvsorter/
Admin
CSV-Sorter is a Java command-line program that sorts CSV files based on an XML configuration,...
Tokens:787
Snippets:9
Trust Score:9.7
Update:3 months ago
Show doc for...
Tokens:
Raw
### LaTeX On-the-fly Sorting

Source: https://t-f-s.github.io/csvsorter

Example of using csvsimple in LaTeX to sort CSV data during document compilation.

```latex
% \documentclass{article}
% \usepackage{array,booktabs,csvsimple}
% \begin{document}

\csvreader[sort by=sumsort.xml,
  head to column names,
  tabular=lllcc,
  table head=\toprule\textbf{Artist} & \textbf{Title} & \textbf{Country} &
             \textbf{Points} & \textbf{TV+JV}\midrule,
  table foot=\bottomrule]
{songcontest.csv}{}
{\Artist & \itshape''\Title'' & \Country &
 \bfseries\the\numexpr\Televote+\Juryvote\relax & $(\Televote+\Juryvote)$}

% \end{document}

```

--------------------------------

### Sample CSV Input File

Source: https://t-f-s.github.io/csvsorter

A sample CSV file named songcontest.csv containing song contest data.

```csv
Title,Artist,Country,Televote,Juryvote
La la la la la,The Singers,United Kingdom,25,62
One and two and three,Hansi Unterober,Germany,47,35
Rarara,Channel Rats,Grand Fenwick,12,14
The green hills of the shire,Frodo and Friends,New Zealand,76,45
Paris e Calais,Chantal and Pascal,France,47,41
The bell rings,Baab,Sweden,87,24

```

--------------------------------

### XML Configuration for Sorting

Source: https://t-f-s.github.io/csvsorter

An XML configuration file sumsort.xml defining sorting criteria by sum and country.

```xml
<?xml version="1.0" encoding="UTF-8"?>
<csv>
  <sortlines>
    <sum order="descending" type="integer">
      <column name="Televote"/>
      <column name="Juryvote"/>
    </sum>
    <column name="Country" order="ascending" type="string"/>
  </sortlines>
</csv>

```

--------------------------------

### Command-Line Execution

Source: https://t-f-s.github.io/csvsorter

The command to execute csvsorter using the specified configuration and input files.

```bash
csvsorter -c sumsort.xml -i songcontest.csv -o songcontest_sorted.csv
```

--------------------------------

### Sorted CSV Output File

Source: https://t-f-s.github.io/csvsorter

The resulting CSV file after applying the sorting configuration.

```csv
Title,Artist,Country,Televote,Juryvote
The green hills of the shire,Frodo and Friends,New Zealand,76,45
The bell rings,Baab,Sweden,87,24
Paris e Calais,Chantal and Pascal,France,47,41
La la la la la,The Singers,United Kingdom,25,62
One and two and three,Hansi Unterober,Germany,47,35
Rarara,Channel Rats,Grand Fenwick,12,14

```
Tokens:
Raw