title: REGEXP_REPLACE - remove new line \n from string ONLY if is enclosed in ()'s
body: <p>I'm trying to use REGEXP_REPLACE to replace all new line (\n) from a string with one exception - they MUST be enclosed in parentheses to be replaced.</p>
  
  <p>Example:</p>
  
  <p>Before String: </p>
  
  <pre><code>'a\n, b\n, c (a\n, b, c\n), d\n, e'
  var1 := 'a
  , b
  , c (a
  , b, c
  ), d
  , e'
  </code></pre>
  
  <p>After string: </p>
  
  <pre><code>'a\n, b\n, c, (a b c), d\n, e'
  var2 := 'a
  , b
  , c (a, b, c), d
  , e'
  </code></pre>
  
  <p>I know there must be a clean regular expression pattern that can do this - but I can't get my head around it. </p>
  
  <p>thanks very much...</p>