I am wanting to test a phone number to see if it is a mobile number and then write to a different field.

I hope you can help. I am new to both Dynamics CRM and Scribe. So this is probably a very basic question.

 

I am wanting to test a phone number to see if it is a mobile number and then write to a different field. 

 

I am thinking that I need to strip the phone number back to a 10 digit number then test via an IF statement to check if the first 2 characters are 04, if TRUE write to Mobile, if FALSE write to telephone no. At the same time formatting correctly #### ### ### if mobile ## #### #### if not.

 

I am sure that there is an easy way to do this, but I can't figure it out.

Thanks. Sue

Login