Skip to main content
  • EN
HI All,

 

 

I never really thought about this one until now, but is it possible to featuremerge on wildcard values?

 

 

For example,

 

 

I have a point file with an ID value.  The ID values are unique.  ie A, B, C, D

 

I have a many table of values with a ID value of A_1990, A2, A, B1,B2,BC,D1,D3,D9

 

 

Is it possible feature merge based on a wild card?

 

ie..  *A* join to A_1990,A2

 

        *B* joins to B1,B2,BC

 

       *D* joins to D1,D3,D9

 

 

Thx for the quick reply. 

 

 

I didn't think so either...I was trying to avoid doing a bunch of string manipulations. 

 

 

Hi,

 

 

you can probably do this using the InlineQuerier.

 

 

David
You should be able to extract the letter in one transformer using regularexpressions and then featuremerge.

 

 

e.g. by using something like regsub -all {l^A-Z+]} ]FME_GetAttribute Anattribute] {} in a TCLCaller

 

 

Reply


Community Stats

30,108
Posts
114,295
Replies
37,743
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.