A business needs to clean up contact information stored in an Excel file containing a “Phone Numbers” column. Build a UiPath automation that will remove all special characters (such as “-”, “( )”, spaces) from the phone numbers. It will then keep only val

[256_SHIVAM_KUMAR_SHARMA]

 please can anyone can help me to solve this i have used all of my knowledge but it is not working properly it is making new sheed named cleanednumbers but it does not clean it instead of it only copy paste the previous things

[c.ciprian (Ciprian Constantinescu)]

Just use a regular expression to remove non numeric data. Also, I do not understand what are you trying to do with the filter datatable.

[dheephiga.am]

Use any of the regex generator to get the expression and use it to remove the special characters right away.

Refer to this video as well

UiPath | How Regex Multiple Matches Works

Happy automation