Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options

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 the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (7)
As of 2016-08-31 07:03 GMT
Find Nodes?
    Voting Booth?
    The best thing I ever won in a lottery was:

    Results (426 votes). Check out past polls.