Const version = "1.1"
'This is the script-version of csvtolatex version 1.1
'So you can also use csvtolatex with a configuration file with the extension .ctl
'for more information see the docimentation
'Every one who uses this script agrees with the License you find in License.txt.
'here you write the path and the filename of the input-file you are using.
Const iPath = "C:\users\documents\inpufile.csv"
'here you write the path, where all output-files should be written
Const ePfad = "C:\users\documents\tables\"
'here you can switch between text- and mathmode
'for mathmode it is "$" for textmode it is "":
Const mode = "$"
'this is mathmode
'information for inputfile.csv
'every table begins with '/begin{' this defines the outputfile.
'example: /begin{output1.csv}
'every row in a table has to end with '//' respectivly ';//'
'if you are using program like MS Excel just write at the end of every row '//'
'every table ends with '/end'
'example: /end
'you may use '\cline' or '/cline' to make a \cline
'you may use '/blank', if a cell has to blank, but
'you can use '/.,' to have a semicolon (';') in your table
'now there is no need to change anything
Dim index, delete, lineend, zusatztext
Dim mnumber, worktext, testnumber, zwischen, addition, arbeitstext, geteilt, nCount, indexi, muellzahl, head
index = "0"
delete = "@��@�"
Dim Fso, iFile, eFile, Text, ePath
Set Fso = CreateObject("Scripting.FileSystemObject")
Set iFile = Fso.OpenTextFile(iPath)
Do Until iFile.AtEndOfStream
Text = iFile.ReadLine
Do While ((InStr(Text, ";//;")))
Text = Replace(Text, ";//;", ";//")
Loop
Text = Replace(Text, ";/endhead", ";// /endhead")
Do While ((InStr(Text, "/endhead;")))
Text = Replace(Text, "/endhead;", "/endhead")
Loop
If (InStr(Text, ";//")) Then
Dim muell
Text = Replace(Text, ";//", "")
arbeitstext = ""
geteilt = Split(Text, ";")
indexi = "0"
nCount = UBound(geteilt, 1) - LBound(geteilt, 1) + 1
muellzahl = "0"
zusatztext = mode
Do
zwischen = 1
'muell = MsgBox(Text & " >" & geteilt(indexi) & "< " & (Len(geteilt(indexi)) = 0), 0)
If InStr(geteilt(indexi), "/multicolumn{") Then
mnumber = InStr(geteilt(indexi), "/multicolumn{")
testnumber = InStr(geteilt(indexi), "}")
addition = "0"
zwischen = geteilt(indexi)
testnumber = testnumber - 1
zwischen = Left(zwischen, testnumber)
testnumber = InstrRev(zwischen, "{")
testnumber = Len(zwischen) - testnumber
zwischen = Right(zwischen, testnumber)
geteilt(indexi) = Replace(geteilt(indexi), "/multicolumn{", "\multicolumn{")
zusatztext = ""
ElseIf InStr(geteilt(indexi), "/multirow{") Then
geteilt(indexi) = Replace(geteilt(indexi), "/multirow{", " \multirow{")
zusatztext = ""
ElseIf ((Len(geteilt(indexi)) = 0) Or InStr(Text, "/cline{") Or InStr(Text, "\cline{")) Then
zusatztext = ""
Else
zusatztext = mode
End If
testnumber = indexi + 1
If InStr(testnumber, nCount) Then
arbeitstext = arbeitstext & zusatztext & geteilt(indexi) & zusatztext
Else
testnumber = indexi + zwischen
If (InStr(testnumber, nCount) And InStr(geteilt(indexi), "\multicolumn{")) Then
arbeitstext = arbeitstext & zusatztext & geteilt(indexi) & zusatztext
Else
arbeitstext = arbeitstext & zusatztext & geteilt(indexi) & zusatztext & "&"
End If
End If
indexi = indexi + zwischen
Loop Until (InStr(indexi, nCount))
Text = arbeitstext
head = " "
If InStr(Text, "/endhead") Then
Text = Replace(Text, "/endhead", "")
head = " \endhead "
End If
lineend = "\hline"
If InStr(Text, "/cline{") Then
Text = Replace(Text, "/cline{", "\cline{")
End If
If InStr(Text, "\cline{") Then
mnumber = InStr(Text, "\cline{") - 1
arbeitstext = Left(Text, mnumber)
zwischen = Replace(Text, arbeitstext, "")
lineend = zwischen
Text = arbeitstext
End If
Text = Replace(Text, "/.,", ";")
Text = Text & "\\ " & lineend & head
Text = Replace(Text, "&" & mode & "/blank", "&")
Text = Replace(Text, "&" & "/blank", "&")
eFile.WriteLine Text
End If
If InStr(Text, "/begin{") Then
Text = Replace(Text, "/begin{", "")
Text = Replace(Text, ";", "")
ePath = ePfad & Replace(Text, "}", "")
Set eFile = Fso.CreateTextFile(ePath)
End If
If InStr(Text, "/end") Then
eFile.Close
End If
Loop
iFile.Close
Text = MsgBox("Conversion complete!", 0, "csvtolatex " + version)
