HI everyone,
I would like to remove last 3 numbers from a value. For example 010003000 to > 010003... or 123456789 > 123456 (not all values are ending with 0)
so I do need some general formel for this.
any tips?
Thanks
Page 1 / 1
There are several ways, but the simplest is probably to use the SubstringExtractor:
Negative index values are counted from the end of the string.
You can use a substring extractor with the following settings
There are several ways, but the simplest is probably to use the SubstringExtractor:
Negative index values are counted from the end of the string.
Well done!
Hi @terezia86, you can use the StringLengthCalculator to get the length (number of characters) of the value and extract desired substring with the SubstringExtrator, as in.
Just be aware that the index representing position of a character starts with 0, so you need to subtract 4 (not 3) from the total length.
Perfect!
THANKS!
Hi @terezia86, you can use the StringLengthCalculator to get the length (number of characters) of the value and extract desired substring with the SubstringExtrator, as in.
Just be aware that the index representing position of a character starts with 0, so you need to subtract 4 (not 3) from the total length.
Ah yes, the index can be a negative number...
Ah yes, the index can be a negative number...
It's a pity you can't use the negative numbers like that in an @Substring expression
It's a pity you can't use the negative numbers like that in an @Substring expression
Not a big deal, though...
@Left(@Value(text),@StringLength(@Value(text))-3)