Finding and removing Non-ASCII characters from an Oracle Varchar2

by

I think this will do the trick: 

SELECT REGEXP_REPLACE(COLUMN, '[^[:print:]]', '')

More Related Contents:

  1. Regex any ASCII character
  2. (grep) Regex to match non-ASCII characters?
  3. Oracle REGEXP_LIKE and word boundaries
  4. Oracle 11g get all matched occurrences by a regular expression
  5. string pattern matching using perl regex [closed]
  6. Why is this regex allowing a caret?
  7. Regex: ignore case sensitivity
  8. How can we match a^n b^n?
  9. Decimal or numeric values in regular expression validation
  10. Carets in Regular Expressions
  11. How do you debug a regex? [closed]
  12. Negating a backreference in Regular Expressions
  13. Regex to split HTML tags
  14. What’s the technical reason for “lookbehind assertion MUST be fixed length” in regex?
  15. R/regex with stringi/ICU: why is a ‘+’ considered a non-[:punct:] character?
  16. How can I exclude some characters from a class?
  17. Can someone explain Possessive Quantifiers to me? (Regular Expressions)
  18. What is the difference between \1 and $1 in a Perl regex?
  19. Regular expression help – comma delimited string
  20. Convert to lowercase in a mod_rewrite rule
  21. How can I use a variable for a regex pattern without interpreting meta characters?
  22. Insert a newline character every 64 characters using Python
  23. Oracle 11g – Check constraint with RegEx
  24. What kind of formal languages can modern regex engines parse?
  25. Regular expressions Equivalence
  26. While replacing using regex, How to keep a part of matched string?
  27. How do I search and replace across multiple lines with Perl?
  28. Regular expression to match digits and basic math operators
  29. What to do when a regular expression pattern doesn’t match anywhere in a string?
  30. Regex for PascalCased words (aka camelCased with leading uppercase letter)

Leave a Comment