pipe delimeted into xml

[rowantrimmer]

Hello,

I have a very simple file as show below and I need to convert it into an xml document.

the text file is

abc123 | £23,000 | Luton | Semi-detached ^

the end of file delimeter is a ^

I would like the output to be

<properties>
<property>
<property_ref>abc123e</property_ref>
<price>£23,000</price>
<location>Luton</location>
<type>Semi-detached</type>
</property>
<properties>

Could anyone help me please ???????

[tburke]

Does this help you out any? It should get you on the right track.

<?php

$FileContents = "abc123 | £23,000 | Luton | Semi-detached";
$Data = explode(" | ", $FileContents);

echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\" ?>\n";
echo "<properties>\n";
echo "    <property>\n";
echo "        <property_ref>{$Data[0]}</property_ref>\n";
echo "        <price>{$Data[1]}</price>\n";
echo "        <location>{$Data[2]}</location>\n";
echo "        <type>{$Data[3]}</type>\n";
echo "    </property>\n";
echo "</properties>\n";

?>

[rowantrimmer]

Many thanks for that.

How would i read it in if the pipe delimted stuff was in a text file called test.txt and there was an unknown number of lines in the text file ? Also how can I actually write the xml into a file as it goes along ?

Many thanks

Rowan

[shadypalm88]

Originally posted by rowantrimmer
How would i read it in if the pipe delimted stuff was in a text file called test.txt and there was an unknown number of lines in the text file ?

If you're using PHP 4.3.0+:

$FileContents = '';
$FileContents = file_get_contents('test.txt');

Otherwise:

$file_raw = array();
$file_raw = file('test.txt');
$FileContents = implode("\n", $file_raw);
unset($file_raw);

[shadypalm88]

Just use this.

<?php
$file = file('test.txt'); // creates an array from 'test.txt' with each
                          // line as its own element
echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\" ?>\n";
echo "<properties>\n";
foreach ($file as $line) {
	$Data = explode(" | ", $line);
	echo "    <property>\n";
	echo "        <property_ref>{$Data[0]}</property_ref>\n";
	echo "        <price>{$Data[1]}</price>\n";
	echo "        <location>{$Data[2]}</location>\n";
	echo "        <type>{$Data[3]}</type>\n";
	echo "    </property>\n";
}
echo "</properties>\n";
?>