title: How can I, using PL/SQL, remove punctuation embedded in numbers?
body: <p>I am writing a function to clean up addresses in PL/SQL and want to remove "/-." from the middle of numbers. I suspect that should be easy with a regexp_replace. Unfortunately I still haven't wrapped my head around regular expressions well enough.</p>
  
  <p>So my input might look like "123-4 Cherry Lane" and I would like it to look like "123 4 Cherry Lane" But I would like "123 Blake-Habersham" to look like "123 Blake-Habersham", no difference.</p>
  
  <p>Since I would like to learn from this not just copy and paste code, I would like to understand the answer as well.</p>
  
  <p>In pseudo code I want to replace all '[any characters][1-9] for any length followed by a separator and [0-9] followed by [any characters]' with '[any characters][1-9] for any length followed [any characters]'</p>