Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

Re: input & output for TB conv

by roboticus (Chancellor)
on Nov 23, 2012 at 14:52 UTC ( #1005274=note: print w/replies, xml ) Need Help??

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.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1005274]
[atcroft]: .oO(Then again, you also have to be careful if you had it to the database, and be aware of any assumptions it makes (such as SQLite assuming Gregorian calendar and a day of exactly 86400 seconds)...)

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (4)
As of 2017-04-29 04:56 GMT
Find Nodes?
    Voting Booth?
    I'm a fool:

    Results (531 votes). Check out past polls.