Need to add double and single quotes in SED

rfvelasco · 02-20-2017, 03:08 PM

Input

db2 RUNSTATS ON TABLE ITMUSER.AMC_Internet_Service_Element_Y WITH DISTRIBUTION AND DETAILED INDEXES ALL SHRLEVEL CHANGE;

Desired output

db2 'RUNSTATS ON TABLE "ITMUSER"."AMC_Internet_Service_Element_Y" WITH DISTRIBUTION AND DETAILED INDEXES ALL SHRLEVEL CHANGE';

Requirements:

Add a single quote before RUNSTATS, add double quotes around ITMUSER and AMC_Internet_Service_Element_Y and a final single quote after CHANGE

suicidaleggroll · 02-20-2017, 03:11 PM

Sounds like a homework question. What have you done and where are you stuck?

rfvelasco · 02-20-2017, 03:41 PM

I'm stuck getting the single and double quotes around the correct literals. I just thought I would post to see if a SED guru would know the answer quicker than me.

rknichols · 02-20-2017, 03:54 PM

The quote characters aren't special to sed. You just need to get them past the shell. You can set the "-x" option in your shell ("set -x") and see how the arguments are getting passed to sed. (Use "set +x" to turn that back off.)

NevemTeve · 02-20-2017, 10:06 PM

Shell variables might make it cleaer:

Code:

From="from"; To="'to'"; sed "s;$From;$To;"
From="from"; To="\"to\""; sed "s;$From;$To;"