Hi,
Any ideas how to remove the last three characters from a Data Label Value.
So if the Value is "TEST #3" how do i remove the "space#3" tag ???
or is there a way to look for and remove the String "space#3" as it will always be the same
Is there an expression that will do it?
Thanks, help appreciated as always
Best answer by tbyrne777
View originalAn expression is the way to go - there are a few built-in Text functions that you will need to use in this expression, "Mid" should get you started. Something like: MID ([your data label], 0, LENGTH([your data label]) - 3)
Hi Sharpharp1,
In addition you may checkout the link below for expressions
https://help.k2.com/onlinehelp/K2Five/UserGuide/5.3/default.htm#Create/Views/ControlExpressions.htm
Hope this helps
Should you feel that this post is of use and or an accurate solution to the raised question, I kindly encourage you to mark it as such
using the 'Mark as Solution', 'Kudo' andor ‘Me Too’ options.
Cheers,
Kate
K2 will not accept any liability for any issues arising from actions taken in respect of the information provided by any forum member.
Hi tbyrne,
I tried that expression, but it doesn't work, it just displays the same text as the original data label.
see attachment
Any ideas?
Please find the attached example - I think it is simply a matter of positioning the "Minus" in the right place
Thanks tbyrne, the example worked.
Cheers
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
