Skip to main content
  • EN

Has anyone else had any issues with the SubstringExtractor in FME2025? I have a process that works in an older version (2021) but in the 2025 version I am seeing a different behavior.

Wanting the last 7 characters in a string I used a Start Index of -7 and an End Index of -1. This worked in FME 2021. When opening the workspace in FME 2025, it initially works, but when I upgrade the transformer from V2 to V3, it then returns no value. I created a new blank workspace and added a brand new SubstringExtractor in 2025 and saw the same result. It seems to work selecting values from the start like Start 4 End 7, or Start 2 End -1. But having the start be negative seems to always return no value. The change listed for the V2-V3 upgrade was adding bulk mode support.

Hoping I am just missing something/doing something wrong here.

Version is 2025.0.1.0

Attached is a version of the workspace with the transformer not upgraded, that way you can see the before and after by just upgrading it on your end if desired.

 

Thanks

I can reproduce the problem as described. It’s a bug. But you must not upgrade this transformer.

Hi ​@liamfez Unfortunately this is a known issue which has existed since FME 2024.1 (for version 3) but it will be fixed soon (via FMEENGINE-86932) in FME 2025.1 beta. 

​@tomfriedl and ​@DanAtSafe Thank you both. 

​@liamfez an alternative approach could be - until 2025.1 is there - to use the String Function in the Attribute Manager. I used this one this afternoon and it works fine.

String function:
Substring(string,startIdxr,numChars])

 

 

Community Stats

31,789
Posts
120,751
Replies
39,405
Members

Latest FME

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.