web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) I want to extract the ...

Microsoft Dynamics AX (Archived)

I want to extract the numbers from the string

(0) Share

Report

Report

Posted on by ARPIT CHAVHAN

4,359

I want to extract the numbers from the string
e.g., 123Arpit ...so what i want the output as 123
Can anyone please help me how to do it. Thank you

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (2)

Verified answer

Martin Dráb 239,029 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

you have several options, the most obvious is strKeep(inputString, '0123456789')

Was this reply helpful? Yes No
ARPIT CHAVHAN 4,359 on at

Like (0)

Report
Copy link

Link copied!

But it is not fixed like i have various numbers

e.g., 101arpit

10arpit

1023arpit

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

strKeep keeps only the characters that you want to keep

strKeep('101arpit','0123456789') returns '101'

strKeep('1023arpit','0123456789') returns '1023'

Was this reply helpful? Yes No
Fayaz Ahamed 1,420 on at

Like (0)

Report
Copy link

Link copied!

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"

Was this reply helpful? Yes No
ARPIT CHAVHAN 4,359 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much guys.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

#2

Alexey Lekanov 2

#2

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans