Please help, am trying to remove all special characters from a string but REGEXP_REPLACE does not give me the result am expecting. I will be grateful for your help.
Many thanks
These are the strings that am trying to remove special characters from
SELECT REGEXP_REPLACE('FHU "WALMO" WALDEMAR WOŹNIAK', '[^0-9A-Za-z]', '') FROM dual;
SELECT REGEXP_REPLACE('NUR FÜR KUNDENDIENST!', '[^0-9A-Za-z]', '') FROM dual;
SELECT REGEXP_REPLACE('"DAR-GAZ" GAJOS DARIUSZ', '[^0-9A-Za-z]', '') FROM dual;
These are my results
FHUWALMOWALDEMARWOZNIAK
NURFRKUNDENDIENST
DARGAZGAJOSDARIUSZ
These are the results that am expecting (i.e. keeping the space between the names)
FHU WALMO WALDEMAR WOZNIAK
NUR FR KUNDENDIENST
DARGAZ GAJOS DARIUSZ