I have a Condition Statement within AttributeManager that checks if an attribute has a letter at the end of the value.
If this is true then I use Substring to drop the last character.
However, when I use the above it always returns the original value (ex. 999a returns 999a instead of 999).
It does not seem to work with any negative number at the end but if I change -2 to a positive number like 3 it works and returns 999.
Any thoughts on what I am doing wrong here?
Regards
Best answer by david_r
You can also do the whole thing in an AttributeCreator:
@ReplaceRegEx(@Value(HOUSENUM),"[a-zA-Z]$","")
FME is fun :-)
You can try the following expression:
@Left(@Value(HOUSENUM),@StringLength(@Value(HOUSENUM))-1)You can also do the whole thing in an AttributeCreator:
@ReplaceRegEx(@Value(HOUSENUM),"[a-zA-Z]$","")
FME is fun :-)
You can try the following expression:
@Left(@Value(HOUSENUM),@StringLength(@Value(HOUSENUM))-1)
Cheers
+26The Substring function takes a start position and a length as arguments.
The SubstringExtractor takes a start position and end position as arguments.
I know, confusing. Would be nice if they would take the same arguments.
