Bug Tracker 
| ID | 123🔗 |
|---|---|
| Date: | 2017-04-03 19:38:20 |
| Status | Closed (Fixed) |
| Category | datatool |
| Version | 2.27 |
| Summary | datatool gobbles space |
Sign in to subscribe to notifications about this report.
Description
Hi Nicola,If the first character of the first column of the CSV file is followed by a space, that space appears to be gobbled by datatool. It only happens with the first column, and only if there is a single character followed by a space (i.e., if the column begins with two or more characters, no spaces are gobbled. Here's a link to the question I posted on Stackexchange:
MWE
Download (614B)
\listfiles
\begin{filecontents}{\jobname.csv}
Sentence1,Sentence2,Sentence3
The child played a new game.,He played it three times with his friends.,He loved the game.
I visited my childhood home last week.,It's just as I remembered it.,My house has always been white.
It's just as I remembered it.,I visited my childhood home last week.,My house has always been white.
\end{filecontents}
\documentclass{article}
\usepackage{datatool}
\DTLloaddb{sentences}{\jobname.csv}
\begin{document}
\DTLforeach{sentences}{%
\sOne=Sentence1,\sTwo=Sentence2,\sThree=Sentence3}
{%
\sOne\par
\sTwo\par
\sThree\par
}
\end{document}Evaluation
Fixed in v2.29 (2017-11-12). The way that datatool reads lines from the CSV file has been changed, which has fixed this problem.
Comments
1 comment.
Replying to Comment #59:
Add Comment
Page permalink: https://www.dickimaw-books.com/bugtracker.php?key=123

Date: 2017-04-04 15:48:38
Further testing by Enrico shows that it's either a one character word or any initial braced group that will gobble the space. So
{The} child ...will also show up as 'Thechild' if in the first column of a row.