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. See also REGEXP_INSTR, REGEXP_SUBSTR, REGEXP_LIKE and REGEXP_COUNT for other functions extended to use regular expressions.
Questions tagged [regexp-replace]
1082 questions
-4
votes
1 answer
How will I write an equivalent Python syntax for R syntax
data$GroupId = paste( data$Surname, data$Pclass, sub('.$','X',data$Ticket), data$Fare, data$Embarked, sep='-')
Output:
Output of the following code
Abhinav Pathak
- 3
- 1
-7
votes
2 answers
Tricky RegExp question? How would I do this?
I want a simple validation and case of words don't matter. How would I do this? Preferably I'd like to do this…
guest232131
- 1
- 2