Cart
[Home] [By Thread] [By Date] [Recent Entries]
>I have a situation to create an XML output based on a >DTD and pipe delimited data file, meaning the inputs >are a DTD which is variable and a pipe delimited file >with data for the tags in the DTD, the output should >be an XML file. > >I have not heard of any pre-build general program >(kinda parser) to do this function. I wanted to double >check with ya all. > >Any input would be highly useful. The following is a quick & dirty approach, which works as long as the source file is table-like: http://www.isacat.net/2001/code/CSVtoXML.htm Rather than taking a DTD as the definition (not a bad idea...) it takes a simple text file giving the field names etc. Example below. Cheers, Danny. source data: John Smith, The Nook, john@h..., Tim Bot, High Street, tim@b..., Fred Gregory, Tidza, fred@l... properties file: dtd=addresses.dtd comment=Generated using CSVToXML delimiter=, rootname=addressbook recordname=address fields=3 field0=name field1=address field2=email usage: java CSVToXML [properties file] [source file] [destination file] output: <?xml version="1.0"?> <DOCTYPE addressbook SYSTEM addresses.dtd> <!-- Generated using CSVToXML --> <addressbook> <address> <name>John Smith</name> <address>The Nook</address> <email>john@h...</email> </address> <address> <name>Tim Bot</name> <address>High Street</address> <email>tim@b...</email> </address> <address> <name>Fred Gregory</name> <address>Tidza</address> <email>fred@l...</email> </address> </addressbook>
|
