NI Number Validation - Revision history

WikiSysop at 17:11, 11 August 2013

2013-08-11T17:11:29Z

← Older revision		Revision as of 17:11, 11 August 2013
Line 118:		Line 118:
	\|CA\|CB\|CE\|CH\|CK\|CL\|EA\|EB\|EE\|EH\|EK\|EL\|EM\|EP\|ER\|ES\|ET\|EW\|EX\|EY\|EZ\|GY		\|CA\|CB\|CE\|CH\|CK\|CL\|EA\|EB\|EE\|EH\|EK\|EL\|EM\|EP\|ER\|ES\|ET\|EW\|EX\|EY\|EZ\|GY
	\|HA\|HB\|HE\|HH\|HK\|HL\|HM\|HP\|HR\|HS\|HT\|HW\|HX\|HY\|HZ		\|HA\|HB\|HE\|HH\|HK\|HL\|HM\|HP\|HR\|HS\|HT\|HW\|HX\|HY\|HZ
-	\|JA\|JB\|JC\|JE\|JG\|JH\|JJ\|JK\|JL\|JM\|JN\|JP\|JR\|JS\|JT\|JW\|JX\|JY\|JZ\|KA\|KB\|KE\|KH\|KK\|KL\|KM\|KP\|KR\|KS\|KT\|KW\|KX\|KY\|KZ	+	\|JA\|JB\|JC\|JE\|JG\|JH\|JJ\|JK\|JL\|JM\|JN\|JP\|JR\|JS\|JT\|JW\|JX\|JY\|JZ
-	\|LA\|LB\|LE\|LH\|LK\|LL\|LM\|LP\|LR\|LS\|LT\|LW\|LX\|LY\|LZ\|MA\|MX\|NA\|NB\|NE\|NH\|NL\|NM\|NP\|NR\|NS\|NW\|NX\|NY\|NZ	+	\|KA\|KB\|KE\|KH\|KK\|KL\|KM\|KP\|KR\|KS\|KT\|KW\|KX\|KY\|KZ
-	\|OA\|OB\|OE\|OH\|OK\|OL\|OM\|OP\|OR\|OS\|OX\|PA\|PB\|PC\|PE\|PG\|PH\|PJ\|PK\|PL\|PM\|PN\|PR\|PS\|PT\|PW\|PX	+	\|LA\|LB\|LE\|LH\|LK\|LL\|LM\|LP\|LR\|LS\|LT\|LW\|LX\|LY\|LZ\|MA\|MX
-	\|RA\|RB\|RE\|RH\|RK\|RM\|RP\|RR\|RS\|RT\|RW\|RX\|RY\|RZ\|SA\|SB\|SC\|SE\|SG\|SH\|SJ\|SK\|SL\|SM\|SN\|SP\|SR\|SS\|ST\|SW\|SX\|SY\|SZ	+	\|NA\|NB\|NE\|NH\|NL\|NM\|NP\|NR\|NS\|NW\|NX\|NY\|NZ
		+	\|OA\|OB\|OE\|OH\|OK\|OL\|OM\|OP\|OR\|OS\|OX
		+	\|PA\|PB\|PC\|PE\|PG\|PH\|PJ\|PK\|PL\|PM\|PN\|PR\|PS\|PT\|PW\|PX
		+	\|RA\|RB\|RE\|RH\|RK\|RM\|RP\|RR\|RS\|RT\|RW\|RX\|RY\|RZ
		+	\|SA\|SB\|SC\|SE\|SG\|SH\|SJ\|SK\|SL\|SM\|SN\|SP\|SR\|SS\|ST\|SW\|SX\|SY\|SZ
	\|TA\|TB\|TE\|TH\|TK\|TL\|TM\|TP\|TR\|TS\|TT\|TW\|TX\|TY\|TZ\|WA\|WB\|WE\|WK\|WL\|WM\|WP		\|TA\|TB\|TE\|TH\|TK\|TL\|TM\|TP\|TR\|TS\|TT\|TW\|TX\|TY\|TZ\|WA\|WB\|WE\|WK\|WL\|WM\|WP
-	\|YA\|YB\|YE\|YH\|YK\|YL\|YM\|YP\|YR\|YS\|YT\|YW\|YX\|YY\|YZ\|ZA\|ZB\|ZE\|ZH\|ZK\|ZL\|ZM\|ZP\|ZR\|ZS\|ZT\|ZW\|ZX\|ZY)[0-9]{6}[A-D]	+	\|YA\|YB\|YE\|YH\|YK\|YL\|YM\|YP\|YR\|YS\|YT\|YW\|YX\|YY\|YZ
		+	\|ZA\|ZB\|ZE\|ZH\|ZK\|ZL\|ZM\|ZP\|ZR\|ZS\|ZT\|ZW\|ZX\|ZY)[0-9]{6}[A-D]
	</pre>		</pre>
	It should be noted that this expression would need to be updated with new prefixes as they are introduced by HMRC.		It should be noted that this expression would need to be updated with new prefixes as they are introduced by HMRC.

WikiSysop at 17:03, 11 August 2013

2013-08-11T17:03:08Z

