DataFakery Studio
🏠 Home💬Support
  • What is DataFakery Studio?
    • 🚀What's new in 2025.1
      • Changelog Archive
    • Editions / Licenses
    • Installation requirements
    • Setup guide
    • 👩‍💻Roadmap
  • Guides
    • Creating a DataFakery Project
    • Anonymize Microsoft SQL Server Data Source
    • Anonymize PostgreSQL Database
    • Anonymize MySQL Database
    • Docker Integration
    • Export to CSV File
  • Fundamentals
    • Project
    • Data Sources
    • Data Models
      • Virtual Tables
    • Generators / Fakers
      • Strings
      • Numbers
      • Date & Time
      • Custom Expression
      • Text Pattern
      • Regular expressions
      • Foreign Keys Generator
      • Table Lookups
      • Default Values
      • Sequence Generator
      • Constant Value
      • List Values
    • Randomizer Options
    • Optimizations
    • Data Exploration
  • Extras
    • Data Storage
    • Keyboard Shortcuts
    • Appearance / Theme
  • Support
    • Contact Support
    • Troubleshooting
Powered by GitBook
On this page
  • Faker Configuration
  • Example Configuration

Was this helpful?

  1. Fundamentals
  2. Generators / Fakers

Text Pattern

This function generates a value based on a custom text pattern, using both alphabetical and non-alphanumeric characters

PreviousCustom ExpressionNextRegular expressions

Last updated 11 months ago

Was this helpful?

Faker Configuration

  • Pattern: Enter the pattern to generate the data. Patterns can include various placeholders:

Character
Description
Examples

l

Lower-case letter

anjb

L

Upper-case letter

ANJB

n

Number

1324

s

Special Character

-#*@

_

space character (underscore)

*

Any character

aB9+

\

Escape character

  • Add Suffix: Enter any additional suffix to append to the generated data (optional).

  • Replace only if Non-Null: Check this box to ensure that the faker only replaces non-null values in the column. If unchecked, it will replace all values, including nulls.

Example Configuration

A pattern like Ll*_n-##nn leads to these results