I have a script,

UPPER(REPLACE(REPLACE(REPLACE(REGEXP_REPLACE(TRIM(mbr.mbr_first_name) || ' ' || TRIM(mbr.mbr_last_name), '[-+"=;:,<>?\/.~`!@#$%^&*()_\-|{}[]]*',''), CHR(9), ' '), CHR(10), ' '), CHR(13), ' '))

where it basically removes special characters (as much as possible) and remains only the alphabet and numeric.

But after generation, I still get this (�) black diamond with white question mark.

Is there a way to include this in the regexp_replace or to identify the CHR() value for me to remove this kind of characters

  • select dump(mbr.mbr_first_name), dump(mbr.mbr_last_name) from yourtable to get the raw values. Sounds like you're having character set issues though – Philᵀᴹ Feb 20 '17 at 9:51
regexp_replace(TRIM(mbr.mbr_first_name) || ' ' || TRIM(mbr.mbr_last_name),'[^a-zA-Z0-9 ]')
| improve this answer | |
  • thanks ! I need to review more regarding regular expressions. – Edgar Allan Bayron Feb 20 '17 at 10:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.