I am in the process of migrating a site. The site was running Joomla 1.0.x and there were about 84 pages of content. The site had defined a custom HTML Title for each page and it was saved into a db with the following structure:
INSERT INTO `jos_content` (`title`, `attribs`) VALUES
The `attribs` field contains a whole bunch of parameters int he format like this:
The attribute I'm looking for is: html_title
I have created the regex that will find the value that I want out of each entry:
However, I can't figure out how to parse the data. Currently I have exported those two fields only into a .sql file. So I don't currently have it in a mysql database.
Could someone please help me come up with some code that would create a text file with a list as follows:
title: html_title (with html_title being the only value extracted out of attribs)
I would appreciate any help I can get please.