in reply to input & output for TB conv


I was able to turn your HTML table into a valid[1] XML table simply by prefixing it with:

<?xml version="1.0"?>

On a more serious note: You don't really provide a lot of information about what you're doing, so my joke answer above is an accurate-enough answer to your question.

However, what I think you want is to break your table up into more than a single cell. For that, you're going to need to figure out how to (a) break your text up into records, and (b) split the records into fields.

If we ignore your header, it looks like your table data is a single line per record, so you can use a typical loop to read it record by record:

while (my $record = <$FH>) { ... process each record ... }

And your first two fields appear to be single words. So you could use a regular expression or some other method to split your records up into the individual fields.

Finally, to turn your data into XML, you would be well served to go to CPAN and look for some module to write XML, to make sure you don't make "fake" XML files (of which the world sees too many).

[1] as verified by the w3 org xml validator.


When your only tool is a hammer, all problems look like your thumb.