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".

enter image description here

  • 3
    Please edit your question to show us a sample on how the texts in the attribute table are look like.
    – ahmadhanb
    Sep 2 '20 at 23:27
  • when extracting apply: for integers use to_int(regexp_substr("field_name", '(\\d+)')) and for symbols to_string(regexp_substr("field_name", '[A-Za-z]+')). when deleting use regexp_replace()instead.
    – Taras
    Sep 4 '20 at 11:46
  • @Taras, your formulas are working!!! Tank you very much for your help.
    – Yems
    Sep 5 '20 at 16:01

To split your field into subfiels, i.e. "alphabetic" or "numeric" apply:

for integers:

to_int(regexp_substr("field_name", '(\\d+)'))

that will give you '199' from '199 (ME)'

for symbols:

to_string(regexp_substr("field_name", '[A-Za-z]+'))

that will give you 'ME' from '199 (ME)'


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.