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,
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsHi @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
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
14 | |
14 | |
9 | |
7 | |
6 |
User | Count |
---|---|
20 | |
16 | |
9 | |
8 | |
7 |