3

My dataset contains numeric values, alphanumeric values, and non-numeric values. How can I filter data which contains numeric values? Below is an example showing a list of data and filtered data which I want.

enter image description here

1
  • Is the criteria for matching as simple as, "if a text field contains at least 1 number character then return the whole field?"
    – bixb0012
    Commented Mar 30, 2023 at 13:58

1 Answer 1

8

Use the following expression with function regexp_match(). The Regular Expression \\d finds any digit. Use double backslashes, because in QGIS,

Backslash characters must be double escaped

regexp_match ("Data",('\\d'))

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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