mjhjmtu

I am making a wine list from a CSV file (see my first question here: How to import data from excel and format it as text in LaTeX?) and I need to align the prices on the right.

To do this, I used the datatool package to fetch the informations from my spreadsheet, DTLforeach to iterate what I wanted to do and hfill to align my prices on the right. (see code after the picture)

As you can see on the picture, it worked very well for every line but the last one of each (subsub)section, which is slightly misaligned:

Here is my code:

documentclass[12pt]article
usepackage[utf8]inputenc

% Pour modifer les marges
usepackagegeometry
% Marges du document 
geometryhmargin=1.5cm,vmargin=1.5cm


% To remove the heading of the table of contents ("Contents")
makeatletter
renewcommandtableofcontents%
 @starttoctoc%

makeatother %%% WAS makeatotherx = ERROR %%%

% To make itemized lists
% This package provides user control over the layout of the three basic list environments: enumerate, itemize and description. It supersedes both enumerate and mdwlist (providing well-structured replacements for all their funtionality), and in addition provides functions to compute the layout of labels, and to ‘clone’ the standard environments, to create new environments with counters of their own.
usepackageenumitem

% Datatool package to load external files (csv)
usepackagedatatool

%--------------------------%

titleCarte des Vins
authorB
datetoday

%--------------------------%
setcountersecnumdepth-2
begindocument
maketitle
tableofcontents

%--------------------------%
newpage
sectionBordeaux 

% Load CSV database (here bordeaux.csv)
% and give it a label (here BOR)
DTLloaddbBORbordeaux.csv

 subsectionRed
%%%%%%% CUT CODE %%%%%%%%%%%%%%%%%%%%%%%%%
newpage

 subsubsectionSaint-Julien
%%%%%%%%%%%%%%%
% Iteration for Bordeaux Red Saint-Julien (R03)
DTLforeach*[DTLiseqRegionR03] % Condition
 BOR % Database label
 Vintage=Vintage,Name=Name,Classification=Classification,Type=Type,Origin=Origin,Region=Region,CostPrice=CostPrice % Assignment
% Stuff to do at each iteration:
beginitemize %%% ABSENT IN MY ORIGINAL CODE %%%
 item
 textbfVintage
 textbf Name
 textit Classification
 hfillCostPrice
enditemize %%% ABSENT IN MY ORIGINAL CODE %%%

%%%%%%%%%%%%%%%

 subsubsectionMargaux
%%%%%%%%%%%%%%%
% Iteration for Bordeaux Red Margaux (R04)
%%%%%%%%%%%%%%%%% CUT CODE%%%%%%%
enddocument

How can I align all my prices on the right?

Excerpt of my CSV file:

CODE,Vintage,Name,Classification,Origin,Size,Type,Wine,Region,Stockholding,CostPrice,TOTCostPrice,TOTCostPriceBis
GRUAUD LAROSE,1971,Château Gruaud-Larose,2ème Grand Cru Classé ,Saint-Julien,Bottle,Red,Bordeaux,R03,2.0, £15.00 , £30.00 , £30.00 
LALANDE BORIE,2011,Château Lalande-Borie,,Saint-Julien,Bottle,Red,Bordeaux,R03,35.0, £19.70 , £689.50 , £689.50 
RESERVE LEOV-BARTN,2011,La Réserve de Léoville Barton,,Saint-Julien,Bottle,Red,Bordeaux,R03,12.0, £20.86 , £250.32 , £250.32 
CLOS DU MARQUIS,2004,Clos du Marquis,,Saint-Julien,Bottle,Red,Bordeaux,R03,3.0, £35.83 , £107.49 , £107.49 
GRUAUD LAROSE,2005,Château Gruaud-Larose,2ème Grand Cru Classé ,Saint-Julien,Bottle,Red,Bordeaux,R03,16.0, £43.49 , £695.84 , £695.84 
DUCRU BEAUCAILLOU,1978,Château Ducru-Beaucaillou,2ème Grand Cru Classé ,Saint-Julien,Bottle,Red,Bordeaux,R03,2.0, £56.52 , £113.04 , £113.04 
LAGRANGE 3EME SJ,2005,Château Lagrange,3ème Grand Cru Classé ,Saint-Julien,Bottle,Red,Bordeaux,R03,6.0, £58.75 , £352.50 , £352.50 
LEOVILLE POYFERRE,2000,Château Léoville Poyferre,2ème Grand Cru Classé ,Saint-Julien,Bottle,Red,Bordeaux,R03,2.0, £73.33 , £146.66 , £146.66 
GRUARD LAROSE,1986,Château Gruaud-Larose,2ème Grand Cru Classé ,Saint-Julien,Bottle,Red,Bordeaux,R03,1.0, £100.00 , £100.00 , £100.00 

There are two obvious problems with your code. You get errors about both of them.

Firstly you mistyped

makeatother

as makeatotherx which causes LaTeX to complain

! Undefined control sequence.
l.22 makeatotherx

Secondly your loop code in DTLforeach calls item but there is no surrounding list environment that would know how to deal with it.

Since you want to use item to get a new line, I suggest a plain trivlist in this case.

