Shell Programming and Scripting

Hi Jim

Thanks for the code its working in my script

You can use this sed too

Code:

sed -E '
:A
N
$!bA
s/(.*)(union all)(.*)/\1;\3/
' infile

A simpler method is

Code:

sed  '3 s/ union all/;/' <filename>

where 3 is the line number. This is useful if you know which line to target at, while the grep command will search for all the lines containing the matched pattern(s).

Hope that this is useful.

Cheers.


EDIT:
Just realised that I did not really solve the problem of find and replace "the last occurrence of a match". But hope that my approach can cast a different light on the approaches used to solve your problem.