Top "Regexp-replace" questions

Function in Oracle, Mysql, Hive, Teradata, DB2, Snowflake, Trino, Vertica, PostgreSQL, Redshift and other databases that extends the functionality of the REPLACE function by allowing searching a string for a regular expression pattern.

how to use Regexp_replace in spark

I am pretty new to spark and would like to perform an operation on a column of a dataframe so …

scala apache-spark apache-spark-sql regexp-replace
Laravel preg_match(): No ending delimiter '/' found

Im working on Laravel 4.2. Im trying to use Validator to validate a name field with regex, here is my rule …

php regex laravel laravel-4 regexp-replace
Extract numbers from a field in PostgreSQL

I have a table with a column po_number of type varchar in Postgres 8.4. It stores alphanumeric values with some …

regex postgresql conditional case regexp-replace
Teradata regexp_replace to eliminate specific special characters

I imported a file that contains email addresses (email_source). I need to join this table to another, using this …

regex teradata regexp-replace
Pyspark removing multiple characters in a dataframe column

Looking at pyspark, i see translate and regexp_replace to help me a single characters that exists in a dataframe …

pyspark translate regexp-replace
Error: String contains an untranslatable character - TERADATA (for REGEXP_REPLACE operation)

I need to clean one character column and for that I am using REGEXP_REPLACE function in Teradata 14. The same …

sql teradata regexp-replace
Python 3.7.4: 're.error: bad escape \s at position 0'

My program looks something like this: import re # Escape the string, in case it happens to have re metacharacters my_…

python regex python-3.7 regexp-replace
regex to replace backslash and single quote with single quote using postgres regexp_replace()

Just as the title states, I'm not the best w/ regex, so can anyone provide the appropriate regex for the …

regex postgresql regexp-replace
Retrieving first X words from a string in Oracle Select

I need to select the first X words in a string, where x can be any number from 0-100. Is …

oracle regexp-replace regexp-substr
REGEXP_REPLACE capturing groups

I was wondering if someone could help me understand how to use Hive's regexp_replace function to capture groups in …

regex hadoop hive regexp-replace