Notifications
Announcements
No record found.
I want to extract the numbers from the stringe.g., 123Arpit ...so what i want the output as 123Can anyone please help me how to do it. Thank you
*This post is locked for comments
you have several options, the most obvious is strKeep(inputString, '0123456789')
But it is not fixed like i have various numbers
e.g., 101arpit
10arpit
1023arpit
strKeep keeps only the characters that you want to keep
strKeep('101arpit','0123456789') returns '101'
strKeep('1023arpit','0123456789') returns '1023'
You can use strKeep function to dissolve alphabets. It always returns string value where in which you can convert to integer.
Eg: strKeep("123Arpit567","0123456789") // returns "123567"
Thank you very much guys.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 4 Most Valuable Professional
Priya_K 4
MyDynamicsNAV 2
