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
Solved
remove last 3 numbers
There are several ways, but the simplest is probably to use the SubstringExtractor:
Negative index values are counted from the end of the string.
+44- Evangelist
david_r wrote:
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!
takashi wrote:
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...
+32- Influencer
takashi wrote:
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
ebygomm wrote:
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)Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.