138350 XML RSS from flat database php

I have an old news CGI script that writes its content to a flat file text database. I'd like to be able to convert data from the file to an XML file as an RSS 2.0 feed. Content in the database file looks similar to this... date|:|author|:|email|:|time|:|title|:|byline|:|random 10 digit identifier|:|content To convert to rss thinking the time and date may need to be combined to create pubDate title would become title content would become description and title with hyphens and .html would become link Currently, my rss feed is a static .xml file that I update manually. I want new the file to be able to be updated either by script (cron) or similar. OK to be .php since I can 301 to the nex format. Any scripts out there capable of doing this? Would like to use existing script if available. This project may require some changes to the cgi script creating the content in the database in order for data to match up for RSS. Particularly I am thinking about the time and date format being converted to a standard pubdate format. I am attaching the cgi script and data file. Motivated to have someone get this done this weekend!