%RequirePackagefilecontents
beginfilecontents*bordeaux.csv
CODE,Vintage,Name,Classification,Origin,Size,Type,Wine,Region,Stockholding,CostPrice,TOTCostPrice,TOTCostPriceBis
GRUAUD LAROSE,1971,Château Gruaud-Larose,2ème Grand Cru Classé ,Saint-Julien,Bottle,Red,Bordeaux,R03,2.0, £15.00 , £30.00 , £30.00 
LALANDE BORIE,2011,Château Lalande-Borie,,Saint-Julien,Bottle,Red,Bordeaux,R03,35.0, £19.70 , £689.50 , £689.50 
RESERVE LEOV-BARTN,2011,La Réserve de Léoville Barton,,Saint-Julien,Bottle,Red,Bordeaux,R03,12.0, £20.86 , £250.32 , £250.32 
CLOS DU MARQUIS,2004,Clos du Marquis,,Saint-Julien,Bottle,Red,Bordeaux,R03,3.0, £35.83 , £107.49 , £107.49 
GRUAUD LAROSE,2005,Château Gruaud-Larose,2ème Grand Cru Classé ,Saint-Julien,Bottle,Red,Bordeaux,R03,16.0, £43.49 , £695.84 , £695.84 
DUCRU BEAUCAILLOU,1978,Château Ducru-Beaucaillou,2ème Grand Cru Classé ,Saint-Julien,Bottle,Red,Bordeaux,R03,2.0, £56.52 , £113.04 , £113.04 
LAGRANGE 3EME SJ,2005,Château Lagrange,3ème Grand Cru Classé ,Saint-Julien,Bottle,Red,Bordeaux,R03,6.0, £58.75 , £352.50 , £352.50 
LEOVILLE POYFERRE,2000,Château Léoville Poyferre,2ème Grand Cru Classé ,Saint-Julien,Bottle,Red,Bordeaux,R03,2.0, £73.33 , £146.66 , £146.66 
GRUARD LAROSE,1986,Château Gruaud-Larose,2ème Grand Cru Classé ,Saint-Julien,Bottle,Red,Bordeaux,R03,1.0, £100.00 , £100.00 , £100.00 
endfilecontents*
documentclass[12pt]article
usepackage[utf8]inputenc

makeatletter
renewcommandtableofcontents%
 @starttoctoc%

makeatother

usepackageenumitem
usepackagedatatool

begindocument
sectionBordeaux 
DTLloaddbBORbordeaux.csv
subsectionRed
subsubsectionSaint-Julien

begintrivlist
DTLforeach*[DTLiseqRegionR03] % Condition
 BOR % Database label
 Vintage=Vintage,Name=Name,Classification=Classification,Type=Type,Origin=Origin,Region=Region,CostPrice=CostPrice % Assignment
% Stuff to do at each iteration:
 item
 textbfVintage
 textbf Name
 textit Classification
 hfillCostPrice

endtrivlist

enddocument

Possibly a table (tabular) would be a better fit.

Apart from the problem in the code, the root issue is that CostPrice always has an ending space, as one can see by using textttmeaningCostPrice+++.

This comes from the fact that your csv data has spaces before the commas, as datatool doesn't trim leading or trailing spaces.

Note that spaces count in the usual TeX manner and won’t be trimmed
from either side of the separators. (p. 46 of the datatool user manual)

Thanks to @NicolaTalbot who kindly pointed it out in a comment.

Here is an excerpt of your data file:

GRUARD LAROSE,1986,Château Gruaud-Larose,2ème Grand Cru Classé ,Saint-Julien,Bottle,Red,Bordeaux,R03,1.0, £100.00 , £100.00 , £100.00 

where the spaces show around the monetary items.

With the following (from @moewe's comment to OP)

beginitemize
%%%%%%%%%%%%%%%
% Iteration for Bordeaux Red Saint-Julien (R03)
DTLforeach*[DTLiseqRegionR03] % Condition
 BOR % Database label
 Vintage=Vintage,Name=Name,Classification=Classification,Type=Type,Origin=Origin,Region=Region,CostPrice=CostPrice % Assignment
% Stuff to do at each iteration:
 item
 textbfVintage
 textbf Name
 textit Classification
 hfillCostPrice

%%%%%%%%%%%%%%%
enditemize

there is no problem

The extra space doesnt show then. (it is suppressed by item paragraph)

Remark: in fact even with your buggy code you could have avoided the sapce this way:

%%%%%%%%%%%%%%%
% Iteration for Bordeaux Red Saint-Julien (R03)
DTLforeach*[DTLiseqRegionR03] % Condition
 BOR % Database label
 Vintage=Vintage,Name=Name,Classification=Classification,Type=Type,Origin=Origin,Region=Region,CostPrice=CostPrice % Assignment
% Stuff to do at each iteration:
 item
 textbfVintage
 textbf Name
 textit Classification
 hfillCostPrice
%<----- suppress space from line end
%%%%%%%%%%%%%%%

Because then there is only ONE not TWO space tokens at the end of paragraph. Of course much better is to wrap in itemize else item is illegal.