← Older revision		Revision as of 17:03, 11 August 2013
Line 116:		Line 116:
	<pre>		<pre>
	(AA\|AB\|AE\|AH\|AK\|AL\|AM\|AP\|AR\|AS\|AT\|AW\|AX\|AY\|AZ\|BA\|BB\|BE\|BH\|BK\|BL\|BM\|BT		(AA\|AB\|AE\|AH\|AK\|AL\|AM\|AP\|AR\|AS\|AT\|AW\|AX\|AY\|AZ\|BA\|BB\|BE\|BH\|BK\|BL\|BM\|BT
-	\|CA\|CB\|CE\|CH\|CK\|CL	+	\|CA\|CB\|CE\|CH\|CK\|CL\|EA\|EB\|EE\|EH\|EK\|EL\|EM\|EP\|ER\|ES\|ET\|EW\|EX\|EY\|EZ\|GY
-	\|EA\|EB\|EE\|EH\|EK\|EL\|EM\|EP\|ER\|ES\|ET\|EW\|EX\|EY\|EZ\|GY\|HA\|HB\|HE\|HH\|HK\|HL\|HM\|HP\|HR\|HS\|HT\|HW\|HX\|HY\|HZ	+	\|HA\|HB\|HE\|HH\|HK\|HL\|HM\|HP\|HR\|HS\|HT\|HW\|HX\|HY\|HZ
	\|JA\|JB\|JC\|JE\|JG\|JH\|JJ\|JK\|JL\|JM\|JN\|JP\|JR\|JS\|JT\|JW\|JX\|JY\|JZ\|KA\|KB\|KE\|KH\|KK\|KL\|KM\|KP\|KR\|KS\|KT\|KW\|KX\|KY\|KZ		\|JA\|JB\|JC\|JE\|JG\|JH\|JJ\|JK\|JL\|JM\|JN\|JP\|JR\|JS\|JT\|JW\|JX\|JY\|JZ\|KA\|KB\|KE\|KH\|KK\|KL\|KM\|KP\|KR\|KS\|KT\|KW\|KX\|KY\|KZ
	\|LA\|LB\|LE\|LH\|LK\|LL\|LM\|LP\|LR\|LS\|LT\|LW\|LX\|LY\|LZ\|MA\|MX\|NA\|NB\|NE\|NH\|NL\|NM\|NP\|NR\|NS\|NW\|NX\|NY\|NZ		\|LA\|LB\|LE\|LH\|LK\|LL\|LM\|LP\|LR\|LS\|LT\|LW\|LX\|LY\|LZ\|MA\|MX\|NA\|NB\|NE\|NH\|NL\|NM\|NP\|NR\|NS\|NW\|NX\|NY\|NZ

WikiSysop at 17:00, 11 August 2013

2013-08-11T17:00:31Z

← Older revision		Revision as of 17:00, 11 August 2013
Line 96:		Line 96:
	GY		GY
	HA, HB, HE, HH, HK, HL, HM, HP, HR, HS, HT, HW, HX, HY, HZ		HA, HB, HE, HH, HK, HL, HM, HP, HR, HS, HT, HW, HX, HY, HZ
-	JA, JB, JC, JE, JG, JH, JJ, JK, JL, JM, JN, JP, JR, JS, JT, JW, JX, JY, JZ	+	JA, JB, JC, JE, JG, JH, JJ, JK, JL, JM, JN, JP, JR, JS, JT, JW,
		+	JX, JY, JZ
	KA, KB, KE, KH, KK, KL, KM, KP, KR, KS, KT, KW, KX, KY, KZ		KA, KB, KE, KH, KK, KL, KM, KP, KR, KS, KT, KW, KX, KY, KZ
	LA, LB, LE, LH, LK, LL, LM, LP, LR, LS, LT, LW, LX, LY, LZ		LA, LB, LE, LH, LK, LL, LM, LP, LR, LS, LT, LW, LX, LY, LZ
Line 104:		Line 105:
	PA, PB, PC, PE, PG, PH, PJ, PK, PL, PM, PN, PP, PR, PS, PT, PW, PX, PY		PA, PB, PC, PE, PG, PH, PJ, PK, PL, PM, PN, PP, PR, PS, PT, PW, PX, PY
	RA, RB, RE, RH, RK, RM, RP, RR, RS, RT, RW, RX, RY, RZ		RA, RB, RE, RH, RK, RM, RP, RR, RS, RT, RW, RX, RY, RZ
-	SA, SB, SC, SE, SG, SH, SJ, SK, SL, SM, SN, SP, SR, SS, ST, SW, SX, SY ,SZ	+	SA, SB, SC, SE, SG, SH, SJ, SK, SL, SM, SN, SP, SR, SS, ST, SW,
		+	SX, SY ,SZ
	TA, TB, TE, TH, TK, TL, TM, TP, TR, TS, TT, TW, TX, TY, TZ		TA, TB, TE, TH, TK, TL, TM, TP, TR, TS, TT, TW, TX, TY, TZ
	WA, WB, WE, WK, WL, WM, WP		WA, WB, WE, WK, WL, WM, WP
Line 113:		Line 115:
	If you need to be this precise, the regular expression is simpler, but longer (the administrative prefixes removed, new lines added purely to fit the page):		If you need to be this precise, the regular expression is simpler, but longer (the administrative prefixes removed, new lines added purely to fit the page):
	<pre>		<pre>
-	(AA\|AB\|AE\|AH\|AK\|AL\|AM\|AP\|AR\|AS\|AT\|AW\|AX\|AY\|AZ\|BA\|BB\|BE\|BH\|BK\|BL\|BM\|BT\|CA\|CB\|CE\|CH\|CK\|CL	+	(AA\|AB\|AE\|AH\|AK\|AL\|AM\|AP\|AR\|AS\|AT\|AW\|AX\|AY\|AZ\|BA\|BB\|BE\|BH\|BK\|BL\|BM\|BT
		+	\|CA\|CB\|CE\|CH\|CK\|CL
	\|EA\|EB\|EE\|EH\|EK\|EL\|EM\|EP\|ER\|ES\|ET\|EW\|EX\|EY\|EZ\|GY\|HA\|HB\|HE\|HH\|HK\|HL\|HM\|HP\|HR\|HS\|HT\|HW\|HX\|HY\|HZ		\|EA\|EB\|EE\|EH\|EK\|EL\|EM\|EP\|ER\|ES\|ET\|EW\|EX\|EY\|EZ\|GY\|HA\|HB\|HE\|HH\|HK\|HL\|HM\|HP\|HR\|HS\|HT\|HW\|HX\|HY\|HZ
	\|JA\|JB\|JC\|JE\|JG\|JH\|JJ\|JK\|JL\|JM\|JN\|JP\|JR\|JS\|JT\|JW\|JX\|JY\|JZ\|KA\|KB\|KE\|KH\|KK\|KL\|KM\|KP\|KR\|KS\|KT\|KW\|KX\|KY\|KZ		\|JA\|JB\|JC\|JE\|JG\|JH\|JJ\|JK\|JL\|JM\|JN\|JP\|JR\|JS\|JT\|JW\|JX\|JY\|JZ\|KA\|KB\|KE\|KH\|KK\|KL\|KM\|KP\|KR\|KS\|KT\|KW\|KX\|KY\|KZ
Line 133:		Line 136:
	<pre>		<pre>
	([ABEGHJ-LORSW-Z][ABCEGHJ-NPRSTW-Z])\|(C[ABCEGHJ-NPSTW-Z])		([ABEGHJ-LORSW-Z][ABCEGHJ-NPRSTW-Z])\|(C[ABCEGHJ-NPSTW-Z])
-	\|(M[ABCEGHJ-NPRSTX-Z])\|(N[ABEGHJ-NPRSTW-Z])\|(P[ABCEGHJ-NRSTWX])\|(T[ABCEGHJ-MPRSTW-Z])[0-9]{6}[A-D]	+	\|(M[ABCEGHJ-NPRSTX-Z])\|(N[ABEGHJ-NPRSTW-Z])
		+	\|(P[ABCEGHJ-NRSTWX])\|(T[ABCEGHJ-MPRSTW-Z])[0-9]{6}[A-D]
	</pre>		</pre>

WikiSysop at 16:57, 11 August 2013

2013-08-11T16:57:17Z

← Older revision		Revision as of 16:57, 11 August 2013
Line 83:		Line 83:
	Using each of the exception patterns from the table above, the regular expression to validate employee payroll NI numbers is (new lines are to fit page only):		Using each of the exception patterns from the table above, the regular expression to validate employee payroll NI numbers is (new lines are to fit page only):
	<pre>		<pre>
-	([ABEGHJ-LORSW-Z][ABCEGHJ-NPRSTW-Z])\|(C[ABCEGHJ-NPSTW-Z])\|(M[ABCEGHJ-NPRSTX-Z])	+	([ABEGHJ-LORSW-Z][ABCEGHJ-NPRSTW-Z])\|(C[ABCEGHJ-NPSTW-Z])
-	\|(N[ABEGHJ-NPRSTW-Z])\|(P[ABCEGHJ-NRSTWX])\|(T[ABCEGHJ-MPRSTW-Z])[0-9]{6}[A-D]	+	\|(M[ABCEGHJ-NPRSTX-Z])\|(N[ABEGHJ-NPRSTW-Z])\|(P[ABCEGHJ-NRSTWX])
		+	\|(T[ABCEGHJ-MPRSTW-Z])[0-9]{6}[A-D]
	</pre>		</pre>

WikiSysop at 23:27, 10 August 2013

2013-08-10T23:27:00Z

← Older revision		Revision as of 23:27, 10 August 2013
Line 81:		Line 81:
	We can exclude these administrative prefixes by adding a specific expression for each prefix, e.g. allowing CA, but not allowing CR.		We can exclude these administrative prefixes by adding a specific expression for each prefix, e.g. allowing CA, but not allowing CR.

-	Using each of the exception patterns from the table above, the regular expression to validate employee payroll NI numbers is:	+	Using each of the exception patterns from the table above, the regular expression to validate employee payroll NI numbers is (new lines are to fit page only):
	<pre>		<pre>
-	([ABEGHJ-LORSW-Z][ABCEGHJ-NPRSTW-Z])\|(C[ABCEGHJ-NPSTW-Z])\|(M[ABCEGHJ-NPRSTX-Z])\|(N[ABEGHJ-NPRSTW-Z])\|(P[ABCEGHJ-NRSTWX])\|(T[ABCEGHJ-MPRSTW-Z])[0-9]{6}[A-D]	+	([ABEGHJ-LORSW-Z][ABCEGHJ-NPRSTW-Z])\|(C[ABCEGHJ-NPSTW-Z])\|(M[ABCEGHJ-NPRSTX-Z])
		+	\|(N[ABEGHJ-NPRSTW-Z])\|(P[ABCEGHJ-NRSTWX])\|(T[ABCEGHJ-MPRSTW-Z])[0-9]{6}[A-D]
	</pre>		</pre>

Line 109:		Line 110:
	</pre>		</pre>

-	If you need to be this precise, the regular expression is simpler, but longer (the administrative prefixes removed):	+	If you need to be this precise, the regular expression is simpler, but longer (the administrative prefixes removed, new lines added purely to fit the page):
	<pre>		<pre>
-	(AA\|AB\|AE\|AH\|AK\|AL\|AM\|AP\|AR\|AS\|AT\|AW\|AX\|AY\|AZ\|BA\|BB\|BE\|BH\|BK\|BL\|BM\|BT\|CA\|CB\|CE\|CH\|CK\|CL\|EA\|EB\|EE\|EH\|EK\|EL\|EM\|EP\|ER\|ES\|ET\|EW\|EX\|EY\|EZ\|GY\|HA\|HB\|HE\|HH\|HK\|HL\|HM\|HP\|HR\|HS\|HT\|HW\|HX\|HY\|HZ\|JA\|JB\|JC\|JE\|JG\|JH\|JJ\|JK\|JL\|JM\|JN\|JP\|JR\|JS\|JT\|JW\|JX\|JY\|JZ\|KA\|KB\|KE\|KH\|KK\|KL\|KM\|KP\|KR\|KS\|KT\|KW\|KX\|KY\|KZ\|LA\|LB\|LE\|LH\|LK\|LL\|LM\|LP\|LR\|LS\|LT\|LW\|LX\|LY\|LZ\|MA\|MX\|NA\|NB\|NE\|NH\|NL\|NM\|NP\|NR\|NS\|NW\|NX\|NY\|NZ\|OA\|OB\|OE\|OH\|OK\|OL\|OM\|OP\|OR\|OS\|OX\|PA\|PB\|PC\|PE\|PG\|PH\|PJ\|PK\|PL\|PM\|PN\|PR\|PS\|PT\|PW\|PX\|RA\|RB\|RE\|RH\|RK\|RM\|RP\|RR\|RS\|RT\|RW\|RX\|RY\|RZ\|SA\|SB\|SC\|SE\|SG\|SH\|SJ\|SK\|SL\|SM\|SN\|SP\|SR\|SS\|ST\|SW\|SX\|SY\|SZ\|TA\|TB\|TE\|TH\|TK\|TL\|TM\|TP\|TR\|TS\|TT\|TW\|TX\|TY\|TZ\|WA\|WB\|WE\|WK\|WL\|WM\|WP\|YA\|YB\|YE\|YH\|YK\|YL\|YM\|YP\|YR\|YS\|YT\|YW\|YX\|YY\|YZ\|ZA\|ZB\|ZE\|ZH\|ZK\|ZL\|ZM\|ZP\|ZR\|ZS\|ZT\|ZW\|ZX\|ZY)[0-9]{6}[A-D]	+	(AA\|AB\|AE\|AH\|AK\|AL\|AM\|AP\|AR\|AS\|AT\|AW\|AX\|AY\|AZ\|BA\|BB\|BE\|BH\|BK\|BL\|BM\|BT\|CA\|CB\|CE\|CH\|CK\|CL
		+	\|EA\|EB\|EE\|EH\|EK\|EL\|EM\|EP\|ER\|ES\|ET\|EW\|EX\|EY\|EZ\|GY\|HA\|HB\|HE\|HH\|HK\|HL\|HM\|HP\|HR\|HS\|HT\|HW\|HX\|HY\|HZ
		+	\|JA\|JB\|JC\|JE\|JG\|JH\|JJ\|JK\|JL\|JM\|JN\|JP\|JR\|JS\|JT\|JW\|JX\|JY\|JZ\|KA\|KB\|KE\|KH\|KK\|KL\|KM\|KP\|KR\|KS\|KT\|KW\|KX\|KY\|KZ
		+	\|LA\|LB\|LE\|LH\|LK\|LL\|LM\|LP\|LR\|LS\|LT\|LW\|LX\|LY\|LZ\|MA\|MX\|NA\|NB\|NE\|NH\|NL\|NM\|NP\|NR\|NS\|NW\|NX\|NY\|NZ
		+	\|OA\|OB\|OE\|OH\|OK\|OL\|OM\|OP\|OR\|OS\|OX\|PA\|PB\|PC\|PE\|PG\|PH\|PJ\|PK\|PL\|PM\|PN\|PR\|PS\|PT\|PW\|PX
		+	\|RA\|RB\|RE\|RH\|RK\|RM\|RP\|RR\|RS\|RT\|RW\|RX\|RY\|RZ\|SA\|SB\|SC\|SE\|SG\|SH\|SJ\|SK\|SL\|SM\|SN\|SP\|SR\|SS\|ST\|SW\|SX\|SY\|SZ
		+	\|TA\|TB\|TE\|TH\|TK\|TL\|TM\|TP\|TR\|TS\|TT\|TW\|TX\|TY\|TZ\|WA\|WB\|WE\|WK\|WL\|WM\|WP
		+	\|YA\|YB\|YE\|YH\|YK\|YL\|YM\|YP\|YR\|YS\|YT\|YW\|YX\|YY\|YZ\|ZA\|ZB\|ZE\|ZH\|ZK\|ZL\|ZM\|ZP\|ZR\|ZS\|ZT\|ZW\|ZX\|ZY)[0-9]{6}[A-D]
	</pre>		</pre>
		+	It should be noted that this expression would need to be updated with new prefixes as they are introduced by HMRC.
		+
	==Summary==		==Summary==

Line 121:		Line 131:
	The key validation for current employee payroll NI Numbers would be:		The key validation for current employee payroll NI Numbers would be:
	<pre>		<pre>
-	([ABEGHJ-LORSW-Z][ABCEGHJ-NPRSTW-Z])\|(C[ABCEGHJ-NPSTW-Z])\|(M[ABCEGHJ-NPRSTX-Z])\|(N[ABEGHJ-NPRSTW-Z])\|(P[ABCEGHJ-NRSTWX])\|(T[ABCEGHJ-MPRSTW-Z])[0-9]{6}[A-D]	+	([ABEGHJ-LORSW-Z][ABCEGHJ-NPRSTW-Z])\|(C[ABCEGHJ-NPSTW-Z])
		+	\|(M[ABCEGHJ-NPRSTX-Z])\|(N[ABEGHJ-NPRSTW-Z])\|(P[ABCEGHJ-NRSTWX])\|(T[ABCEGHJ-MPRSTW-Z])[0-9]{6}[A-D]
	</pre>		</pre>
-	~~A slightly longer, but more exact expression would be:~~
-	~~<pre>~~
-	(AA\|AB\|AE\|AH\|AK\|AL\|AM\|AP\|AR\|AS\|AT\|AW\|AX\|AY\|AZ\|BA\|BB\|BE\|BH\|BK\|BL\|BM\|BT\|CA\|CB\|CE\|CH\|CK\|CL\|EA\|EB\|EE\|EH\|EK\|EL\|EM\|EP\|ER\|ES\|ET\|EW\|EX\|EY\|EZ\|GY\|HA\|HB\|HE\|HH\|HK\|HL\|HM\|HP\|HR\|HS\|HT\|HW\|HX\|HY\|HZ\|JA\|JB\|JC\|JE\|JG\|JH\|JJ\|JK\|JL\|JM\|JN\|JP\|JR\|JS\|JT\|JW\|JX\|JY\|JZ\|KA\|KB\|KE\|KH\|KK\|KL\|KM\|KP\|KR\|KS\|KT\|KW\|KX\|KY\|KZ\|LA\|LB\|LE\|LH\|LK\|LL\|LM\|LP\|LR\|LS\|LT\|LW\|LX\|LY\|LZ\|MA\|MX\|NA\|NB\|NE\|NH\|NL\|NM\|NP\|NR\|NS\|NW\|NX\|NY\|NZ\|OA\|OB\|OE\|OH\|OK\|OL\|OM\|OP\|OR\|OS\|OX\|PA\|PB\|PC\|PE\|PG\|PH\|PJ\|PK\|PL\|PM\|PN\|PR\|PS\|PT\|PW\|PX\|RA\|RB\|RE\|RH\|RK\|RM\|RP\|RR\|RS\|RT\|RW\|RX\|RY\|RZ\|SA\|SB\|SC\|SE\|SG\|SH\|SJ\|SK\|SL\|SM\|SN\|SP\|SR\|SS\|ST\|SW\|SX\|SY\|SZ\|TA\|TB\|TE\|TH\|TK\|TL\|TM\|TP\|TR\|TS\|TT\|TW\|TX\|TY\|TZ\|WA\|WB\|WE\|WK\|WL\|WM\|WP\|YA\|YB\|YE\|YH\|YK\|YL\|YM\|YP\|YR\|YS\|YT\|YW\|YX\|YY\|YZ\|ZA\|ZB\|ZE\|ZH\|ZK\|ZL\|ZM\|ZP\|ZR\|ZS\|ZT\|ZW\|ZX\|ZY)[0-9]{6}[A-D]
-	~~</pre>~~
-	~~It should be noted that this expression would need to be updated with new prefixes as they are introduced by HMRC.~~

	Try out your regular expressions on the regular expression calculator: [http://www.homemarketeer.com/sbs/regular_expression.html Regular Expression Calculator]		Try out your regular expressions on the regular expression calculator: [http://www.homemarketeer.com/sbs/regular_expression.html Regular Expression Calculator]

WikiSysop at 23:12, 10 August 2013

2013-08-10T23:12:03Z

← Older revision		Revision as of 23:12, 10 August 2013
Line 6:		Line 6:

	The basic format is AA999999A, and a check for this format would be:		The basic format is AA999999A, and a check for this format would be:
-		+	<pre>
	[A-Z]{2}[0-9]{6}[A-Z]		[A-Z]{2}[0-9]{6}[A-Z]
-		+	</pre>
	If you are looking for National Insurance Numbers within some text and want to replace them with dummy text, this simple expression will probably meet your needs and catch some of the more exotic NI format numbers that might also need to be replaced.		If you are looking for National Insurance Numbers within some text and want to replace them with dummy text, this simple expression will probably meet your needs and catch some of the more exotic NI format numbers that might also need to be replaced.

Line 19:		Line 19:
	The first letter cannot be D, F, I, Q, U or V.		The first letter cannot be D, F, I, Q, U or V.
	The second letter cannot be D, F, I, O, Q, U and V.		The second letter cannot be D, F, I, O, Q, U and V.
-		+	<pre>
	[ABCEGHJ-PR-TW-Z][ABCEGHJ-NPR-TW-Z][0-9]{6}[A-D]		[ABCEGHJ-PR-TW-Z][ABCEGHJ-NPR-TW-Z][0-9]{6}[A-D]
-		+	</pre>
	Additionally, there are certain combinations of prefix letters that have been used for administrative purposes and so are not assignable to individuals on a payroll:		Additionally, there are certain combinations of prefix letters that have been used for administrative purposes and so are not assignable to individuals on a payroll:

Line 82:		Line 82:

	Using each of the exception patterns from the table above, the regular expression to validate employee payroll NI numbers is:		Using each of the exception patterns from the table above, the regular expression to validate employee payroll NI numbers is:
-		+	<pre>
	([ABEGHJ-LORSW-Z][ABCEGHJ-NPRSTW-Z])\|(C[ABCEGHJ-NPSTW-Z])\|(M[ABCEGHJ-NPRSTX-Z])\|(N[ABEGHJ-NPRSTW-Z])\|(P[ABCEGHJ-NRSTWX])\|(T[ABCEGHJ-MPRSTW-Z])[0-9]{6}[A-D]		([ABEGHJ-LORSW-Z][ABCEGHJ-NPRSTW-Z])\|(C[ABCEGHJ-NPSTW-Z])\|(M[ABCEGHJ-NPRSTX-Z])\|(N[ABEGHJ-NPRSTW-Z])\|(P[ABCEGHJ-NRSTWX])\|(T[ABCEGHJ-MPRSTW-Z])[0-9]{6}[A-D]
-		+	</pre>

	From time to time, HMRC publish the list of prefixes in use. This list gradually grows and so if you need this level of accuracy, you would need to be update your regular expression each time HMRC need to increase the list. The following list was supplied in the RTI specification (30th September 2011) - note that it contains some administrative prefixes:		From time to time, HMRC publish the list of prefixes in use. This list gradually grows and so if you need this level of accuracy, you would need to be update your regular expression each time HMRC need to increase the list. The following list was supplied in the RTI specification (30th September 2011) - note that it contains some administrative prefixes:
-		+	<pre>
	AA, AB, AE, AH, AK, AL, AM, AP, AR, AS, AT, AW, AX, AY, AZ		AA, AB, AE, AH, AK, AL, AM, AP, AR, AS, AT, AW, AX, AY, AZ
	BA, BB, BE, BH, BK, BL, BM, BT		BA, BB, BE, BH, BK, BL, BM, BT
Line 107:		Line 107:
	YA, YB, YE, YH, YK, YL, YM, YP, YR, YS, YT, YW, YX, YY, YZ		YA, YB, YE, YH, YK, YL, YM, YP, YR, YS, YT, YW, YX, YY, YZ
	ZA, ZB, ZE, ZH, ZK, ZL, ZM, ZP, ZR, ZS, ZT, ZW, ZX, ZY		ZA, ZB, ZE, ZH, ZK, ZL, ZM, ZP, ZR, ZS, ZT, ZW, ZX, ZY
-		+	</pre>

	If you need to be this precise, the regular expression is simpler, but longer (the administrative prefixes removed):		If you need to be this precise, the regular expression is simpler, but longer (the administrative prefixes removed):
-		+	<pre>
	(AA\|AB\|AE\|AH\|AK\|AL\|AM\|AP\|AR\|AS\|AT\|AW\|AX\|AY\|AZ\|BA\|BB\|BE\|BH\|BK\|BL\|BM\|BT\|CA\|CB\|CE\|CH\|CK\|CL\|EA\|EB\|EE\|EH\|EK\|EL\|EM\|EP\|ER\|ES\|ET\|EW\|EX\|EY\|EZ\|GY\|HA\|HB\|HE\|HH\|HK\|HL\|HM\|HP\|HR\|HS\|HT\|HW\|HX\|HY\|HZ\|JA\|JB\|JC\|JE\|JG\|JH\|JJ\|JK\|JL\|JM\|JN\|JP\|JR\|JS\|JT\|JW\|JX\|JY\|JZ\|KA\|KB\|KE\|KH\|KK\|KL\|KM\|KP\|KR\|KS\|KT\|KW\|KX\|KY\|KZ\|LA\|LB\|LE\|LH\|LK\|LL\|LM\|LP\|LR\|LS\|LT\|LW\|LX\|LY\|LZ\|MA\|MX\|NA\|NB\|NE\|NH\|NL\|NM\|NP\|NR\|NS\|NW\|NX\|NY\|NZ\|OA\|OB\|OE\|OH\|OK\|OL\|OM\|OP\|OR\|OS\|OX\|PA\|PB\|PC\|PE\|PG\|PH\|PJ\|PK\|PL\|PM\|PN\|PR\|PS\|PT\|PW\|PX\|RA\|RB\|RE\|RH\|RK\|RM\|RP\|RR\|RS\|RT\|RW\|RX\|RY\|RZ\|SA\|SB\|SC\|SE\|SG\|SH\|SJ\|SK\|SL\|SM\|SN\|SP\|SR\|SS\|ST\|SW\|SX\|SY\|SZ\|TA\|TB\|TE\|TH\|TK\|TL\|TM\|TP\|TR\|TS\|TT\|TW\|TX\|TY\|TZ\|WA\|WB\|WE\|WK\|WL\|WM\|WP\|YA\|YB\|YE\|YH\|YK\|YL\|YM\|YP\|YR\|YS\|YT\|YW\|YX\|YY\|YZ\|ZA\|ZB\|ZE\|ZH\|ZK\|ZL\|ZM\|ZP\|ZR\|ZS\|ZT\|ZW\|ZX\|ZY)[0-9]{6}[A-D]		(AA\|AB\|AE\|AH\|AK\|AL\|AM\|AP\|AR\|AS\|AT\|AW\|AX\|AY\|AZ\|BA\|BB\|BE\|BH\|BK\|BL\|BM\|BT\|CA\|CB\|CE\|CH\|CK\|CL\|EA\|EB\|EE\|EH\|EK\|EL\|EM\|EP\|ER\|ES\|ET\|EW\|EX\|EY\|EZ\|GY\|HA\|HB\|HE\|HH\|HK\|HL\|HM\|HP\|HR\|HS\|HT\|HW\|HX\|HY\|HZ\|JA\|JB\|JC\|JE\|JG\|JH\|JJ\|JK\|JL\|JM\|JN\|JP\|JR\|JS\|JT\|JW\|JX\|JY\|JZ\|KA\|KB\|KE\|KH\|KK\|KL\|KM\|KP\|KR\|KS\|KT\|KW\|KX\|KY\|KZ\|LA\|LB\|LE\|LH\|LK\|LL\|LM\|LP\|LR\|LS\|LT\|LW\|LX\|LY\|LZ\|MA\|MX\|NA\|NB\|NE\|NH\|NL\|NM\|NP\|NR\|NS\|NW\|NX\|NY\|NZ\|OA\|OB\|OE\|OH\|OK\|OL\|OM\|OP\|OR\|OS\|OX\|PA\|PB\|PC\|PE\|PG\|PH\|PJ\|PK\|PL\|PM\|PN\|PR\|PS\|PT\|PW\|PX\|RA\|RB\|RE\|RH\|RK\|RM\|RP\|RR\|RS\|RT\|RW\|RX\|RY\|RZ\|SA\|SB\|SC\|SE\|SG\|SH\|SJ\|SK\|SL\|SM\|SN\|SP\|SR\|SS\|ST\|SW\|SX\|SY\|SZ\|TA\|TB\|TE\|TH\|TK\|TL\|TM\|TP\|TR\|TS\|TT\|TW\|TX\|TY\|TZ\|WA\|WB\|WE\|WK\|WL\|WM\|WP\|YA\|YB\|YE\|YH\|YK\|YL\|YM\|YP\|YR\|YS\|YT\|YW\|YX\|YY\|YZ\|ZA\|ZB\|ZE\|ZH\|ZK\|ZL\|ZM\|ZP\|ZR\|ZS\|ZT\|ZW\|ZX\|ZY)[0-9]{6}[A-D]
-		+	</pre>
-	Summary	+	==Summary==

	For simply looking for numbers potentially in NI number format, the following simple expression would suffice:		For simply looking for numbers potentially in NI number format, the following simple expression would suffice:
-		+	<pre>
	[A-Z]{2}[0-9]{6}[A-Z]		[A-Z]{2}[0-9]{6}[A-Z]
-		+	</pre>
	The key validation for current employee payroll NI Numbers would be:		The key validation for current employee payroll NI Numbers would be:
-		+	<pre>
	([ABEGHJ-LORSW-Z][ABCEGHJ-NPRSTW-Z])\|(C[ABCEGHJ-NPSTW-Z])\|(M[ABCEGHJ-NPRSTX-Z])\|(N[ABEGHJ-NPRSTW-Z])\|(P[ABCEGHJ-NRSTWX])\|(T[ABCEGHJ-MPRSTW-Z])[0-9]{6}[A-D]		([ABEGHJ-LORSW-Z][ABCEGHJ-NPRSTW-Z])\|(C[ABCEGHJ-NPSTW-Z])\|(M[ABCEGHJ-NPRSTX-Z])\|(N[ABEGHJ-NPRSTW-Z])\|(P[ABCEGHJ-NRSTWX])\|(T[ABCEGHJ-MPRSTW-Z])[0-9]{6}[A-D]
-		+	</pre>
	A slightly longer, but more exact expression would be:		A slightly longer, but more exact expression would be:
-		+	<pre>
	(AA\|AB\|AE\|AH\|AK\|AL\|AM\|AP\|AR\|AS\|AT\|AW\|AX\|AY\|AZ\|BA\|BB\|BE\|BH\|BK\|BL\|BM\|BT\|CA\|CB\|CE\|CH\|CK\|CL\|EA\|EB\|EE\|EH\|EK\|EL\|EM\|EP\|ER\|ES\|ET\|EW\|EX\|EY\|EZ\|GY\|HA\|HB\|HE\|HH\|HK\|HL\|HM\|HP\|HR\|HS\|HT\|HW\|HX\|HY\|HZ\|JA\|JB\|JC\|JE\|JG\|JH\|JJ\|JK\|JL\|JM\|JN\|JP\|JR\|JS\|JT\|JW\|JX\|JY\|JZ\|KA\|KB\|KE\|KH\|KK\|KL\|KM\|KP\|KR\|KS\|KT\|KW\|KX\|KY\|KZ\|LA\|LB\|LE\|LH\|LK\|LL\|LM\|LP\|LR\|LS\|LT\|LW\|LX\|LY\|LZ\|MA\|MX\|NA\|NB\|NE\|NH\|NL\|NM\|NP\|NR\|NS\|NW\|NX\|NY\|NZ\|OA\|OB\|OE\|OH\|OK\|OL\|OM\|OP\|OR\|OS\|OX\|PA\|PB\|PC\|PE\|PG\|PH\|PJ\|PK\|PL\|PM\|PN\|PR\|PS\|PT\|PW\|PX\|RA\|RB\|RE\|RH\|RK\|RM\|RP\|RR\|RS\|RT\|RW\|RX\|RY\|RZ\|SA\|SB\|SC\|SE\|SG\|SH\|SJ\|SK\|SL\|SM\|SN\|SP\|SR\|SS\|ST\|SW\|SX\|SY\|SZ\|TA\|TB\|TE\|TH\|TK\|TL\|TM\|TP\|TR\|TS\|TT\|TW\|TX\|TY\|TZ\|WA\|WB\|WE\|WK\|WL\|WM\|WP\|YA\|YB\|YE\|YH\|YK\|YL\|YM\|YP\|YR\|YS\|YT\|YW\|YX\|YY\|YZ\|ZA\|ZB\|ZE\|ZH\|ZK\|ZL\|ZM\|ZP\|ZR\|ZS\|ZT\|ZW\|ZX\|ZY)[0-9]{6}[A-D]		(AA\|AB\|AE\|AH\|AK\|AL\|AM\|AP\|AR\|AS\|AT\|AW\|AX\|AY\|AZ\|BA\|BB\|BE\|BH\|BK\|BL\|BM\|BT\|CA\|CB\|CE\|CH\|CK\|CL\|EA\|EB\|EE\|EH\|EK\|EL\|EM\|EP\|ER\|ES\|ET\|EW\|EX\|EY\|EZ\|GY\|HA\|HB\|HE\|HH\|HK\|HL\|HM\|HP\|HR\|HS\|HT\|HW\|HX\|HY\|HZ\|JA\|JB\|JC\|JE\|JG\|JH\|JJ\|JK\|JL\|JM\|JN\|JP\|JR\|JS\|JT\|JW\|JX\|JY\|JZ\|KA\|KB\|KE\|KH\|KK\|KL\|KM\|KP\|KR\|KS\|KT\|KW\|KX\|KY\|KZ\|LA\|LB\|LE\|LH\|LK\|LL\|LM\|LP\|LR\|LS\|LT\|LW\|LX\|LY\|LZ\|MA\|MX\|NA\|NB\|NE\|NH\|NL\|NM\|NP\|NR\|NS\|NW\|NX\|NY\|NZ\|OA\|OB\|OE\|OH\|OK\|OL\|OM\|OP\|OR\|OS\|OX\|PA\|PB\|PC\|PE\|PG\|PH\|PJ\|PK\|PL\|PM\|PN\|PR\|PS\|PT\|PW\|PX\|RA\|RB\|RE\|RH\|RK\|RM\|RP\|RR\|RS\|RT\|RW\|RX\|RY\|RZ\|SA\|SB\|SC\|SE\|SG\|SH\|SJ\|SK\|SL\|SM\|SN\|SP\|SR\|SS\|ST\|SW\|SX\|SY\|SZ\|TA\|TB\|TE\|TH\|TK\|TL\|TM\|TP\|TR\|TS\|TT\|TW\|TX\|TY\|TZ\|WA\|WB\|WE\|WK\|WL\|WM\|WP\|YA\|YB\|YE\|YH\|YK\|YL\|YM\|YP\|YR\|YS\|YT\|YW\|YX\|YY\|YZ\|ZA\|ZB\|ZE\|ZH\|ZK\|ZL\|ZM\|ZP\|ZR\|ZS\|ZT\|ZW\|ZX\|ZY)[0-9]{6}[A-D]
-		+	</pre>
	It should be noted that this expression would need to be updated with new prefixes as they are introduced by HMRC.		It should be noted that this expression would need to be updated with new prefixes as they are introduced by HMRC.

WikiSysop at 23:06, 10 August 2013

2013-08-10T23:06:51Z

← Older revision		Revision as of 23:06, 10 August 2013
Line 128:		Line 128:

	It should be noted that this expression would need to be updated with new prefixes as they are introduced by HMRC.		It should be noted that this expression would need to be updated with new prefixes as they are introduced by HMRC.
		+
		+	Try out your regular expressions on the regular expression calculator: [http://www.homemarketeer.com/sbs/regular_expression.html Regular Expression Calculator]
		+
		+	Regular expression information: [http://www.homemarketeer.com/sbs/regexp.htm Regular Expression Information]
		+
		+	[[PeopleSoft HRMS]] already has built in UK National Insurance validation, but you can use Regular Expressions in PeopleSoft - [[PeopleSoft Regular Expressions]]

WikiSysop at 23:01, 10 August 2013

2013-08-10T23:01:35Z

← Older revision		Revision as of 23:01, 10 August 2013
Line 1:		Line 1:
	=Validating National Insurance Numbers with Regular Expressions=		=Validating National Insurance Numbers with Regular Expressions=

-	[[Regular ~~expressions~~]] make a compact way to verify the format of the UK National Insurance Number.	+	[[Regular Expressions]] make a compact way to verify the format of the UK National Insurance Number.

	The format of UK National Insurance Numbers are described on the HMRC (Her Majesty's Revenue and Customs) web site under the label NIM39110. The format has changed from time to time, and there are some specialist formats, so depending on your purpose you may need to alter the expressions given here.		The format of UK National Insurance Numbers are described on the HMRC (Her Majesty's Revenue and Customs) web site under the label NIM39110. The format has changed from time to time, and there are some specialist formats, so depending on your purpose you may need to alter the expressions given here.

WikiSysop: Created page with "=Validating National Insurance Numbers with Regular Expressions= Regular expressions make a compact way to verify the format of the UK National Insurance Number. The format..."

2013-08-10T23:00:32Z

Created page with "=Validating National Insurance Numbers with Regular Expressions= Regular expressions make a compact way to verify the format of the UK National Insurance Number. The format..."

New page

=Validating National Insurance Numbers with Regular Expressions=

[[Regular expressions]] make a compact way to verify the format of the UK National Insurance Number.

The format of UK National Insurance Numbers are described on the HMRC (Her Majesty's Revenue and Customs) web site under the label NIM39110. The format has changed from time to time, and there are some specialist formats, so depending on your purpose you may need to alter the expressions given here.

The basic format is AA999999A, and a check for this format would be:

[A-Z]{2}[0-9]{6}[A-Z]

If you are looking for National Insurance Numbers within some text and want to replace them with dummy text, this simple expression will probably meet your needs and catch some of the more exotic NI format numbers that might also need to be replaced.

However, if we want to validate NI numbers say for payroll purposes, we can be more specific than this basic format, there are a few further rules:

The suffix letter for a personal NI number is restricted to A, B, C or D. Historically, temporary numbers allowed M or F to indicate gender, but these are no longer accepted by HMRC.

The pensions only prefixes can have other suffixes - NC used to accept suffixes M or F, and the current PP prefix can have a suffix of P. These are not allowed in the HMRC quality standard and so are not allowed in the expressions here.

The first letter cannot be D, F, I, Q, U or V.
The second letter cannot be D, F, I, O, Q, U and V.

[ABCEGHJ-PR-TW-Z][ABCEGHJ-NPR-TW-Z][0-9]{6}[A-D]

Additionally, there are certain combinations of prefix letters that have been used for administrative purposes and so are not assignable to individuals on a payroll:

{| class="wikitable"
|-
! NI Prefix
! Usage
! Effect on Expression

|-
|OO
|Used for Tax Credits where no NINO is held at the start of the tax credit claim.
|<nowiki>None. "O" is not permitted as the first letter of the prefix.</nowiki>

|-
|CR
|Used within HMRC for Account Investigations Section in NIC&EO.
|<nowiki>Exception - (C[ABCEGHJ-NPSTW-Z])</nowiki>

|-
|FY
|Was used for Attendance Allowance claims
|<nowiki>None. "F" is not permitted as the first letter of the prefix.</nowiki>

|-
|MW
|Was used January 1980 and January 1987 for Migrant Workers
|<nowiki>Exception - (M[ABCEGHJ-NPRSTX-Z])</nowiki>

|-
|NC
|Was used by Stakeholder Pensions administrator to allocate a dummy identifier in the format:
NCddmmyyF

ddmmyy is the birth date and F (or M) the gender of the individual. No longer accepted.
|<nowiki>Exception - (N[ABEGHJ-NPRSTW-Z])</nowiki>

|-
|PP
|Used as a pension temporary NI number - still accepted in quality standard, but is not acceptable for payroll purposes.
|<nowiki>Exception - (P[ABCEGHJ-NRSTWX]) - this exception covers PY and PZ as well.</nowiki>

|-
|PY, PZ
|Was used for tax only cases from 1970's until August 2002. Numbers no longer accepted.
|<nowiki>See above</nowiki>

|-
|TN
|Temporary Numbers used by employers and DWP when an individual's NINO was unknown.
The format was:
TNddmmyyF

ddmmyy is the birth date and F (or M) the gender of the individual. This format is no longer accepted.
|<nowiki>Exception - (T[ABCEGHJ-MPRSTW-Z])</nowiki>

|}

We can exclude these administrative prefixes by adding a specific expression for each prefix, e.g. allowing CA, but not allowing CR.

Using each of the exception patterns from the table above, the regular expression to validate employee payroll NI numbers is:

([ABEGHJ-LORSW-Z][ABCEGHJ-NPRSTW-Z])|(C[ABCEGHJ-NPSTW-Z])|(M[ABCEGHJ-NPRSTX-Z])|(N[ABEGHJ-NPRSTW-Z])|(P[ABCEGHJ-NRSTWX])|(T[ABCEGHJ-MPRSTW-Z])[0-9]{6}[A-D]

From time to time, HMRC publish the list of prefixes in use. This list gradually grows and so if you need this level of accuracy, you would need to be update your regular expression each time HMRC need to increase the list. The following list was supplied in the RTI specification (30th September 2011) - note that it contains some administrative prefixes:

AA, AB, AE, AH, AK, AL, AM, AP, AR, AS, AT, AW, AX, AY, AZ
BA, BB, BE, BH, BK, BL, BM, BT
CA, CB, CE, CH, CK, CL, CR
EA, EB, EE, EH, EK, EL, EM, EP, ER, ES, ET, EW, EX, EY, EZ
GY
HA, HB, HE, HH, HK, HL, HM, HP, HR, HS, HT, HW, HX, HY, HZ
JA, JB, JC, JE, JG, JH, JJ, JK, JL, JM, JN, JP, JR, JS, JT, JW, JX, JY, JZ
KA, KB, KE, KH, KK, KL, KM, KP, KR, KS, KT, KW, KX, KY, KZ
LA, LB, LE, LH, LK, LL, LM, LP, LR, LS, LT, LW, LX, LY, LZ
MA, MW, MX
NA, NB, NE, NH, NL, NM, NP, NR, NS, NW, NX, NY, NZ
OA, OB, OE, OH, OK, OL, OM, OP, OR, OS, OX
PA, PB, PC, PE, PG, PH, PJ, PK, PL, PM, PN, PP, PR, PS, PT, PW, PX, PY
RA, RB, RE, RH, RK, RM, RP, RR, RS, RT, RW, RX, RY, RZ
SA, SB, SC, SE, SG, SH, SJ, SK, SL, SM, SN, SP, SR, SS, ST, SW, SX, SY ,SZ
TA, TB, TE, TH, TK, TL, TM, TP, TR, TS, TT, TW, TX, TY, TZ
WA, WB, WE, WK, WL, WM, WP
YA, YB, YE, YH, YK, YL, YM, YP, YR, YS, YT, YW, YX, YY, YZ
ZA, ZB, ZE, ZH, ZK, ZL, ZM, ZP, ZR, ZS, ZT, ZW, ZX, ZY

If you need to be this precise, the regular expression is simpler, but longer (the administrative prefixes removed):

(AA|AB|AE|AH|AK|AL|AM|AP|AR|AS|AT|AW|AX|AY|AZ|BA|BB|BE|BH|BK|BL|BM|BT|CA|CB|CE|CH|CK|CL|EA|EB|EE|EH|EK|EL|EM|EP|ER|ES|ET|EW|EX|EY|EZ|GY|HA|HB|HE|HH|HK|HL|HM|HP|HR|HS|HT|HW|HX|HY|HZ|JA|JB|JC|JE|JG|JH|JJ|JK|JL|JM|JN|JP|JR|JS|JT|JW|JX|JY|JZ|KA|KB|KE|KH|KK|KL|KM|KP|KR|KS|KT|KW|KX|KY|KZ|LA|LB|LE|LH|LK|LL|LM|LP|LR|LS|LT|LW|LX|LY|LZ|MA|MX|NA|NB|NE|NH|NL|NM|NP|NR|NS|NW|NX|NY|NZ|OA|OB|OE|OH|OK|OL|OM|OP|OR|OS|OX|PA|PB|PC|PE|PG|PH|PJ|PK|PL|PM|PN|PR|PS|PT|PW|PX|RA|RB|RE|RH|RK|RM|RP|RR|RS|RT|RW|RX|RY|RZ|SA|SB|SC|SE|SG|SH|SJ|SK|SL|SM|SN|SP|SR|SS|ST|SW|SX|SY|SZ|TA|TB|TE|TH|TK|TL|TM|TP|TR|TS|TT|TW|TX|TY|TZ|WA|WB|WE|WK|WL|WM|WP|YA|YB|YE|YH|YK|YL|YM|YP|YR|YS|YT|YW|YX|YY|YZ|ZA|ZB|ZE|ZH|ZK|ZL|ZM|ZP|ZR|ZS|ZT|ZW|ZX|ZY)[0-9]{6}[A-D]

Summary

For simply looking for numbers potentially in NI number format, the following simple expression would suffice:

[A-Z]{2}[0-9]{6}[A-Z]

The key validation for current employee payroll NI Numbers would be:

([ABEGHJ-LORSW-Z][ABCEGHJ-NPRSTW-Z])|(C[ABCEGHJ-NPSTW-Z])|(M[ABCEGHJ-NPRSTX-Z])|(N[ABEGHJ-NPRSTW-Z])|(P[ABCEGHJ-NRSTWX])|(T[ABCEGHJ-MPRSTW-Z])[0-9]{6}[A-D]

A slightly longer, but more exact expression would be:

(AA|AB|AE|AH|AK|AL|AM|AP|AR|AS|AT|AW|AX|AY|AZ|BA|BB|BE|BH|BK|BL|BM|BT|CA|CB|CE|CH|CK|CL|EA|EB|EE|EH|EK|EL|EM|EP|ER|ES|ET|EW|EX|EY|EZ|GY|HA|HB|HE|HH|HK|HL|HM|HP|HR|HS|HT|HW|HX|HY|HZ|JA|JB|JC|JE|JG|JH|JJ|JK|JL|JM|JN|JP|JR|JS|JT|JW|JX|JY|JZ|KA|KB|KE|KH|KK|KL|KM|KP|KR|KS|KT|KW|KX|KY|KZ|LA|LB|LE|LH|LK|LL|LM|LP|LR|LS|LT|LW|LX|LY|LZ|MA|MX|NA|NB|NE|NH|NL|NM|NP|NR|NS|NW|NX|NY|NZ|OA|OB|OE|OH|OK|OL|OM|OP|OR|OS|OX|PA|PB|PC|PE|PG|PH|PJ|PK|PL|PM|PN|PR|PS|PT|PW|PX|RA|RB|RE|RH|RK|RM|RP|RR|RS|RT|RW|RX|RY|RZ|SA|SB|SC|SE|SG|SH|SJ|SK|SL|SM|SN|SP|SR|SS|ST|SW|SX|SY|SZ|TA|TB|TE|TH|TK|TL|TM|TP|TR|TS|TT|TW|TX|TY|TZ|WA|WB|WE|WK|WL|WM|WP|YA|YB|YE|YH|YK|YL|YM|YP|YR|YS|YT|YW|YX|YY|YZ|ZA|ZB|ZE|ZH|ZK|ZL|ZM|ZP|ZR|ZS|ZT|ZW|ZX|ZY)[0-9]{6}[A-D]

It should be noted that this expression would need to be updated with new prefixes as they are introduced by HMRC.