Finding & replacing strings in large files

[tdfreeman]

I need to find and replace strings in some large files. How can I do so without going into an editor? The vi editor says that the file is too large.

This file contains SQL statements to run against a database. I need to replace the page headings with a commit line so that the records commit after so many records.

Thank you in advance for your help.

 

[dobbyn]

sed is a good tool for this...

sed 's/OldString/NewString/g' OldFile > NewFile

 

[bigscouse]

Vi normaly creates a temporary file for editting in /var/tmp. Check if /var needs clearing down.
Ged Jones

Top man

 

[Apricot]

The vi tool was not designed to support larger files.

A suggested work around is to use a GNU product called 'vim'
(VI Improved). Solaris 8.1 includes this product, but one can download it directly from this web site:

http://www.vim.org/

VIM supports large file editing within a vi like environment.

regards ph