Answersで回答する時に使う情報のまとめに戻る

オーストラリアかな？

AND( 
NOT(ISBLANK(MobilePhone)) ,
NOT(REGEX( MobilePhone ,"(^ [+] 614[0-9]{2}(| )[0-9]{3}(| )[0-9]{3}$)|(^04[0-9]{2}(| )[0-9]{3}(| )[0-9]{3}$)"))
)

オーストラリア形式を補完する数式

If statement with multiple conditions for Mobile Phone Australia

IF(LEFT(Phone,4) = "+610","+61"&RIGHT(Phone,LEN(Phone)-4), 
IF(LEFT(Phone,3) = "610","+61"&RIGHT(Phone,LEN(Phone)-3), 
IF(LEFT(Phone,2) = "61","+61"&RIGHT(Phone,LEN(Phone)-2),  
Phone)))

スイス

Swiss Phone Numbers

AND(
NOT(ISBLANK(Phone)) ,
NOT(REGEX(Phone, "[+]{1}41[0-9]{9}"))
)

RegEx for phone number format "+1 ##########"

What's the regular expression that validates the phone number format of '+1', followed by a space, followed by 10 consecutive digits?

RegEx for phone number format "+1 ##########"

AND(
NOT(ISBLANK(Phone)) ,
NOT(REGEX(Phone, "[+]{1}1 [0-9]{10}"))
)

理解できない

Salesforce が電話番号で自動的に入力する括弧とスペースが追加の数字としてカウントされるため、電話番号には 10 桁を入力する必要があるというエラーが表示されます

\d : 半角文字
\D : 半角文字以外

AND(
NOT(ISBLANK( Phone )),
NOT(REGEX( Phone , "\\D*?(\\d\\D*?){10}"))
)

その他

Fix a phone number flow formula

Example Outputs:

Input: 0013059519322
- Output: +13059519322
Input: +13059519322
- Output: +13059519322
Input: (305) 951-9322
- Output: +3059519322
Input: 305-951-9322
- Output: +3059519322

IF(NOT(ISBLANK({!$Record.GC_Mobile__c})),
IF(BEGINS({!$Record.GC_Mobile__c}, "00"),
"+" & MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({!$Record.GC_Mobile__c}, "-", ""), " ", ""), "(", ""), ")", ""),3,
LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({!$Record.GC_Mobile__c}, "-", ""), " ", ""), "(", ""), ")","")) - 1),
IF(BEGINS({!$Record.GC_Mobile__c}, "0"),
"+" & MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({!$Record.GC_Mobile__c}, "-", ""), " ", ""), "(", ""), ")", ""),2,
LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({!$Record.GC_Mobile__c}, "-", ""), " ", ""), "(", ""), ")","")) - 1),
"+" & SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({!$Record.GC_Mobile__c}, "-", ""), " ", ""), "(", ""), ")",""))),
"")