regex example in postgresql

Powerful regex function example.

SELECT
regexp_replace(‘abc12344′, ‘^([A-Za-z]+).*’, ‘\\1′) AS new,

regexp_replace(‘i,9.33,9.80,62;change,10.30,10.96,34;or,10.76,11.11,70;cancel,10.91,11.64,93;your,11.49,11.85,86;reservation,11.70,12.55,90;’ ,

‘[0-9]+\.?[0-9]*,?’ , ”,’g') n1

Replace consecutive characters:

SELECT regexp_replace('aaab21','[A-Za-z]{3}','x','g') AS new;