insert line in file every 1000th line via sed or in vi
 

Hi all,
you helped me out once and I hope you can do it once again.;)
My problem:
I have a more or less big file with many update statements (about 590000)for execution in an Oracle database. Now I need to insert a "commit" line after every 1000th line.
Do you have any idea to do this with 'sed' or directly in 'vi'?

Thanks in advance for your help.

Best regards
Elke

Some versions of sed can do it.

Check your manual page to see if the 'step' option is there:

first~step

Match every step'th line starting with line first. For example,
``sed -n 1~2p'' will print all the odd-numbered lines in the
input stream, and the address 2~5 will match every fifth line,
starting with the second. first can be zero; in this case, sed
operates as if it were equal to step. (This is an extension.)

Otherwise, if you need something portable, you could try awk

Edit: the 'a' command is shorter than the 's' command

@Turbocapitalist:
thanks a lot. The second advice (awk) did it. sed replaced each fifth line with "commit" instead of inserted it.

Best Regards
Elke

Strange. sed should do the job. Which regex did you write? Or did you work with the 'a' command instead?

I used
sed -e '0~5 commit;' test.sql > test1.sql

and in test1.sql where the same amount of lines as in test.sql but each fifth row was replaced by commit. :scratch:

Ah. You missed the actual sed command: 'a'
See 'man sed' for the details. You've also figured out how to increase the steps to 1000 or more, I presume?

Without the a (append) it becomes a c (change) followed by the string "ommit".