Unanswered

How to extract ONLY numbers from string

(0) Share

Report

Posted on by Chintan007

Hi, I have free text column in Dataverse table where alphanumberic values are entered e.g. abc123, 123abc,1abc23. I want to extract ONLY numbers and discard letters using Power Automate. How to do it? I google a lot but no luck. I found solution here but its not efficient solution at all. Please guide

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

bshoyat 24 on at

Like (0)

Report
Copy link

Link copied!

Hi,
Since you strings can contain number anywhere in the string, the best solution i can think of if a really long expression that uses replace. The good news is that you will need to type it once and you can copy it for future uses. But it would look something like this:
replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(toLower('12Ab2aC123'), 'a', ''), 'b', ''), 'c', ''), 'd', ''), 'e', ''), 'f', ''), 'g', ''), 'h', ''), 'i', ''), 'j', ''), 'k', ''), 'l', ''), 'm', ''), 'n', ''), 'o', ''), 'p', ''), 'q', ''), 'r', ''), 's', ''), 't', ''), 'u', ''), 'v', ''), 'w', ''), 'x', ''), 'y', ''), 'z', '')
the resulting string is "122123"

Might not be the prettiest solution, but very efficient. You can also add new characters like to be replaced

Was this reply helpful? Yes No
Ellis Karim 11,983 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Hi @chintan12345 ,

There are now two relatively "new" functions that you could try: Slice() and IsInt()

For example:

SELECT range(0, length(variables('varData'))) if(isInt(slice(variables('varData'),item(), add(item(),1))),slice(variables('varData'),item(), add(item(),1)), '') COMPOSE join(body('Select'),'')

[updated] The Substring() function seems to work also and looks cleaner:

SELECT using substring() range(0, length(variables('varData'))) if(isInt(substring(variables('varData'),item(), 1)), substring(variables('varData'),item(), 1),'')

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No
Chriddle 8,672 Super User 2026 Season 1 on at

Like (7)

Report
Copy link

Link copied!
NumberArray: Select action
From:

chunk(outputs('MixedString'), 1)

Map:

if(contains('0123456789', item()), item(), '')

NumberString: Compose action

join(body('NumberArray'), '')

Was this reply helpful? Yes No