strngr12

Creating XML from Tab Delimited Document

Discussion created by strngr12 on May 30, 2012
Latest reply on May 30, 2012 by strngr12

Hello!

 

I am trying to turn a document with this format:

 

ReelID:115
AltReelID:B115_C003_0522Q5
CamReelID:B115
Camera:B
Camera Model:EPIC-X
Camera Model ID:5

 

Into something that looks like this:

 

<attribute="ReelID>115</attribute>

<attribute="AltReelID">B115_C003_0522Q5</attribute>

<attribute="CamReelID">B115</attribute>

<attribute="Camera">B</attribute>

<attribute="Camera_Model">EPIC-X</attribute>

<attribute="Camera_Model_ID">5</attribute>

 

There are two things going on here. One is that I need the formatting. The other is that the attribute key names can't have spaces in them. Can anyone help? It would be much appreciated!

 

Thanks!

 

Dan

Outcomes