replace a part of a string with REGEXP in sqlite3

by

Sqlite by default does not provide regex_replace function. You need to load it as an extension. Here is how i managed to do it.

Download this C code for the extension (icu_replace)

Compile it using 

gcc --shared -fPIC -I sqlite-autoconf-3071100 icu_replace.c -o icu_replace.so

And in sqlite3 runn following command post above mentioned command has run and create a file icu_replace.so

SELECT load_extension(' path to icu_replace.so', 'sqlite3_extension_init') from dual;

After this you will be able to use such a function as :-

select regex_replace('\bThe\b',x,'M') from dual;

More Related Contents:

  1. Non greedy (reluctant) regex matching in sed?
  2. How do I use regex in a SQLite query?
  3. How do you debug a regex? [closed]
  4. Regular expression – PCRE does not support \L, \l, \N, \P,
  5. Verbs that act after backtracking and failure
  6. Is it possible to define a pattern and reuse it to capture multiple groups?
  7. What’s the technical reason for “lookbehind assertion MUST be fixed length” in regex?
  8. Unicode Regex; Invalid XML characters
  9. Why can’t you use repetition quantifiers in zero-width look behind assertions?
  10. Can someone explain Possessive Quantifiers to me? (Regular Expressions)
  11. Invert match with regexp [duplicate]
  12. string pattern matching using perl regex [closed]
  13. Why is this regex allowing a caret?
  14. Regex: ignore case sensitivity
  15. PHP regular expressions: No ending delimiter ‘^’ found in
  16. How can we match a^n b^n?
  17. Decimal or numeric values in regular expression validation
  18. Carets in Regular Expressions
  19. (grep) Regex to match non-ASCII characters?
  20. Negating a backreference in Regular Expressions
  21. Regex to split HTML tags
  22. R/regex with stringi/ICU: why is a ‘+’ considered a non-[:punct:] character?
  23. Convert dd/mm/yy and dd/mm/yyyy to Dates
  24. apache mod_rewrite one rule for any number of possibilities
  25. Regular Expression Word Boundary and Special Characters
  26. How to search and replace with a counter-based expression in Vim?
  27. Why does VIM have its own regex syntax?
  28. Regular Expression usage with ls
  29. Difference between regex quantifiers plus and star
  30. Finding and removing Non-ASCII characters from an Oracle Varchar2

Leave a Comment