Shell Programming and Scripting

Hi!

I'm having trouble usind sed to remove the char ' from within a database's varchar register's sql.
For example, on the following sql:

Code:

INSERT INTO patrimonio_municipal.patrimonio_municipal_airc_tmp 
Values('|Estação Elevatória|',|16723|,'|Grandes Reparações|',
     '|2010-03-26 00:00|',|13|,'|99|','|Outras infra-estruturas|',
    '|Imóveis urbanos, com finalidade operativa|','||','|Etar's e Estações Elevatórias|',
    '|Outras Infra-Estruturas|');

i want to remove the char ' (single quote) from within '|Etar's e Estações Elevatórias|'.
One sed regex to resolve this is:

Code:

 sed -e "s/'|\(.*\)'s\(.*\)|'/'|\1\2|'/g"

But it only functions if the character next to ' is s.
The idea is to remove the char ' (it would be even better to remove its multiple occurrences) from within the sequences '| and |'

Every help is very appreciated.

Thanks a lot in advance,
David Pinheiro

Try this then:

Code:

sed -e "s/\([^|]\)'\([^|]\)/\1\2/g"

Code:

 $ ruby -pne 'gsub(/([^|])\047([^|])/,"\\1\\2")' file

Thanks a lot for your help.
It worked fine.