How to split line depending on pattern

[kat000003]

I have a file with a line > 2048.
I want to insert a newline on every occurance of a given pattern.
EG
For every occurance of AND , WHERE , FROM in my file
Do "insert newline"
write to new file

 

[PHV]

A starting point:
nawk '{gsub(/ AND | WHERE | FROM /,"\n&");print}' /path/to/input > output

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886