Question

Transformer to search for a value/regexp in any column

hlouie
Rank
Badge +11

find in any columnI know StringSearch can look at that one selected column but I'm looking for a transformer that will search any column for a value? (similar way Visual Preview can find ??? in "any column")

3 replies

muzhnasto
Rank
Badge +11

Hi @hlouie​ maybe https://hub.safe.com/publishers/gisinnovationsb/transformers/globalstringsearcher and https://hub.safe.com/publishers/gisinnovationsb/templates/globalsearch

geomancer
Rank
Userlevel 4
Badge +36

Can you combine all attributes in a new attribute (using StringConcatenator or AttributeCreator or AttributeManager), placing a separator character between the different attribute values, and search the resulting attribute?

Combine_Attributes

nielsgerrits
Rank
Userlevel 6
Badge +32

If you also need the corresponding column name and / or you want to make it dynamic you can use the AttributeExploder to create a feature for each attribute and search in _attr_value.

 

Edit: this is the way the GlobalStringSearcher from the hub works.

Reply


Community Stats

28,681
Posts
109,402
Replies
36,540
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.