Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine

Re^5: Converting a Text file to XML

by graff (Chancellor)
on Nov 18, 2011 at 03:07 UTC ( #938732=note: print w/replies, xml ) Need Help??

in reply to Re^4: Converting a Text file to XML
in thread Converting a Text file to XML

If you're going to manually insert field delimiters, then you could just switch to using split:
my ( $title, $date, $this, $that ) = split /\|/;
But it's likely that the data will mostly fall into a few dominant format groups, with some long tail of "outliers". You could either apply a list of regex matches (if the first one doesn't work, try the next one, and so on), or you could try some simple diagnostics to divide the data into subsets according to the absense/presence/type of difficulty: if there's more than one 4-digit string, that's one problem; if there are no double quotes (or an odd number of quotes), that's another problem, ... This will reduce the number of cases that need to be fixed by hand in order to be parsable.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://938732]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (7)
As of 2018-05-23 13:43 GMT
Find Nodes?
    Voting Booth?