Shell Programming and Scripting

Sample Input - 
COLUMN_NAME Like '%value%' Or COLUMN_NAME Like '%value%' Or COLUMN_NAME Like '%value value%' Or COLUMN_NAME Like '%value%' OR COLUMN_NAME Like '% value%' OR COLUMN_NAME Like '%value %' OR COLUMN_NAME Like 'value' Or COLUMN_NAME Like '%value%' Or COLUMN_NAME LIKE ' value' Or COLUMN_NAME LIKE 'value '

Sample Output - 
COLUMN_NAME '%value%'
COLUMN_NAME '%value%'
COLUMN_NAME '%value value%'
COLUMN_NAME '%value%'
COLUMN_NAME '% value%'
COLUMN_NAME '%value %'
COLUMN_NAME 'value'
COLUMN_NAME '%value%'
COLUMN_NAME ' value'
COLUMN_NAME 'value '

$ perl -lne 'while(/(COLUMN_NAME) Like ('\''.*?'\'')/gi){print "$1 $2"}'  file
COLUMN_NAME '%value%'
COLUMN_NAME '%value%'
COLUMN_NAME '%value value%'
COLUMN_NAME '%value%'
COLUMN_NAME '% value%'
COLUMN_NAME '%value %'
COLUMN_NAME 'value'
COLUMN_NAME '%value%'
COLUMN_NAME ' value'
COLUMN_NAME 'value '

awk     '       {for (i=1; i<NF-1; i++) 
                   if ($i == "COLUMN_NAME")     {printf "%s%s%s", $i, FS, $(i+=2)
                                                 if ($i!=/^\x27.*\x27$/) printf "%s%s", FS, $(i+1)
                                                 printf "\n"}
                }
        ' file

$ awk 'gsub(/^[[:space:]]|[Ll][Ii][Kk][eE]/,x)' RS="Or|OR" file
COLUMN_NAME  '%value%' 
COLUMN_NAME  '%value%' 
COLUMN_NAME  '%value value%' 
COLUMN_NAME  '%value%' 
COLUMN_NAME  '% value%' 
COLUMN_NAME  '%value %' 
COLUMN_NAME  'value' 
COLUMN_NAME  '%value%' 
COLUMN_NAME  ' value' 
COLUMN_NAME  'value '

sed 's#\(COLUMN_NAME\)\([ ][^ ]*[ ]\)#\1 #g;s#\([ ][^ ]*[ ]\)\(COLUMN_NAME\)#\n\2#g' file

awk 'gsub(/O[rR] /,"\n")1' file_name

Sample Input -
COLUMN_NAME Like '%value%'
COLUMN_NAME Like '%value%'
COLUMN_NAME Like '%value value%'
COLUMN_NAME Like '%value%'
COLUMN_NAME Like '% value%'
COLUMN_NAME Like '%value %'
COLUMN_NAME Like 'value'
COLUMN_NAME Like '%value%'
COLUMN_NAME LIKE ' value'
COLUMN_NAME LIKE 'value '