![](https://seccdn.libravatar.org/avatar/9c8350aace52e672b0850050b7f97fb7.jpg?s=120&d=mm&r=g)
For a once off, I am sure that vim would be able to open the file. I haven't come across a file that is to big for vim to edit. Your command in vim (in command mode) would be : :%s/NaN/./g sed would work if you need a script to do this often. It might take some time to learn though. Your sed script should look something like this: s/NaN/./ and that's it. Refer to manual page for running it, I kind quite remember that part, because I haven't used it in ages. I use Perl for this kind of stuff all the time. I you are really going to do a lot of this stuff, and other programming, it might be well worth the effort to learn Perl. Hope that helps. Marius
James Philp
21/08/2003 06:03:05 >>> Hi,
Does anyone know of a (command line) program in SuSE that allows you to replace all occurences of a certain string in a text (CSV) file with another? I have a (huge) file which contains Matlab style 'NaN' for missing data and I need to make it Gauss readable by replacing all the 'NaN' with the symbol '.'. It's too big to be loaded into an editor or excel etc. thanks, j. __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com
participants (1)
-
Marius Roets