How to convert a text file into an xml?

Hi all,

Please guide for convertion of .txt to .xml

Is it plain text or does it have some internal formatting?

What should the format of the XML be, and what is its purpose? This is important because there's an unlimited number of ways to convert an arbitrary text file into an XML file.

Lester Burnham wrote:Is it plain text or does it have some internal formatting?

What should the format of the XML be, and what is its purpose? This is important because there's an unlimited number of ways to convert an arbitrary text file into an XML file.

The formate of my .txt is:

invoice_number product_number product_description
12321212 45612 abcdasksalaknsdlandaks
67812121 78921 xyzasdjcakbjasbckasccbc

OK. Various classes in the java.io package and the use of some methods in the String class should be sufficient to handle that.

Lester Burnham wrote:OK. Various classes in the java.io package and the use of some methods in the String class should be sufficient to handle that.

I am having the text file in the following formate.

Java|http://www.rgagnon/javahowto.htm
PowerBuilder|http://www.rgagnon/pbhowto.htm
Javascript|http://www.rgagnon/jshowto.htm
VBScript|http://www.rgagnon/vbshowto.htm

And the code for the above file is

import java.io.*;

// SAX classes.
import org.xml.sax.*;
import org.xml.sax.helpers.*;

import javax.xml.parsers.*;
import javax.xml.transform.*;
import javax.xml.transform.stream.*;
import javax.xml.transform.sax.*;

public class ToXML {

BufferedReader in;
	  StreamResult out;

TransformerHandler th;
	  AttributesImpl atts;

public static void main(String[] args)
	{
		// TODO Auto-generated method stub
		new ToXML().doit();
	}
	public void doit ()
	{
	    try{
		      in = new BufferedReader(new FileReader("data.txt"));
		      out = new StreamResult("data.xml");
		      initXML();
		      String str;
		      while ((str = in.readLine()) != null) {
		         process(str);
		      }
		      in.close();
		      closeXML();
	       }
	       catch (Exception e) { e.printStackTrace(); }
	  }
	public void initXML() throws ParserConfigurationException,TransformerConfigurationException, SAXException 
	{
		  // JAXP + SAX
		  SAXTransformerFactory tf = (SAXTransformerFactory) SAXTransformerFactory.newInstance();
		
		  th = tf.newTransformerHandler();
		  Transformer serializer = th.getTransformer();
		  serializer.setOutputProperty(OutputKeys.ENCODING,"ISO-8859-1");
		  // pretty XML output
		  serializer.setOutputProperty("{http://xml.apache.org/xslt}indent-amount", "4");
		  serializer.setOutputProperty(OutputKeys.INDENT,"yes");
		  th.setResult(out);
		  th.startDocument();
		  atts = new AttributesImpl();
		  th.startElement("","","HOWTOS",atts);
    }
	public void process (String s) throws SAXException 
	{
	    String [] elements = s.split("\\|");
	    atts.clear();
	    th.startElement("","","TOPIC",atts);

th.startElement("","","TITLE",atts);
	    th.characters(elements[0].toCharArray(),0,elements[0].length());
	    th.endElement("","","TITLE");

th.startElement("","","URL",atts);
	    th.characters(elements[1].toCharArray(),0,elements[1].length());
	    th.endElement("","","URL");

th.endElement("","","TOPIC");
	}

public void closeXML() throws SAXException
	{
	    th.endElement("","","HOWTOS");
	    th.endDocument();  
	}
}

This works perfect for the above given .txt file

But the on which i wish to work is in the following formate:
I have attached the file,becuase the view of the .txt is imperfect.
So please find the attached copy and go through it
So i to change the code for the above formate
Help me please to resolve it

[ UD: In the future, please UseCodeTags when posting code of an length. It's unnecessarily hard to read the code ptherwise, making it less likely that people will bother to do so. ]

You need to look at JAXB or Castor for this.

I have attached the file,becuase the view of the .txt is imperfect.

I don't see that; try posting it.

You need to look at JAXB or Castor for this.

No. There are any number of ways of creating XML, including the one shown in samir's code. What's more, tools like JAXB and Castor suppose the existence of Java classes that are mapped to XML elements - yet samir's posts don't sound like those classes exist.

Lester Burnham wrote:

I have attached the file,becuase the view of the .txt is imperfect.

I don't see that; try posting it.

You need to look at JAXB or Castor for this.

No. There are any number of ways of creating XML, including the one shown in samir's code. What's more, tools like JAXB and Castor suppose the existence of Java classes that are mapped to XML elements - yet samir's posts don't sound like those classes exist.

I want guidence or code for the following text formate

invoice_number product_number product_description
B4763020 64012 GAMIMUNE N 5% 10ML
12345555 32323 abcdswbfjwbcbwjcb
12345123 12323 abaswbfjwbcbwjcb
54545555 32223 zxcdswbfjwbcbwjcb
14545555 44323 abcdswbfjwbcbwjcb

please notuce one thing that there is a tab space("/t") between each column

This:

doesn't look substantially different from this:

Different delimiter character, and different number of items per line, but that's about it. What problems are you encountering while adapting your earlier code?

Lester Burnham wrote:This:
invoice_number product_number product_description B4763020 64012 GAMIMUNE N 5% 10ML 12345555 32323 abcdswbfjwbcbwjcb 12345123 12323 abaswbfjwbcbwjcb 54545555 32223 zxcdswbfjwbcbwjcb 14545555 44323 abcdswbfjwbcbwjcb
I want out put of xml in the following formate
- <TOPIC> <invoice_number>B4763020</invoice_number> <product_number>64012</product_number> <product_description>GAMIMUNE N 5% 10ML</product_description> </TOPIC>
Different delimiter character, and different number of items per line, but that's about it. What problems are you encountering while adapting your earlier code?

What do you have so far? What does it do, and where are you stuck making it do what you want it to do?