Convert Tab delimited text file to XML

Question

I'm wondering if there is an accepted method to convert a tab delimited text file to XML, so that it can be imported in Adobe Flex. I would prefer to use PHP to achieve this.

Thanks

Edit:

The tab delimited text file I am looking to convert is in the format

Refnumber  Location    Name     Age    
123        North America    Steve    32

And I am looking to convert to

<data>
<refnumber> 123 </refnumber> 
<location> North America </location>
<name> Steve </name>
<age> 32 </age>
</data>

Can you post the contents of the TAB-DELIMITED-TEXT-FILE for reference. — Sujit Agarwal, May 26 '11 at 16:08

Gordon · Accepted Answer · 2011-05-26T17:15:15.920

You can iterate the file line by line and write the contents with XMLWriter

XmlWriter Example (demo)

$xmlWriter = new XMLWriter();
$xmlWriter->openUri('/path/to/destination.xml');
$xmlWriter->setIndent(true);
$xmlWriter->startDocument('1.0', 'UTF-8');
$xmlWriter->startElement('root');

$tsvFile = new SplFileObject('filename.tsv');
$tsvFile->setFlags(SplFileObject::READ_CSV);
$tsvFile->setCsvControl("\t");
foreach ($tsvFile as $line => $row) {
    if($line > 0) {
        $xmlWriter->startElement('data');
        $xmlWriter->writeElement('refnumber', $row[0]);
        $xmlWriter->writeElement('location', $row[1]);
        $xmlWriter->writeElement('name', $row[2]);
        $xmlWriter->writeElement('age', $row[3]);
        $xmlWriter->endElement();
    }
}
$xmlWriter->endElement();
$xmlWriter->endDocument();

Using the XmlWriter has the added benefit that it will tell you when you are trying to write illegal content for the XML elements. If you know there is only valid data in your tsv file, you can also just use a template and write that to another file.

Template Example (demo)

$tsvFile = new SplFileObject('filename.tsv');
$tsvFile->setFlags(SplFileObject::READ_CSV);
$tsvFile->setCsvControl("\t");

$template = <<< TPL
<data>
    <refnumber>%d</refnumber> 
    <location>%s</location>
    <name>%s</name>
    <age>%d</age>
</data>
TPL;

$destFile = new SplFileObject('destination.xml', 'w+');
$destFile->fwrite('<?xml version="1.0" encoding="UTF-8"?>');
$destFile->fwrite("\n<root>\n");
foreach ($tsvFile as $line => $row) {
    if($line > 0) {
        $destFile->fwrite(vsprintf($template, $row));
    }
}
$destFile->fwrite('</root>');

Links

score 2 · Answer 2 · answered May 26 '11 at 16:19

I'm assuming you already read the Tab-delimited file. You can generate a XML output with something like this:

// get lines here

$xml = '<xml>';

foreach ($lines as $line) {

  // get values from line here
  $xml .= '<data>';

  $xml .= sprintf('<%s>%s</%s>', 'refnumber', $values[0], 'refnumber');
  $xml .= sprintf('<%s>%s</%s>', 'location', $values[1], 'location');
  $xml .= sprintf('<%s>%s</%s>', 'name', $values[2], 'name');
  $xml .= sprintf('<%s>%s</%s>', 'age', $values[3], 'age');

  $xml .= '</data>';
}

$xml .= '</xml>';

score 1 · Answer 3 · answered May 26 '11 at 16:15

If you want to use PHP to do this, you'll need to read your file line by line (i guess a set of data ends with a line-break) and then split the lines using the Tab as delimiter (regular extension is \r).

After that, to create your XML-Output, you'll want to use the XMLWriter-class, which can print the result to the screen (like you opened a normal XML-file), save it on the File-System or write it to a Database (using something like MySQLi).

Convert Tab delimited text file to XML

3 Answers3

XmlWriter Example (demo)

Template Example (demo)

Links

Linked