QGIS – Counting Elements in Comma-Separated Strings in Attribute Table

attribute-tablecountfield-calculatorqgisstring

One of my column in an attribute table in QGIS is separated by comma (shown by column "N") and I wanted to count elements in it. The column is a text field string.

Best Answer

Use this expression with field calculator: array_length (string_to_array (N))

Related Solutions

[GIS] Splitting string (the last digits) in QGIS

You can do it using the following formula in the Field Calculator:

regexp_substr("Field_Name",'(\\d+|\\d+.+)')

Where:

The first \ is to escape \d

\d+ : means extract one or more digits.

| : means OR.

\d+.+ : means extract one or more digits and one or more any other character.

It will give you the following results:

numbers
25
2
26A
125
147A

Even if you have text with a name 'Text 123456789ABCDEF', the output will be:

123456789ABCDEF

[GIS] Removing n first digits on a field attribute table using QGIS string functions

You can use substr.

So:

substr(  "Field" , 13,  length( "Field"))

So this grabs everything from the 13th to the Nth character, with the Nth being the lenght of the field.

Best Answer

Related Solutions

[GIS] Splitting string (the last digits) in QGIS

[GIS] Removing n first digits on a field attribute table using QGIS string functions

Related Question