regex101: PCRE2 (PHP) Match Workspace

Non-Capturing Group(?:^|\t)

1st Alternative^

^start of line

2nd Alternative\t

\ta tab character (ASCII 9)

Non-Capturing Group(?:\d+|KY\d+|([^\t]+))

1st Alternative\d+

\d+a digit, repeated at least once

2nd AlternativeKY\d+

KYthe literal text KY (case sensitive)

\d+a digit, repeated at least once

3rd Alternative([^\t]+)

Group 1([^\t]+)

Negated Character Class[^\t]+

+matches at least one character outside the set below:

\ta tab character (ASCII 9)

Positive Lookahead(?=\t|$)

1st Alternative\t

\ta tab character (ASCII 9)

2nd Alternative$

$end of line

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Search reference

Regular Expression

(?:^|\t)(?:\d+|KY\d+|([^\t]+))(?=\t|$)

Test String
New

1025164	HERBEX IBERIA, S.L.U.	KY01	4600292091
1016379	DRISCOLL´S OF EUROPE B.V.	KY01	4600322589
1008809	KY01	LANDGARD NORD OBST & GEMÜSE GM	4600347315
1008835	C.A.S.I. : COOPERATIVA PROVINC	KY01	4600348112
1019258	SYDGRÖNT EKONOMISK FÖRENING	KY02	460034342
1019258	3 M SVENSKA AB	KY02	460034342
1019258	460034342	3 M SVENSKA AB	KY02
3 M SVENSKA AB	KY02	460034342	1019258
1019258	460034342	KY02	3 M SVENSKA AB

Regular Expressions 101

Regular Expression

Test String
New

Substitution
Processing...

Regular Expression

Test StringNew

SubstitutionProcessing...

Test String
New

Substitution
Processing...