Has anybody built an automation to standardize phone numbers?
We have phone numbers stored as an attribute in Assets pulling in from Microosft EntraID, but unfortunately the phone numbers are in a variety of formats. Examples below:
- XXX-XXX-XXXX
- XXXXXXXXXX
- 1XXXXXXXXXX
- (XXX) XXX-XXXX
- +96 XXX XXX XXXX
Has anybody built automation to push phone numbers into a standard format?