You need to sign in to do that
Don't have an account?
Vasavi Vajinepalli
Removing '-' from phone number field which is of type String
Hi,
I've a field for Phone number of type String. And the format of it would be 111-222-3333. I want to remove the '-' from it and it should look like 1112223333. Please suggest me a validation rule or formula to achieve this.
Thanks,
vasavi
I've a field for Phone number of type String. And the format of it would be 111-222-3333. I want to remove the '-' from it and it should look like 1112223333. Please suggest me a validation rule or formula to achieve this.
Thanks,
vasavi
Use the following code it will work for you: Let me know if it helped you.
Thanks for your post. But i would like to have logic as a validation rule or formula. Could you help me in that regard?
Thanks,
vasavi
SUBSTITUTE( phoneNumber__c, '-', '')
hope it will work.
Thanks,
vasavi
You need to create formula field on that object and select data type as TEXT and in advance formula editor put this formula
SUBSTITUTE( phoneNumber__c, '-', ''). Now use this new field whereever you want to use.