Skip to main content
Topics#Data ManagementOtis Negel Bentick의 질문
Otis Negel Bentick (National Board Of Medical Examiners) 님이 #Data Management에 질문했습니다
2020년 1월 14일 오후 2:41

How to restrict zip code entries to known zip formats from around the world

Can anyone please tell me where in this code I can find the clause that checks the length of the country field. I would like to use this to manage zip code entries and restrict all entries known zip codes format/length.

 

AND( OR(ShippingCountry = "USA", ISBLANK(ShippingCountry)), OR( AND(LEN(ShippingPostalCode) <>5, LEN(ShippingPostalCode) <> 10), NOT(CONTAINS("0123456789", LEFT( ShippingPostalCode, 1))), NOT(CONTAINS("0123456789", MID( ShippingPostalCode , 2, 1))), NOT(CONTAINS("0123456789", MID( ShippingPostalCode , 3, 1))), NOT(CONTAINS("0123456789", MID( ShippingPostalCode , 4, 1))), NOT(CONTAINS("0123456789", MID( ShippingPostalCode , 5, 1))), AND( LEN(ShippingPostalCode) = 10, OR( MID( ShippingPostalCode , 6, 1) <> "-", NOT(CONTAINS("0123456789", MID( ShippingPostalCode , 7, 1))), NOT(CONTAINS("0123456789", MID( ShippingPostalCode , 8, 1))), NOT(CONTAINS("0123456789", MID( ShippingPostalCode , 9, 1))), NOT(CONTAINS("0123456789", MID( ShippingPostalCode , 10, 1))) ) ) ) )
답변 4개
답변을 작성하세요...
0/9000