Microsoft Flow ( Remove String from Numbers )

[wsobhi]

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,

[abm]

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

[Mike_Guzowski]

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