big regular expression search/replace

lookitsjonno · 30 Mar 2006 at 22:55

Hi there,

I have a text file containing about 4 million + rows.

I want to manipulate the data using a regular expression - i've tried editplus and notepad++ and both seem to crash with the shear number of replacements.

Can anyone recommend a utility that can cope with this amount of data?

Thanks.

M0KUJ1N · 30 Mar 2006 at 23:01

vbs script or activeperl (or even python) would be the way to go imo for running a regexp on a file of that size. It is a heck of a size for a flat file though, is it output from a simulation?

lookitsjonno · 30 Mar 2006 at 23:13

exactly! a 190mb text file is never a good thing!

i'm trying to clean up and export the contents into a proper database... however i can't due to not being able to chop and change the data without splitting it into 101 smaller chunks and it taking all day

Andreas_UKF · 9 Dec 2009 at 10:04

You can try Easy File Editor
I used Easy File Editor with log file(220Mb -1,2 million rows).
Find/Replace Examples
Also more info about Regular expression syntax