In QGIS 3.18 I have several fields of concatenated elements (comma-separated), all of which have the possible substring
Fort as either one discrete comma-separated element, OR a part of a comma-separated element
For example: the substrings
Fort (Dore), or
I want to count the instances of the term
'Fort' across all strings and across all columns, regardless of what precedes or follows it in that substring element. For example:
|Field A||Field B||Desired Output|
I know how to do this in 3 parts, but this would require making 3 columns and I would prefer to have it done in 1 single column. Here is what I can do:
First part: create one single string of all fields concatenated. (
Field A ||','|| Field B
Second part: replace all instances of what I want to count with one single item so that I can count it in an array. (
replace(replace("Field C",'Fort (Ance)','Fort'),'Fort (Dore)','Fort')
Third part: count all instances of 'Fort'. (
array_length( array_filter( string_to_array("Field D"), @element='Fort' ) )
I attempted to use only the third part on my initial sequence, but as far as I can tell
@element refers exclusively to entire values in the array (between commas) and I could not get it to recognize any element with
Fort in it.
I want to put these three expressions in a sequence, as the expression for one single column... if this is possible.
Is it possible to create one single expression that contains these three expressions in sequence (first task 1, then 2, then 3)? I would like a non-Python solution, but would prefer a Python solution to no solution.