Context:
Just noticed that our inbound webhooks deliver phone numbers in E.164 format (+1XXXXXXXXXX), but our downstream CRM requires (XXX) XXX-XXXX. I need a reliable Architect expression to handle this transformation without external calls.
Question:
What is the most robust regex or substring combination in Architect to convert +1XXXXXXXXXX to (XXX) XXX-XXXX? My current attempt using SUBSTR is brittle. Does REGEX_MATCH handle the country code stripping cleanly?