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
Best answer by ebygomm
You can use a substring extractor with the following settings
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.
+52- Celebrity
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...
+46- Influencer
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)