Regular Expressions 101

Pro

^start of line

ABC_the literal text ABC_ (case sensitive)

Negated Character Class[^_]*

*matches any number of characters outside the set below:

_the literal _ (95₁₀ / 137₈ / 5F₁₆)

Character Class[0-9]+

+matches at least one character from the set below:

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

_the literal _ (95₁₀ / 137₈ / 5F₁₆)

Group 1(.*?)

.*?any character (except for line terminators), repeated any number of times

Non-Capturing Group(?:QUERY_answer)?

?repeats the group contents below at most once:

QUERY_answerthe literal text QUERY_answer (case sensitive)

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

csvthe literal text csv (case sensitive)

$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

Detailed match information will be displayed here automatically.

25 tokens

Regular Expression

^ABC_[^_]*_[0-9]+_(.*?)(?:QUERY_answer)?\.csv$

New

ABC_FIXED_20220720_VALUEABC.csv
ABC_FIXED_20220720_VALUEABCQUERY_answer.csv
ABC_FIXED_20220720_VALUEDEF.csv
ABC_FIXED_20220720_VALUEDEFQUERY_answer.csv
ABC_FIXED_20220720_VALUESTU.csv
ABC_FIXED_20220720_VALUESTUQUERY_answer.csv