Remove the value from the row if it contains the following(+,-,(,))

[FASupport21_Praveen_Kumar]

Assuming that the row value containg the contact details like mobile no and land line number if its a mobile number its form (+91-9876543210) i want to remove (=,-,91) if its land line its of form(04423456789) i want to remove the open and close bracket if any ofthe row value like this (9876x34533)i want to rejecct the value please suggest me a valid condition

thanks

[balu (Bharath Yadav)]

you would use substring/replace functions and give a try.

Thanks

[Lakshay_Verma]

User Regex
\d

regex101: build, test, and debug regex

@FASupport21_Praveen_Kumar

[desineediaditya (Aditya D)]

Hi @FASupport21_Praveen_Kumar,

Try to replace that particular special character with space that should work.
Take a look at this video that might help

- YouTube

if this solves your problem then mark it as solution.
@cheers!

[Arpit_Kesharwani]

@FASupport21_Praveen_Kumar Use following regex : \d{10,11}
If the match value is null then reject otherwise take it into consideration

[Pratik_Wavhal]

Hi @FASupport21_Praveen_Kumar

I have created one Workflow from which you will get your output 100%

Below is the excel where the input data is stored same like you shown in your post

This is the output got when I run my workflow and which is the same that you are finding

I am attaching the same .Xaml file below, please have a look
Main.xaml (13.1 KB)
Phone No Details.xlsx (9.5 KB)

Hope this workflow may help you to solve your issue
Mark as solution if this helps you and like it

Happy Automation

Best Regards
Er Pratik Wavhal

[FASupport21_Praveen_Kumar]

thanks@Arpit_Kesharwani