Latest news 2021-06-05: New blog post: Dickimaw Books Site Account.

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:

Datatool gobbling spaces

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.

🔗Comment from Alan Munn
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.

Replying to Comment #59:

Name (optional):

Are you human? Please confirm the bug report ID (which can be found at the top of this page) or login if you have an account.

Comment:

You can use the following markup:

Block:

[pre]Displayed verbatim[/pre]
[quote]block quote[/quote]

In line:

[tt]code[/tt]
[file]file/package/class name[/file]
[em]emphasized text[/em]
[b]bold text[/b]
[url]web address[/url] [sup]superscript[/sup]
[sub]subscript[/sub]

Ordered list:
[ol]
[li]first item[/li]
[li]second item[/li]
[/ol]

Unordered list:
[ul]
[li]first item[/li]
[li]second item[/li]
[/ul]

You can use the Preview button to review your message formatting before submitting.


Add Comment

Name (optional):

Are you human? Please confirm the bug report ID (which can be found at the top of this page) or login if you have an account.

Comment:

You can use the following markup:

Block:

[pre]Displayed verbatim[/pre]
[quote]block quote[/quote]

In line:

[tt]code[/tt]
[file]file/package/class name[/file]
[em]emphasized text[/em]
[b]bold text[/b]
[url]web address[/url] [sup]superscript[/sup]
[sub]subscript[/sub]

Ordered list:
[ol]
[li]first item[/li]
[li]second item[/li]
[/ol]

Unordered list:
[ul]
[li]first item[/li]
[li]second item[/li]
[/ul]

You can use the Preview button to review your message formatting before submitting.

Page permalink: https://www.dickimaw-books.com/bugtracker.php?key=123