Replace or delete values in a field or split a field value into an array

Use the regexp_replace(key, '\d+',http_method) function to replace all digits. Use the regexp_replace (key, '\d+') function to delete all digits. Use the regexp_split(key, '\d+') function to split a field value into an array by digit. The results are displayed in a table.

|
SELECT
  key as "Original string",
  regexp_replace(key, '\d+',http_method ) as "Replace all digits",
  regexp_replace (key, '\d+') as "Delete all digits",
  regexp_split(key, '\d+') as "Split a field value into an array by digit"