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
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.
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.
There are several ways, but the simplest is probably to use the SubstringExtractor:
Negative index values are counted from the end of the string.
+51- 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...
+43- 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...
1@Left(@Value(text),@StringLength(@Value(text))-3)Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.