grep command in Solaris x86 to Capture Special character

Question

I want to capture perticular string i.e. "UPDATE kplustp..Service SET Service_Name = "PositionService", ServiceType = 'Z', HostName = "abcd" " in log file with perticular path /home/abc/xyz.log

I am using below command to do

grep -i "UPDATE kplustp..Service SET Service_Name = "PositionService", ServiceType = 'Z'" /home/adc/xyz.log 

But it is not working, may be because of special characters in string.

How to do?

Answer 1

Don't have my solaris box at hand, but try this:

grep -i 'UPDATE kplustp..Service SET Service_Name = "PositionService", ServiceType = \'Z\'' /home/adc/xyz.log