Skip to main content
Released

Add option for whether to ignore leading and trailing spaces in transformers tha

Related products:FME Form
siennaatsafe
fmelizard
ebygomm
redgeographics
jelle
+5
  • siennaatsafe
    siennaatsafe
  • fmelizard
    fmelizard
  • ebygomm
    ebygomm
  • redgeographics
    redgeographics
  • jelle
    jelle
  • chriswilson
    chriswilson
  • revesz
    revesz
  • michaelfitzpatr
    michaelfitzpatr
  • cruky
    cruky
  • dbaldacchino

fmelizard
Contributor

***Note from Migration:***

Original Title was: Add option for whether to ignore leading and trailing spaces in transformers that matches attribute values


In FME there are a lot of transformers that compares values of attributes, as part of their function. e.g. FeatureMerger, Matcher, DuplicateFilter, etc.
These transformers don't all behave consistently, when it comes to whether they ignore the leading and training spaces.
For example FeatureMerger will consider values "a", " a", and " a " the same, in matching key attributes; While DuplicateFilter will consider these values different from one another.

It would be nice to add an option, which allow users to specify whether these spaces should be ignored or not.

This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

Forum|alt.badge.img+6

UGH! I thought it was buggy behavior and filed a case, then was pointed to this link. I would prefer to have all transformers behave consistently and not try to do things without user knowledge. Those can then be exposed as options. The transformers that led me to understand that they were doing something with trailing spaces were the SchemaMapper and FeatureMerger. In the case of the SchemaMapper, the built-in behavior was actually NOT desireable and was causing issues in the end result.


ebygomm
Influencer
Forum|alt.badge.img+31
  • Influencer
  • August 30, 2019

Yes, I had a featuremerger followed by a group by and the feature merger ignores the trailing space whilst the group by does not leading to erroneous results. I've ended up adding a string length test to my featuremergers to ensure leading/trailing spaces are not considered matches.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings