txt to Xml Conversion

[mustang]

Does anyone know the easiest way to convert a text or csv file to Xml? Is there an online tool?

[Coding Monkey]

Quick Google search

http://www.dpawson.co.uk/java/uphill/

[mustang]

Its just a holding page. The Java source code doesn't help me.

Thanks anyway :)

[mattk]

Have you tried the Save As... XML Data option in Excel?

[mustang]

Have you tried the Save As... XML Data option in Excel?

I don't have that option. :?

[mattk]

Are you using Microsoft Excel 2003?

[mustang]

Are you using Microsoft Excel 2003?

Office 2000 SP3 unfortunately

[Richard Conyard]

Can you use VBS?

If so the following should help you out:


Dim strInfil, strOutfil
strInfil = "c:\myfile.txt"
strOutfil = "c:\myfile.xml"

Dim wrapper, field1, field2

wrapper = "container"
field1 = "csvcolumnone"
field2 = "csvcolumntwo"

set objFSO = createObject("Scripting.FileSystemObject")
set objINFIL = objFSO.openTextfile(strInfil, 1, 0 )
set objOUTFIL = objFSO.openTextfile(strOutfil, 2, 0)

while not objINFIL.atEndOfStream
arrFields = split( objINFIL.readline(), "," )
strOutLine = "<" & wrapper & "><" & field1 & ">" & arrFields(0) & _
"</" & field1 & "><" & field2 & ">" & arrFields(1) & "</" & field2 & _
"></" & wrapper & ">"
outOUTFIL.writeline strOutLine
wend

objOUTFIL.close
objINFIL.close



Obviously it's not great, but should give you a start