Unanswered

Need to get just numbers and remove any characters and/or whitespace

(0) Share

Report

Posted on by KCKristi

Building a desktop flow and I have scrapped the telephone number from a webpage (user could enter (###) ###-#### or ########## or ###-###-#### or however they want to enter it.......I need to get just the ########## from any or all formatted types. Currently I've gathered the number as a variable, then Set the clipboard - then retreived the clipboard and Ctrl+V to enter it into my database.......issue is if there are any kind of characters, or whitespace, the database field doesn't contain enough spaces to include them and all the numbers.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

UshaJyothiKasibhotla 203 Moderator on at

Like (1)

Report

use regex to fetch the required number by using parse text activity.
then use replace text activity to replace any characters or whitespaces

Hope this helps
Usha

Was this reply helpful? Yes No
Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like (1)

Report

Use Replace text on your variable with regular expressions enabled. Replace [^\d] (anything that is not a digit) with %""% (an empty string). Then use the result to push your data into the database.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No