txt to Xml Conversion

mustang · Jan 11, 2006

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

Coding Monkey · Jan 11, 2006

Quick Google search

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

mustang · Jan 11, 2006

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

Thanks anyway

mattk · Jan 11, 2006

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

mustang · Jan 11, 2006

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

I don't have that option. :?

mattk · Jan 11, 2006

Are you using Microsoft Excel 2003?

mustang · Jan 11, 2006

mattk said:
Are you using Microsoft Excel 2003?

Office 2000 SP3 unfortunately

Richard Conyard · Jan 11, 2006

Can you use VBS?

If so the following should help you out:

Code:

Dim strInfil, strOutfil
strInfil = "c&#58;\myfile.txt"
strOutfil = "c&#58;\myfile.xml"

Dim wrapper, field1, field2

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

set objFSO = createObject&#40;"Scripting.FileSystemObject"&#41;
set objINFIL = objFSO.openTextfile&#40;strInfil, 1, 0 &#41;
set objOUTFIL = objFSO.openTextfile&#40;strOutfil, 2, 0&#41;

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

objOUTFIL.close
objINFIL.close

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

Search

Search

txt to Xml Conversion

mustang

Coding Monkey

mustang

mattk

mustang

mattk

mustang

Richard Conyard

Similar threads

Latest Articles