Regular Expressions 101

Explanation

Pro

Group PN(?P<PN>[A-Z\d-]+)

Character Class[A-Z\d-]+

+matches at least one character from the set below:

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

\da Unicode decimal digit

-the literal - (45₁₀ / 55₈ / 2D₁₆)

\s+a Unicode whitespace character, repeated at least once

Group Name(?P<Name>[A-Z]+(?:[\s-]+[A-Z]+)*)

Character Class[A-Z]+

+matches at least one character from the set below:

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

Non-Capturing Group(?:[\s-]+[A-Z]+)*

*repeats the group contents below any number of times:

Character Class[\s-]+

+matches at least one character from the set below:

\sa Unicode whitespace character

-the literal - (45₁₀ / 55₈ / 2D₁₆)

Character Class[A-Z]+

+matches at least one character from the set below:

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

\s+a Unicode whitespace character, repeated at least once

Negated Character Class[^,]+?

+?matches at least one character outside the set below:

,the literal , (44₁₀ / 54₈ / 2C₁₆)

EAthe literal text EA (case sensitive)

\s+a Unicode whitespace character, repeated at least once

Group Price(?P<Price>\d+(?:,\d+)*)

\d+a Unicode decimal digit, repeated at least once

Non-Capturing Group(?:,\d+)*

*repeats the group contents below any number of times:

,the literal , (44₁₀ / 54₈ / 2C₁₆)

\d+a Unicode decimal digit, repeated at least once

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

Match Information

Detailed match information will be displayed here automatically.

Quick Reference

25 tokens

Regular Expression

(?P<PN>[A-Z\d-]+)\s+(?P<Name>[A-Z]+(?:[\s-]+[A-Z]+)*)\s+[^,]+?EA\s+(?P<Price>\d+(?:,\d+)*)

New

8000KE60803F6                ST FULL-DEPTH TEETH            1 EA           36,56          36,56    2,00           0,73           37,29' ,'8522-3770                    CONTACT            2 EA          311,45         622,90    2,00          12,46          635,36

Substitution

8000KE60803F6                ST FULL-DEPTH TEETH            1 EA           36,56          36,56    2,00           0,73           37,29' ,'8522-3770                    CONTACT            2 EA          311,45         622,90    2,00          12,46          635,36