UNIX for Dummies Questions & Answers

How the below ex.txt file can be parsed using starting bracket'(' and ending bracket')' and hav to store the values without quotes in a text file.

There will be some 10 or 20 lines inbetween starting brakcet and ending bracket at first there may be 5 words,2ndl ine only 1 word, third line 6 words and 4th line 2 words. so words ineach line will differ...so by keeping brackets as start'(' and end ')' i want to store all the words in some 2 or 3 lines with comma separated

ex.txt
-----------------------------------
('name','time'...
'value1',vlaue2',value3'...
'value10','value11',value12')
-----------------------------------

can any one say the command to achive the above using awk? or any

Be more precise. Also post the desire output. If it is just for getting rid of the single quotes, take this as a start

Code:

tr -d "'" < ex.txt

this sed command also remove the single quote

Code:

sed s/\'//g input_file

awk 'BEGIN {started=0} { if (substr($0,1,1)=="(") {
started=1; print substr($0,2); next;
}
else if (started==0){
next
} if (substr($0,length($0),1)==")") { started=0; print substr($0,1,length($0)-1); next; } print $0
}' input_file | tr "'" "\0"