regex101: PCRE2 (PHP) Match Workspace

^start of line

Group 1([^;]*;){2}

{2}repeats the group contents below exactly 2 times:

Negated Character Class[^;]*

*matches any number of characters outside the set below:

;the literal ; (59₁₀ / 73₈ / 3B₁₆)

201the literal text 201

Character Class[01]

0the literal 0 (48₁₀ / 60₈ / 30₁₆)

1the literal 1 (49₁₀ / 61₈ / 31₁₆)

;the literal ; (59₁₀ / 73₈ / 3B₁₆)

1st Alternative[^a]

Negated Character Class[^a]

athe literal a (97₁₀ / 141₈ / 61₁₆) (case sensitive)

2nd Alternativea[^l]

athe literal a (97₁₀ / 141₈ / 61₁₆) (case sensitive)

Negated Character Class[^l]

lthe literal l (108₁₀ / 154₈ / 6C₁₆) (case sensitive)

3rd Alternativeal[^l]

althe literal text al (case sensitive)

Negated Character Class[^l]

lthe literal l (108₁₀ / 154₈ / 6C₁₆) (case sensitive)

4th Alternativeall[^ ]

allthe literal text all (case sensitive)

Negated Character Class[^ ]

the literal (32₁₀ / 40₈ / 20₁₆)

5th Alternativeall [^c]

all the literal text all (case sensitive)

Negated Character Class[^c]

cthe literal c (99₁₀ / 143₈ / 63₁₆) (case sensitive)

6th Alternativeall c[^o]

all cthe literal text all c (case sensitive)

Negated Character Class[^o]

othe literal o (111₁₀ / 157₈ / 6F₁₆) (case sensitive)

7th Alternativeall co[^u]

all cothe literal text all co (case sensitive)

Negated Character Class[^u]

uthe literal u (117₁₀ / 165₈ / 75₁₆) (case sensitive)

8th Alternativeall cou[^n]

all couthe literal text all cou (case sensitive)

Negated Character Class[^n]

nthe literal n (110₁₀ / 156₈ / 6E₁₆) (case sensitive)

9th Alternativeall coun[^t]

all counthe literal text all coun (case sensitive)

Negated Character Class[^t]

tthe literal t (116₁₀ / 164₈ / 74₁₆) (case sensitive)

10th Alternativeall count[^r]]

all countthe literal text all count (case sensitive)

Negated Character Class[^r]

rthe literal r (114₁₀ / 162₈ / 72₁₆) (case sensitive)

]the literal ] (93₁₀ / 135₈ / 5D₁₆)

11th Alternativeall countr[^i]]

all countrthe literal text all countr (case sensitive)

Negated Character Class[^i]

]the literal ] (93₁₀ / 135₈ / 5D₁₆)

12th Alternativeall countri[^e]

13th Alternativeall countrie[^s]

Group 3([^;]*;){6}

Group 4(9[1-9][0-9]|[1-9][0-9]{3,})

;the literal ; (59₁₀ / 73₈ / 3B₁₆)

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

25 tokens

Regular Expression

^([^;]*;){2}201[01];([^a]|a[^l]|al[^l]|all[^ ]|all [^c]|all c[^o]|all co[^u]|all cou[^n]|all coun[^t]|all count[^r]]|all countr[^i]]|all countri[^e]|all countrie[^s])([^;]*;){6}(9[1-9][0-9]|[1-9][0-9]{3,});

New

Unnamed: 0;Unnamed: 0.1;year;country;word;frequency;count;freq_prop_headlines;word_len;freq_rank;hfreq_rank;theme
14;279;2012;India;cricketer;0;3634;0.0;9;20;20;empowerment
8964;52224;2010;USA;witchcraft;0;1912;0.0;10;910;935;female stereotypes
9887;57556;2021;all countries;hate;312;234227;0.001332041;4;436;429;crime and violence

Regular Expressions 101

Regular Expression

Extraction