...
For columns containing phone number data, you can use the Patterns tab to standardize formatting options. Consider the following values, which are valid phone numbers. Next to each value is a pattern representing the value:
| PhoneNum | |
|---|
| (415) 555-1212 | | Code Block |
|---|
\(({digit}{3})\) ({digit}{3})\-({digit}{4}) |
|
| 415-555-1212 | | Code Block |
|---|
({digit}{3})\-({digit}{3})\-({digit}{4}) |
|
| 415.555.1212 | | Code Block |
|---|
({digit}{3}).({digit}{3}).({digit}{3}) |
|
| 415 555-1212 | | Code Block |
|---|
({digit}{3}) ({digit}{3})\-({digit}{4}) |
|
| 1+415-555-1212 | | Code Block |
|---|
1\+{digit}{3}\-{digit}{3}\-{digit}{4} |
|
...
