Skip to main content
  • EN

I am trying to find a functionality within FME that allows me to replace substrings based on a lookup table. Since I have several hundred mappings, chaining string replacers together isn’t really an option.

Basically something like an AttributeValueMapper that looks at substrings instead of the whole value only or a string replacer that accepts multiple string/replacement inputs.

Is there such a transformer or any workaround to do this?

Thank you! 

nevermind, found the StringPairReplacer

I've used an inlinequerier to do this in the past which allows lookups to be maintained in a table outside of the workspace 

Can you share your sql script? I am trying to switch over to a dynamic solution using an external lookup table as well.

Reply


Community Stats

30,351
Posts
115,341
Replies
38,080
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.