jQuery in Action, 3rd edition
The moose likes XML and Related Technologies and the fly likes text files to XML Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "text files to XML" Watch "text files to XML" New topic

text files to XML

Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
Are there any utilities that are written that will convert from say a merge file to XML? We would like to get the benefits of XML to transfer data between applications, but our main application cannot output data in XML format, but can output in comma delimeted format.
I realize the tags would not be nested, as merge file headers say nothing of the fact like a <firstName> being nested inside of an <name>, but even if it was <firstName/><lastName/> with no name tag, at least it would be in XML format so that we could parse it.
Our deal is that we have multiple companies that all output their data in a different format, so imagine 5 different comma delimeted file. We would like to take that information, put it in a usable format so that it can be parsed and uploaded into a database. Since they all would contain pretty much the same information, just in different orders, and some may have different fields, I was figuring we could somehow convert it to XML and then parse the document looking for the different nodes that we need.
Any suggestions?
I agree. Here's the link: http://aspose.com/file-tools
subject: text files to XML
It's not a secret anymore!