wvantongeren Posted January 23, 2017 Report Share Posted January 23, 2017 How to separate number, In a calculatedfield I only use the second digit, like: the number = 35 I only want to use the digit 5. I now have (only) this in the calculated field: [@field:Firstnumber]*7 (in my case thats 5*7) = 35 Thanks Quote Link to comment Share on other sites More sharing options...
0 TWIRED Posted January 23, 2017 Report Share Posted January 23, 2017 Use calculated field functions 1) Use Cast to convert the number to a string, 2) select the string character using Left(string, number) 3) Use Cast to convert the string to a number. http://howto.caspio.com/function-reference/ hope it helps. Quote Link to comment Share on other sites More sharing options...
0 NailDyanC Posted July 10, 2021 Report Share Posted July 10, 2021 Hi, just to update this post. It seems that the function that you will need is "Right(string,length)"since you will be getting the last number from the right which is 5. You may consider this workaround: Right((CONVERT(VARCHAR, ([@field: Fieldname]))),1) Just change the field name based on the calculated field that you are using. ParkLoey 1 Quote Link to comment Share on other sites More sharing options...
Question
wvantongeren
How to separate number,
In a calculatedfield I only use the second digit, like:
the number = 35 I only want to use the digit 5.
I now have (only) this in the calculated field:
[@field:Firstnumber]*7 (in my case thats 5*7) = 35
Thanks
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.