Regular Expressions 101

^start of line

Group 1(([a-z0-9\s]+\/)+)?

?repeats the group contents below at most once:

Group 2([a-z0-9\s]+\/)+

+repeats the group contents below at least once:

Character Class[a-z0-9\s]+

+matches at least one character from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case insensitive)

0-9one character from 0 (48₁₀) to 9 (57₁₀)

\sany whitespace character

\/the literal / (47₁₀ / 57₈ / 2F₁₆)

Group 3([a-z0-9\s]+)

Character Class[a-z0-9\s]+

+matches at least one character from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case insensitive)

0-9one character from 0 (48₁₀) to 9 (57₁₀)

\sany whitespace character

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

Character Class[a-z]+

+matches at least one character from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case insensitive)

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

i modifier: insensitive. Matches without distinguishing uppercase and lowercase letters

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

^(([a-z0-9\s]+\/)+)?([a-z0-9\s]+)\.[a-z]+

New

Documents/OneDrive/Collections/book.xlsx
Documents/OneDrive/Collections/book.xls
Documents/OneDrive/Collections/book.xlsm
book 2.xls
aa.xlsx