Re^2: XML cleanup - regex or ?

I have to clean the file line by line. Many of the downloads are 2+Gb long and I get memory errors if I do too much in RAM.

I've been considering a 'cascade' of regex to toss out the noise. Something like testing for the cat, dog, etc, then looking for the param list. Lots of nested ifs. It seems messy but it might be the only avenue. I was hoping there was a slick regex process to do this instead.

Comment on Re^2: XML cleanup - regex or ?

Replies are listed 'Best First'.
Re^3: XML cleanup - regex or ? by dasgar (Priest) on Sep 21, 2010 at 16:10 UTC
Many of the downloads are 2+Gb long and I get memory errors if I do too much in RAM. Well, that's a constraint that you didn't share initially. Had I been aware of that I would not have proposed slurping the file(s) into memory. Now that I have a better understanding of the constraints, I would probably do something like the untested code below. For each file that needs 'cleaning', run the script below with the `perl -i.bak`, which opens the file for in place editing and backs it up to a file with the .bak file extension before opening the file for editing. (Without the .bak, Perl just overwrites the file with no backup.) Basically, the code below will check a file line by line for each tag/attribute pairs specified. If an attribute is missing for a tag, that line is 'deleted' from the file. This might not be exactly what you want to do, but it should give you a framework to use for your own 'noise' handling operations. Read more... (967 Bytes)	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^3: XML cleanup - regex or ?
by dasgar (Priest) on Sep 21, 2010 at 16:10 UTC

Many of the downloads are 2+Gb long and I get memory errors if I do too much in RAM.

Well, that's a constraint that you didn't share initially. Had I been aware of that I would not have proposed slurping the file(s) into memory.

Now that I have a better understanding of the constraints, I would probably do something like the untested code below. For each file that needs 'cleaning', run the script below with the perl -i.bak, which opens the file for in place editing and backs it up to a file with the .bak file extension before opening the file for editing. (Without the .bak, Perl just overwrites the file with no backup.)

Basically, the code below will check a file line by line for each tag/attribute pairs specified. If an attribute is missing for a tag, that line is 'deleted' from the file. This might not be exactly what you want to do, but it should give you a framework to use for your own 'noise' handling operations.