Oracle regex to find the special character in name field
<p>I'm trying to filter out the names which have special characters.</p>

<p><strong>Requirement:</strong></p>

<p>1) Filter the names which have characters <strong>other than</strong> <code>a-zA-Z , space and forward slash(/)</code>.</p>

<p><strong>Regex being tried out:</strong></p>

<pre><code>1) regexp_like (customername,'[^a-zA-Z[:space:]\/]'))
2) regexp_like (customername,'[^a-zA-Z \/]'))
</code></pre>

<p>The above two regex helps in finding the names with special characters like <code>? and dot(.)</code></p>

<p><strong>For example:</strong></p>

<pre><code>LEAL/JO?O

FRANCO/DIVALDO Sr.
</code></pre>

<p>But I couldn't figure out why some names(listed below) <code>with the allowed characters(a-zA-Z , space and forward slash(/)) also get retrieved.</code></p>

<p><strong>For example:</strong></p>

<pre><code>ESTEVES/MARIA INES

PEREZ/JOSE

DUTRA SILVA/LIGIA
</code></pre>

<p>Please help to figure out the mistake in the regex being used.</p>

<p>Many thanks in advance!</p>