Bug Tracker

ID	299🔗
Date:	2025-03-25 10:33:23
Last update:	2025-03-25 12:25:52
Status	Closed (Fixed)
Category	datatool
Version	3.2
Summary	Missing cell content when reading CSV file

Return to Search Results

Description

I am reading a CSV file with datatool. If a cell contains multiple separators (,), the part in between the separators is missing (cell1.3.2 in the MWE).

Corresponding question on StackExchange: [TeX.SX Link]

MWE

Download (541B)

\documentclass[varwidth]{standalone}

\begin{filecontents}[overwrite,noheader]{test.csv}
cell1.1,cell1.2,"cell1.3.1,cell1.3.2,cell1.3.3",cell1.4
cell2.1,cell2.2,"cell2.3.1,cell2.3.2,cell2.3.3",cell2.4
\end{filecontents}

\usepackage{datatool}

\DTLread[
	name={test},
	format=csv,
	separator={,},
	delimiter={"},
	csv-content=tex,
	noheader,
	keys={first,second,third,fourth}
]{test.csv}%

\begin{document}

\DTLforeach*{test}{\first=first,\second=second,\third=third,\fourth=fourth}{%
	\first; \second; \third; \fourth \\
}

\end{document}

Evaluation

I've identified the problem and fixed it. I will upload v3.3 when the documentation has finished rebuilding.

Update: I've uploaded v3.3. Please allow a few days for the new version to reach your TeX distribution.

Comments

1 comment.

🔗Comment from anonymous
Date: 2025-03-27 06:45:52

Thanks for the prompt fix. It works like expected.

Replying to Comment #162:

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. All guest comments have to be manually checked before they appear on the page. There are too many bots trying to spam the site to allow unauthenticated users to post without verification.

Confirm ID:

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