Skip to main content
Solved

Trouble with SubstringExtractor

  • June 12, 2025
  • 4 replies
  • 119 views

liamfez
Influencer
Forum|alt.badge.img+43

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

Best answer by DanAtSafe

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. 

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, 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.

4 replies

tomfriedl
Contributor
Forum|alt.badge.img+13
  • Contributor
  • June 12, 2025

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


DanAtSafe
Safer
Forum|alt.badge.img+20
  • Safer
  • Best Answer
  • June 12, 2025

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. 


liamfez
Influencer
Forum|alt.badge.img+43
  • Author
  • Influencer
  • June 12, 2025

@tomfriedl and ​@DanAtSafe Thank you both. 


lambertus
Enthusiast
Forum|alt.badge.img+23
  • Enthusiast
  • July 8, 2025

@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,startIdx[,numChars])