sed to remove pattern ','

[adrian kok]

hi all

I have problem to replace the pattern ',' to |

can you give me hint?

tks

data:          'peter','30 Woodroad, CA','USA'
                 'coral','110 Foreest','UK'
                 
to
 'peter|30 Woodroad, CA|USA'
 'coral|110 Foreest|UK'
          
and I used the following but failed

sed -e 's/\','/\|/g

because output only replace all the pattern , to | 
not "," to |         

_______________________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com.hk address at http://mail.english.yahoo.com.hk