cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate II
Advocate II

Microsoft Flow ( Remove String from Numbers )

Hello,

 

I want to design a flow which when a new email arrives in my inbox, I want to parse the string from the email subject and keep only the numbers to be inserted using sql server.
For example :

(rjyrug76745jhjghfr) want only the numbers (76745)

or (uifiry77rjghrff87876) want only the numbers (7787876).

 

Regards,

2 REPLIES 2
Super User III
Super User III

Hi @wsobhi,

 

The best way is define a function in SQL and extract the number from the string

Microsoft doc
https://docs.microsoft.com/en-us/sql/relational-databases/user-defined-functions/create-user-defined...

Example
https://blog.sqlauthority.com/2018/08/30/sql-server-udf-user-defined-function-to-extract-only-number...

If you want to do via flow then you need to define an Azure function and put the extract logic.

Then call the Azure function from flow

https://docs.microsoft.com/en-us/azure/azure-functions/functions-flow-scenario

 

If you find it useful then please mark it as accepted solution.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Kudo Kingpin
Kudo Kingpin

Hi @wsobhi,

That is definately possible but a bit tricky.

 

Big picture of your algorythm is following:

1. iterate throughout each character in a string

2. if character is a number add it to an output collection

 

For part 1:

- create counter variable = 0

create outputString variable = ""

- use Do Until action counter = length of your string (use length function for that)

- take next character using following function: 
substring(<YOUR STRING HERE>,variables('counter'),1)

 

For part 2: 

- use if action with following: int(<above function) = true

- use action Append to string variable

 
Once your algorythm exit Do Until loop the outputString variable will contains your numbers
 
------------------------
If my reply helps you please mark it as Solution so others can find it easier

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (1,060)