First Day of Week generator

Last modified: April 3, 2025

The First Day of Week generator creates numerical representations of days, aligning with the standard weekly calendar structure (e.g., 1 for Monday, 7 for Sunday). This generator ensures the values correspond to standard interpretations of weekly cycles and can be adjusted for scenarios requiring repeated patterns or diverse day-based data.

Generator properties

The table provides key details about the generator, including the short name, sample of the generated data, the supported data types, and whether it is specific to a particular country.

Short name Example of generated data Data type matching Country-specific
Week First Day 1, 7… character varyingcharactertext Default

Matching rules

The generator can be assigned to a column that matches any of the following rules:

  • The column name contains ‘first’, preceded or followed by any or no characters, then goes ‘day’, and ends with ‘week’, with any or no characters in between, regardless of the table name.
  • The column name contains ‘first’, preceded or followed by any or no characters, then goes ‘week’, and ends with ‘day’, with any or no characters in between, regardless of the table name.

Configure additional settings

The generator produces data based on a regular expression. Since it is built on the RegExp generator, see Regular Expression generator to customize settings and understand the correct usage of syntax.

Preview of the column data generated by the First Day of Week generator

First Day of Week generator