Exact repetition

regex

\d{4}

Explanation

A common pattern for year-like numeric fields.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Quantifiers

Match between a minimum and maximum number of repetitions.

Open In sheetregexsame section

Match at least a minimum number of repetitions.

Open In sheetregexsame section

Repeat the previous token any number of times.

Open In sheetregexsame section

Repeat the previous token at least once.

Open In sheetregexsame section

Make the previous token optional.

Open In sheetregexsame section

Use the shortest possible match.

Open In sheetregexsame section