Systems Online LogoPIMInto - Product Information Management System
User guide
×

Data Validation Masks in PIM

 
PCRE2 stands for Perl Compatible Regular Expressions (version 2), which is a set of functions that implement regular expression pattern matching using the same syntax and semantics as Perl. Regular expressions, or regex, are a sequence of characters that define a search pattern used for matching or manipulating strings.
 
The primary reason PCRE2 is used for data validation is due to its flexibility and power in pattern matching and string manipulation. Here's why PCRE2 is important in this context:
 
  • Flexibility: PCRE2 supports a wide variety of regular expression syntax allowing complex patterns to be described, which can capture virtually any data validation scenario.
     
  • Precision: With PCRE2, you can define precise validation rules. This means you can ensure the data entered adheres strictly to the expected format, whether it's a phone number, email address, date, or any custom format.
     
  • Efficiency: Regular expressions provide an efficient way to validate data. They can quickly process and validate even large amounts of data, making them suitable for performance-critical applications.
     
  • Security: Regular expressions can help safeguard your applications against malicious or poorly formatted input.
     
  • Cross-platform compatibility: PCRE2 is not tied to a specific programming language or platform. Libraries exist for using PCRE2 in many popular languages including C, PHP, Python, and more.
 
It is worth noting that while powerful, regular expressions can become complex and hard to understand for very complex patterns. It is important to use them judiciously and document them well.
 
Examples:
Please note that these expressions are very simplistic and may need to be adapted to suit your exact needs, especially if you're dealing with multi-line strings or require more complex matching patterns.
 
If you want to create a regular expression that prevents the entry of numerical characters using PCRE2, you might use the following examples:
 
Matching only alphabetic characters:
If you want to match a string that contains only alphabetic characters (uppercase and lowercase), you can use the following expression:
 
"^[a-zA-Z]*$"
 
This regular expression means "match a line that only contains the characters a-z (lowercase) or A-Z (uppercase). The * means zero or more of the preceding element.
 
Matching only non-numerical characters:
To match a string that can contain any character (including special characters and white space) except for numerical characters, use this expression:
 
"^[^0-9]*$"
 
This regular expression means "match a line that contains zero or more characters that are not 0-9." The [^0-9] creates a character set that matches anything except for the digits 0-9.
 
Remember, the ^ character indicates the start of the line, and the $ character indicates the end of the line. These are used to ensure that the entire string matches the pattern, not just part of it.
 
------
 
If you want to create a regular expression using PCRE2 that prevents the entry of lowercase letters, you might use the following examples:
 
Matching only uppercase characters:
If you want to match a string that contains only uppercase alphabetic characters, you can use the following expression:
 
"^[A-Z]*$"
 
This regular expression means "match a line that only contains the characters A-Z (uppercase). The * means zero or more of the preceding element.
 
Matching non-lowercase characters:
To match a string that can contain any character (including uppercase letters, digits, special characters, and white space) except for lowercase letters, use this expression:
 
"^[^a-z]*$"
 
This regular expression means "match a line that contains zero or more characters that are not a-z." The [^a-z] creates a character set that matches anything except for the lowercase letters a-z.
 
Remember, the ^ character indicates the start of the line, and the $ character indicates the end of the line. These are used to ensure that the entire string matches the pattern, not just part of it.
 
Please note that these expressions are very simplistic and may need to be adapted to suit your exact needs, especially if you're dealing with multi-line strings or require more complex matching patterns.
 
----