regex101: L0 AutoImport format

Non-Capturing Group(?:INSERT_|UPDATE_)?

?repeats the group contents below at most once:

1st AlternativeINSERT_

INSERT_the literal text INSERT_ (case sensitive)

2nd AlternativeUPDATE_

UPDATE_the literal text UPDATE_ (case sensitive)

Group 1([NY|80]{2}[0-9]{6})

Character Class[NY|80]{2}

{2}matches exactly 2 characters from the set below:

Nthe literal N (78₁₀ / 116₈ / 4E₁₆) (case sensitive)

Ythe literal Y (89₁₀ / 131₈ / 59₁₆) (case sensitive)

|the literal | (124₁₀ / 174₈ / 7C₁₆)

8the literal 8 (56₁₀ / 70₈ / 38₁₆)

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

Character Class[0-9]{6}

{6}matches exactly 6 characters from the set below:

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

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

Group 2([^0-9]*)

Negated Character Class[^0-9]*

*matches any number of characters outside the set below:

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

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

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

Character Class[0-9]{4}

{4}matches exactly 4 characters from the set below:

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

_06_30the literal text _06_30

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

Non-Capturing Group(?:txt|csv)

1st Alternativetxt

txtthe literal text txt (case sensitive)

2nd Alternativecsv

csvthe literal text csv (case sensitive)

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

(?:INSERT_|UPDATE_)?([NY|80]{2}[0-9]{6})_([^0-9]*)_([0-9]{4})_06_30\.(?:txt|csv)

Test String
New

UPDATE_80070175_LOCATION_MARKING_PERIOD_2020_06_30.txt
INSERT_80070175_STUDENT_CLASS_GRADE_DETAIL_2020_06_30.txt
INSERT_80070175_STUDENT_CLASS_ENTRY_EXIT_2020_06_30.txt
INSERT_80070175_STUD_ATTEND_DAY_2020_06_30.txt
INSERT_80070175_PROGRAMS_FACT_2020_06_30.txt
INSERT_80070175_DAY_CALENDAR_2020_06_30.txt
INSERT_80070175_CRSE_INSTRUCT_ASSIGNMENT_2020_06_30.txt
INSERT_80070175_COURSE_2020_06_30.txt
INSERT_80070175_ATTENDANCE_CODES_2020_06_30.txt
80070175_STUDENT_LITE_UPDATE_2020_06_30.txt
80070175_SCHOOL_ENTRY_EXIT_INSERT_2020_06_30.txt

Regular Expressions 101

Regular Expression

Test String
New

Substitution
Processing...

Regular Expression

Test StringNew

SubstitutionProcessing...

Test String
New

Substitution
Processing...