Một số pattern dùng trong việc kiểm tra dữ liệu theo chuẩn châu âu. | Some pattern used in the check validate data according to European standards.

Công việc của mình có liên quan tới xử lý dữ liệu, đa phần ở châu âu, đây là nhưng pattern được dùng để kiểm tra dữ liệu nhập theo tiêu chuẩn của một số nước ở châu âu. Đây là kết quả đúc kết lâu dài trong quá trình làm việc, nên rất hữu cho các bạn nào làm việc tương tự.

Chuẩn 1:

• Beleg_Land: (DE|AT|NL|BE|CH|CZ|SK|BG|LT|LV|SI|HR|HU|RO|PL|de|at|nl|be|ch|cz|sk|bg|lt|lv|si|hr|hu|ro|pl)
• Mobilephone: \d{5,19}
• Anrede: (1)|(2)|(Frau)|(Herr)
• Title:[^~,!,@,#,$,%,^,&,*,(,),_,+,|,},{,",:,?,>,<,`,=,\,',;,,,\[,\]]+
• Vorname:[^0-9,~,!,@,#,$,%,^,&,*,(,),_,+,|,},{,",:,?,>,<,`,=,\,;,/,,,\[,\]]+
• Nachname: [^("<>!@#$%^*{}+_=|/;:?~\[\]\\)]*
• Email: [_a-zA-Z0-9-öäü@ .-]+
• DateFormat - DDMMYYYY: ^(0[1-9]|[12][0-9]|3[01])(0[1-9]|1[012])(19|20)\d\d$
• PLZ: ([\d]{5}[\d]{4})|([\d]{2}[\d]{3})|([\d]{4,6})|([\d]{4}[A-Z]{2})|([A-Z][\d][\d][A-Z]{2})|([A-Z][\d]{2}[\d][A-Z]{2})|([A-Z][\d][A-Z][\d][A-Z]{2})|([A-Z]{2}[\d][\d][A-Z]{2})|([A-Z]{2}[\d]{2}[\d][A-Z]{2})|([A-Z]{2}[\d][A-Z][\d][A-Z]{2})|([\d]{4}[\-][\d]{3})|([A-Z][\d][A-Z][\d][A-Z][\d])|([A-Z][\d]{4}[A-Z]{3})|([A-Z]{3}[\d]{2})|([A-Z]{2} \d{5})|([A-Z0-9]{2,4}[A-Z0-9]{3})|([A-Z0-9]{3}[A-Z0-9]{3})|(\d{2}\d{3})|(\d{3}\d{2})|(\d{3}\d{3})|(\d{4}\d{3}) 7
• ORT:[^~,!,@,#,$,%,^,&,*,(,),_,+,|,},{,",:,?,>,<,`,=,\,;,,,\[,\]]+
• Street: [^~,!,@,#,$,%,^,&,*,(,),_,+,|,},{,",:,?,>,<,`,=,\,;,,,\[,\]]+
• Hausnummer: [^~,!,@,#,$,%,^,&,*,(,),_,+,|,},{,",:,?,>,<,`,=,\,',;,,,\[,\]]+
• Number: [0-9]+
• Amex_Numer: [0-9]+
•  Land:(AF)|(AD)|(AE)|(AG)|(AI)|(AL)|(AM)|(AN)|(AO)|(AQ)|(AR)|(AS)|(AT)|(AU)|(AW)|(AX)|(AZ)|(BA)|(BB)|(BD)|(BE)|(BF)|(BG)|(BH)|(BI)|(BJ)|(BM)|(BN)|(BO)|(BR)|(BS)|(BT)|(BV)|(BW)|(BY)|(BZ)|(CA)|(CC)|(CD)|(CF)|(CG)|(CH)|(CI)|(CK)|(CL)|(CM)|(CN)|(CO)|(CR)|(CS)|(CU)|(CV)|(CX)|(CY)|(CZ)|(DE)|(DJ)|(DK)|(DM)|(DO)|(DZ)|(EC)|(EE)|(EG)|(EH)|(ER)|(ES)|(ET)|(FI)|(FJ)|(FK)|(FL)|(FM)|(FO)|(FR)|(GA)|(GB)|(GD)|(GE)|(GF)|(GH)|(GI)|(GL)|(GM)|(GN)|(GP)|(GQ)|(GR)|(GS)|(GT)|(GU)|(GW)|(GY)|(HK)|(HM)|(HN)|(HR)|(HT)|(HU)|(ID)|(IE)|(IL)|(IN)|(IO)|(IQ)|(IR)|(IS)|(IT)|(JM)|(JO)|(JP)|(KE)|(KG)|(KH)|(KI)|(KM)|(KN)|(KP)|(KR)|(KW)|(KY)|(KZ)|(LA)|(LB)|(LC)|(LI)|(LK)|(LR)|(LS)|(LT)|(LU)|(LV)|(LY)|(MA)|(MC)|(MD)|(ME)|(MG)|(MH)|(MK)|(ML)|(MM)|(MN)|(MO)|(MP)|(MQ)|(MR)|(MS)|(MT)|(MU)|(MV)|(MW)|(MX)|(MY)|(MZ)|(NA)|(NC)|(NE)|(NF)|(NG)|(NI)|(NL)|(NO)|(NP)|(NR)|(NU)|(NZ)|(OM)|(PA)|(PE)|(PF)|(PG)|(PH)|(PK)|(PL)|(PM)|(PN)|(PR)|(PS)|(PT)|(PW)|(PY)|(QA)|(RE)|(RO)|(RU)|(RW)|(SA)|(SB)|(SC)|(SD)|(SE)|(SG)|(SH)|(SI)|(SJ)|(SK)|(SL)|(SM)|(SN)|(SO)|(SR)|(ST)|(SV)|(SY)|(SZ)|(TC)|(TD)|(TF)|(TG)|(TH)|(TJ)|(TK)|(TL)|(TM)|(TN)|(TO)|(TP)|(TR)|(TT)|(TV)|(TW)|(TZ)|(UA)|(UG)|(UM)|(US)|(UY)|(UZ)|(VA)|(VC)|(VE)|(VG)|(VI)|(VN)|(VU)|(WF)|(WS)|(XS)|(YE)|(YT)|(YU)|(ZA)|(ZM)|(ZW)|(XK)
• DateFormat - YYYYMMDD:^(19|20)\d\d(0[1-9]|1[012])(0[1-9]|[12][0-9]|3[01])$
• Telephone:\d{5,26}
• Kunden_KartenNummer:\d{12,12}

Chuẩn 2:

• AlphabetNotSpaceUpperCase: [A-Z]+
• CharacterNotSpaceUpperCase: [0-9,A-Z]+
• NumericNotSpace: [0-9]+
• Vorname: [^0-9,~,!,@,#,$,%,^,&,*,(,),_,+,|,},{,",:,?,>,<,`,=,\,;,/,,,\[,\]]+
• Nachname: [^0-9,~,!,@,#,$,%,^,&,*,(,),_,+,|,},{,",:,?,>,<,`,=,\,;,/,,,\[,\]]+
• Anrede: (1)|(2)|(Frau)|(Herr)
• NotSpecialCharacters: [^~,!,@,#,$,%,^,&,*,(,),_,+,|,},{,",:,?,>,<,`,=,\,',;,,,\[,\]]+
• Email: [_a-zA-Z0-9-öäü@ .-]+
• Email: /^([a-zA-Z0-9_.-])+@([a-zA-Z0-9_.-])+\.([a-zA-Z])+([a-zA-Z])+/ 
• DateFormat - DDMMYYYY: ^(0[1-9]|[12][0-9]|3[01])(0[1-9]|1[012])(19|20)\d\d$
• Strasse: [^~,!,@,#,$,%,^,&,*,(,),_,+,|,},{,",:,?,>,<,`,=,\,;,,,\[,\]]+ 10 PLZ (.{0})|([\d]{4,5})|([\d]{4}[ ][A-Z]{2})|([A-Z][\d][ ][\d][A-Z]{2})|([A-Z][\d]{2}[ ][\d][A-Z]{2})|([A-Z][\d][A-Z][ ][\d][A-Z]{2})|([A-Z]{2}[\d][ ][\d][A-Z]{2})|([A-Z]{2}[\d]{2}[ ][\d][A-Z]{2})|([A-Z]{2}[\d][A-Z][ ][\d][A-Z]{2})|([\d]{4}[\-][\d]{3})|([A-Z][\d][A-Z][ ][\d][A-Z][\d])|([A-Z][\d]{4}[A-Z]{3})|([A-Z]{3}[ ][\d]{2})
• IA_CODE: [\+][\d]{2,3}|[\d]{4,5}
• AREA_PHONE: [\d]{3,10}
• PHONE_NUM: [\d]{3,30}

Chuẩn 3:

• Unreadable Pattern: [1]
• Number Pattern: [\d]+
• FormID Pattern: [0-9a-zA-Z]{8}
• Gender Pattern: (1)|(2)|(Frau)|(Herr)
• Alphabet Pattern: [^0-9,~,!,@,#,$,%,^,&,*,(,),_,+,|,},{,",:,?,>,<,=,\,;,/,,,\[,\]]+ 5 
• Zip Pattern: ([\d]{5}-[\d]{4})|([\d]{2}-[\d]{3})|([\d]{4,6})|([\d]{4}[ ][A-Z]{2})|([A-Z][\d][ ][\d][A-Z]{2})|([A-Z][\d]{2}[ ][\d][A-Z]{2})|([A-Z][\d][A-Z][ ][\d][A-Z]{2})|([A-Z]{2}[\d][ ][\d][A-Z]{2})|([A-Z]{2}[\d]{2}[ ][\d][A-Z]{2})|([A-Z]{2}[\d][A-Z][ ][\d][A-Z]{2})|([\d]{4}[-][\d]{3})|([A-Z][\d][A-Z][ ][\d][A-Z][\d])|([A-Z][\d]{4}[A-Z]{3})|([A-Z]{3}[ ][\d]{2}) 6 
• Characters Pattern:[^~,!,@,#,$,%,^,&,*,(,),_,+,|,},{,",:,?,>,<,`,=,\,',;,,,\[,\]]+
• Street Pattern: [^~,!,@,#,$,%,^,&,*,(,),_,+,|,},{,",:,?,>,<,`,=,\,,;,,,\[,\]]+
• Email Pattern:[0-9a-z@_.-]+ 8 Phone Pattern [\d]{1,30}
• Boolean Pattern:(True)|(False) 10 Boolean Number Pattern [1]|[0] 11 ArticleID [\d]{9}
• AreaCode Phone Pattern:[\d]{1,10}
• House Pattern:[^~,!,@,#,$,%,^,&,*,(,),_,+,|,},{,",:,?,>,<,`,=,\,',;,,,\[,\]]+
• InternationalAreaCode: [\+][\d]{2,3}|[\d]{4,5}

Write: +Bui Ngoc Son