up vote 1 down vote favorite
share [g+] share [fb]

I've got to read an XML file and put it into a DB. But before that I want to open it and 'clean' it by deleting many chunks of records. The original file is about 20Mb.

How can I open this file to see its contents and remove records.

I tried GEdit AND FireFox but it seems to go into a freeze situation even after 5 minutes.

My OS is Ubuntu 10.10 and I hope to do the final code using PHP.

link|improve this question
50% accept rate
gedit? so you are not asking how to do that programmatically? – Gordon Aug 13 '11 at 11:42
@Gordon, I know how to read it using PHP. But I want to know how the contents can be viewed so that I can remove some records manually. After that, I'll go for the coding. This is why I'm trying to use GEdit - at least that's the only text editor I am comfortable with. – itsols Aug 13 '11 at 11:45
@Gordon he's asking for a good tool for cleaning up the data manually: "But before that I want to open it and 'clean' it by deleting many chunks of records" – Matt Aug 13 '11 at 11:45
@Matt If the question is how to open it with an editor, the question is not suitable for StackOverflow because it is not programming related. It should be moved to Superuser then. – Gordon Aug 13 '11 at 11:47
1  
@Gordon no worries, I already flagged it as such – Matt Aug 13 '11 at 11:48
feedback

migrated from stackoverflow.com Aug 13 '11 at 15:38

This question came from our site for professional and enthusiast programmers.

1 Answer

up vote 3 down vote accepted

Vim will be able to handle 20mb without breaking a sweat. It should be more than enough to do your record deletions. Run vimtutor if you need a good walkthrough on how to use it (lesson 2.1 covers the deletion commands)

link|improve this answer
Thanks Matt. That's amazing! I'm surprised to find my Gedit going into a deadlock but VIM just opened it in a few seconds! Thanks again! – itsols Aug 13 '11 at 11:57
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.