Skip to main content
  • EN

Hello everyone,

I'm looking for a way to check if the ending character of a string attribute is an uppercase letter, and if so, convert it to lowercase. For example:

  • Foo1K → Foo1k
  • BAR4 → BAR4 
  • BAZ → BAz

What's the best way to accomplish this in FME? Are there any specific transformers or approaches that I should use to achieve this result?

You can do this in an AttributeCreator with the following string. This example assumes your attribute name is ‘att’.

@Substring(@Value(att),0,@Evaluate(@StringLength(@Value(att))-1))@LowerCase(@Substring(@Value(att),-1,1))

 

Worked perfectly. Thanks @dustin! 

Reply


Community Stats

30,159
Posts
114,480
Replies
37,806
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.