I want to remove two plus(+) sign from phone number field and add just one plus sign.

For eg: The phone number can be in any of these formats:

(+) (+911) 24234324324324
++091787534 5303
(++91) 9711931220`

Desired Output:

(+911) 24234324324324
+091787534 5303
(+91) 9711931220`

Below is the query that I am using

**replace((TRIM(LEADING '0' FROM (REGEXP_REPLACE(channel_value, '[]\[!@#$%.&*~^_{}:;<>/\|()+-]', '')))),' ' ,'')**

Waiting for your suggestions.

Thank you.