Take the 2-minute tour ×
TeX - LaTeX Stack Exchange is a question and answer site for users of TeX, LaTeX, ConTeXt, and related typesetting systems. It's 100% free, no registration required.

I have some data stored in a CSV file, in this manner:

000000001 @ name @ information @ more information @ some more information

I also have a information.tex file containing the numbers from the first column throughout (this file is \input into my main document):

\chapter{Some information about 000012311}
    This is some text about 000012311 and 000012312\footnote{See also 000012313}.
\chapter{Some other information}
    This text is about 000000001.

I currently use a BASH script which replaces all numbers appearing information.tex matched to the first column of the CSV file with a macro, \mymacro{}{}{}{}, where each {} contains data from a column (second, third, fourth, and fifth).

For e.g., where the input file above contains This text is about 000000001., using the CSV file line above, it becomes This text is about \mymacro{name}{information}{more information}{some more information}., so when compiled, the text is displayed according to the definition of \mymacro. Essentially, I am using BASH to edit information.tex, after which I compile it.

Can I remove the need for BASH and do this directly with LuaTeX or some form of ConTeXt?

share|improve this question
3  
Is it possible to create your CSV with commas to separate the contents? Also, does the CSV only contain unique entries? If so, this can most likely be done entirely within LaTeX using datatool. –  Werner Jan 18 '12 at 6:27
    
I used "@" because commas appear throughout the contents, however, commas with quotes around the content would be okay. The CSV file is easily changed. There are no duplicate rows and the items appearing in columns 1 and 2 are never identical. I tried datatool, but it seems to have difficulty with UTF-8. –  Village Jan 18 '12 at 10:21

2 Answers 2

up vote 3 down vote accepted

My approach is to read all lines from the file, split each line in it's arguments (divided by @) and store the arguments in a lua-table (tableItem) which is added to an other table (dataTable). We give the tableItem a name that we can access each item by name not by index. If we use the first argument of each line for the name we have direct access to the (sub)tables (tableItem) via the given number in the text using a macro called csvData. In this macro one can access the table and its arguments to format a latex-string or do whatever is needed.

\documentclass{book}

\def\csvData#1{%
    \directlua{
        %here one can access the stored arguments of the input line via the table item name
        d=dataTable[#1];
        tex.sprint(d.arg1..d.arg2..d.arg3..d.arg4..d.arg5)%
    }
}

\def\readDataFile{%
  \directlua{%
    local input = io.open('datafile.dat', 'r')
   dataTable = {}
    for line in input:lines() do
        local split = string.explode(line,"@")
        tableItem={split[1]}%item name is the first input argument of the line
        tableItem.arg1=split[1]
        tableItem.arg2=split[2]
        tableItem.arg3=split[3]
        tableItem.arg4=split[4]
        tableItem.arg5=split[5]

        table.insert(dataTable,tableItem)
    end
    input:close()
  }%
}
\makeatother


\begin{document}
\readDataFile
\noindent
\csvData{000000001}.\\
\csvData{000000004}.\\
\csvData{000000007}.\\
\end{document}
share|improve this answer

A simple approach is to call string.explode() for that. As you don't give the exact detail what goes where, I can only show the frame for that:

\documentclass{book}
\usepackage{luacode}
\begin{document}

\begin{luacode*}

for line in io.lines("somedata.dat") do
  local line_t = string.explode(line,"@")
  tex.sprint(string.format("\\chapter{%s} Some information about %s",line_t[1],line_t[2]))
end
\end{luacode*}

\end{document}

where somedata.dat looks like this:

000000001 @ name @ information @ more information @ some more information
000000002 @ name2 @ information2 @ more information2 @ some more information2
share|improve this answer
1  
@Village If you really want a CSV file, then my answer would be different, of course (it doesn't handle CSV files, but with LPEG it's not difficult). –  topskip Jan 18 '12 at 12:26
    
I have a CSV file, but I can convert it to other formats easily with OpenOffice.org. –  Village Jan 18 '12 at 12:33

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.