I have a requirement wherein I have a table in which there is a column communication value. Now if during registration the user stores the communication value as +98325468 then it is stored as it is in the doctor table in both ext_communication_value and comm_value columns as +98325468.Now on the UI side the phone number is displayed from the comm_value as +country_code communication value.For eg if the country is India then the phone number is displayed as +91 +98325468. Two plus signs are displayed.
How can I handle special characters like +-*/ etc so that only +91 98325468 is displayed.So that in the ext_communication_value field the actual value is stored but in the comm_value the value without special characters is stored.
Thanks in advance.
1