Skip to main content
Question

replace substrings based on a lookup table

  • October 1, 2024
  • 3 replies
  • 103 views

pkno
Contributor
Forum|alt.badge.img+5

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! 

3 replies

pkno
Contributor
Forum|alt.badge.img+5
  • Author
  • Contributor
  • October 1, 2024

nevermind, found the StringPairReplacer


ebygomm
Influencer
Forum|alt.badge.img+46
  • Influencer
  • October 1, 2024

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


pkno
Contributor
Forum|alt.badge.img+5
  • Author
  • Contributor
  • November 12, 2024

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