Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re: input & output for TB conv

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


in reply to input & output for TB conv

satheeshbssb:

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.

...roboticus

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


Comment on Re: input & output for TB conv
Select or Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1005274]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (9)
As of 2014-09-23 03:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (210 votes), past polls