Hello!

I have exhausted my search in finding my answer so I am submitting the question!

We are trying to fix incoming data where the phone numbers have a "+" at the beginning. AFter tons of readings, I was able to correct this by using a segment and filter, however, I have been unable to show a successful test through a contact washing machine step. It seems as though what I perceive to be the best option (RegEx Replace) might not be as it looks for patterns, but my excel knowlege of functions tells me I should be able to look for a pattern of a + sign at the beginning of a string of letters.

Here is the information in my "Configure your action" step.

What kind of phone numbers: US & International - I understand I might have to have several conditions

Source: Business Phone
Condition: Business Phone: Contains: +
Action: RegEx Replace
Reg Expression to Find: ????
Reg Expression to Replace: ?????

with rws as (
  select '+1-123-4567890' phone# from dual union all
  select '+44-1234-567890' phone# from dual
)
  select regexp_replace ( phone#, '^+' ),
         regexp_replace ( phone#, '^\+' ),
         replace ( phone#, '+' )
  from   rws;
  
REGEXP_REPLACE( REGEXP_REPLACE( REPLACE(PHONE#,
--------------- --------------- ---------------
+1-123-4567890  1-123-4567890   1-123-4567890  
+44-1234-567890 44-1234-567890  44-1234-567890