How to get only digit value from a string

(1) Share

Report

Posted on by NA-03061633-0

Hi all,

My use case for example -

if text variable value is FBLN123456

I want an output as 123456

the string value can anything it's not fixed, the main purpose is to get all digit value from end.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Suggested answer

Vish WR 3,748 on at

Like
a
(2)

Report
Copy link

Link copied!

@NA-03061633-0

This formula extracts the number from the very end of a text string

first(match(variables('YourTextVariable'), '\d+$'))

Vishnu WR

LinkedIn - My Tech Space

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥

Was this reply helpful? Yes No
Suggested answer

Ellis Karim 12,163 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
@NA-03061633-0,

If the string always starts with 4 text characters, you can use the slice function as shown in the examples below:

slice('FBLN123456',4) slice(variables('text'),4)

These examples remove the first four characters of the string and keeps everything from index 4 (after the 4th character) to the end of the string. @Vish WR there is no match function in Power Automate or native Regex support in Power Automate.

Another method: If you want to extract the numbers from any string see: How to Extract Numbers from a String Using Power Automate

The example below demonstrates the slice function, which returns "123456" because it removes the first four characters and keeps everything from index 4 to the end:

Ellis Karim
elliskarim.com | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No
NA-03061633-0 67 on at

Like
a
(3)

Report
Copy link

Link copied!

@Vish WR where to use this expression , i am using power automate desktop , tried this expression in set variable but did not get any result

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

Like
a
(1)

Report
Copy link

Link copied!

Sorry, I seems to have missed the tag for Power Automate desktop. I blame my new computer use glasses!

Was this reply helpful? Yes No
Suggested answer

Haque 3,653 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @NA-03061633-0,

I understand it is in PowerAutomate Desktop. If your string pattern and format is as given in the example (FBLN123456) , Get subtext action might be an option.

OUTPUT

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

Was this reply helpful? Yes No
NA-03061633-0 67 on at

Like
a
(1)

Report
Copy link

Link copied!

@Haque as mentioned string and position is not fixed

Was this reply helpful? Yes No
Vish WR 3,748 on at

Like
a
(2)

Report
Copy link

Link copied!

@NA-03061633-0

You can replace text with strings empty or null and strip null to get the number only

https://community.powerplatform.com/forums/thread/details/?threadid=985e81ab-5be5-ef11-a731-7c1e520bcdcd

https://www.serverlessnotes.com/docs/replacing-text-in-power-automate-desktop

Was this reply helpful? Yes No
Verified answer

Haque 3,653 on at

Like
a
(3)

Report
Copy link

Link copied!

Hi @NA-03061633-0,

Please try Parse text action to achieve this like below:

Test case-1:

Test Case-2:

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

Was this reply helpful? Yes No