What are the right functions and formulas with the field calculator to delete "alphabet" or "number" inside a field?
Let me be clear. I want to be able to delete "alphabetic letters" or "numbers" inside my records (see the image). I've used replace
, left
, substr
functions, but they don't make any difference between "alphabet" and "number".
to_int(regexp_substr("field_name", '(\\d+)'))
and for symbolsto_string(regexp_substr("field_name", '[A-Za-z]+'))
. when deleting useregexp_replace()
instead. – Taras Sep 4 '20 at 11:46