How do i change the following input line using SED ?
Input - bus_ln in ('abc');
Required O/P - bus_ln in ('def','xyz');
4 Answers
Give this a try:
sed "s/\([^(]*\)('[^']*')/\1('def','xyz')/" inputfile
It will replace whatever is between the parentheses.
Input:
bus_ln in ('abc');
foo('bar');
baz aaa bbb ('ccc ddd') some more text
Output:
bus_ln in ('def','xyz');
foo('def','xyz');
baz aaa bbb ('def','xyz') some more text
answered Feb 23, 2011 at 10:57
Dennis Williamson
364k95 gold badges387 silver badges446 bronze badges
Comments
Using sed substitute command:
echo "bus_ln in ('abc');" | sed "s/bus_ln in ('abc');/bus_ln in ('def','xyz');/"
answered Feb 23, 2011 at 10:48
Maxim Egorushkin
138k19 gold badges201 silver badges293 bronze badges
Comments
$ echo "Input - bus_ln in ('abc');" | ruby -e 'print gets.gsub(/(.*\()(.[^;]*)(\);)/,"\\1\047def\047,\047xyz\047\\3")'
Input - bus_ln in ('def','xyz');
Comments
This might work for you:
echo "bus_ln in ('abc');" | sed "s/'.*'/'def','xyz'/"
bus_ln in ('def','xyz');
This uses "'s to surround the sed commands which may sometimes lead to unexpected results.
Using ''s instead is clumsy (in comparison) but more predictable:
echo "bus_ln in ('abc');" | sed 's/'\''.*'\''/'\''def'\',\''xyz'\''/'
bus_ln in ('def','xyz');
Where '\'' represents a single ' and '\',\'' represents ','
