Hi guys,
I am asking for advice rather complicate things for myself.
I have a column that has a mobile number but sometimes the call agent would put wrong information such as :07999412113, 07999 412113 or mobile07999412113 and when it comes to automating sending SMSs this would fail. I have got rid of the space
using Mobile: Replace([2_Join_Surgery_With_Address]![LCD - Mobile No]," ","") and works fine.
Now I need to check if the mobile number does not begin with 07 and remove everything up to that point and I can get my head around it.
I wonder if someone can help please.
thank you for looking.
Regards
Wessam