python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - regexp-replace

H2 REGEXP_REPLACE function to get value

Here i my sample string: {"username":"sample_usernme","login":"jack777","groups":[],"emailAddress":"sample@sample.com","company":null,"phone":null,"bindedKeys":["sample_usernme"],"owner":null,"exp...
test-img

orion363

database

function

get

h2

regexp-replace

Votes: 0

Answers: 0

pass regex group to function for substituting

I have a passage of text that contains VALID dates formatted as dd/mm/yyyy. I need to replace all months to their respective month name. 10/05/1999 -> 10 May 1999 I find dates and capture each part...
test-img

quokkas-are-cute

python-3.x

regex

regex-group

python-re

regexp-replace

python-3.x

regex

regex-group

python-re

regexp-replace

Votes: 0

Answers: 0

replace all special characters in column values of a SQL table

I have a column (in a SQL table) with several entries containing special characters (ampersand, comma, forward slash, dash, and parenthesis). Is there a simple way to remove all these special characte...
test-img

veg2020

sql

snowflake-cloud-data-platform

special-characters

regexp-replace

Votes: 0

Answers: 0

regex_replace value that starts with char, followed by integers BigQuery SQL

I have a table in BigQuery that I need to clean up. In column content_column I have values like: content_column /a68786776 /g263647 /g47664 /galleries /music I want to replace all values that start w...
test-img

Chique_Code

sql

regex

google-bigquery

regexp-replace

Votes: 0

Answers: 2

Latest Answer

If you want to replace the full match with gallery you don't need a capture group in the pattern. This pattern \w+\d+ matches 1+ word chars and 1+ digits, which is a minimum of 2 characters and does ...
test-img

The fourth bird

Posts

Questions

Blogs

Jobs