Question

feature merger and join using wildcard

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.

Userlevel 4

Hi,

you can probably do this using the InlineQuerier.

David

Userlevel 1

+21

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

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

Sign up