News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Extract only numbers f...

Power Apps - Building Power Apps

Unanswered

Extract only numbers from string

Like (0) Share

Report

Report

Posted on 5 Apr 2023 01:46:05 by christian12

193

Hi Guys,

I have a dynamic text input box.

I want to only extract numbers and remove everything else. Example letters, spaces, special characters etc.

Any help is greatly appreciated.

Thanks

Categories:

Using Apps Using Formulas

General Questions

All responses Img

All responses (3)

Answers Img

Answers (0)

timl 35,382 Super User 2025 Season 2 on 05 Apr 2023 at 08:24:29

Like (1)

Report
Re: Extract only numbers from string

@christian12

Here's a Regex example that will also work

Match(TextInput1.Text, "[0-9]+").FullMatch
Community Power Pla... on 05 Apr 2023 at 03:52:47

Like (1)

Report
Re: Extract only numbers from string

Hi @christian12 ,

This works for me too ->
Trim(Concat(Split(TextInput1.Text,""),If(IsBlankOrError(Value(Value)),"",Value),""))
Ami K 15,665 Super User 2024 Season 1 on 05 Apr 2023 at 02:09:52

Like (2)

Report
Re: Extract only numbers from string

Either of these tend to work for me:

Trim(Concat(Split(Label7.Text,""),If(IsBlankOrError(Value(Value)),"",Value),""))

Concat(Filter(Split(Label7.Text,""),IsNumeric(Value)),Value)