Expression

Check that all values match an expression

This test compares the format of the selected Field to an entered Expression. The allowable expression items are:

A – which can represent a single occurrence of any letter

9 – which can represent a single occurrence of any number

B – which can represent a single occurrence of a space character

X –which can represent a single occurrence of any character (alpha or numeric)

In the example in the image above, AAA9 is a proper format for SEAM entries.

The following list of SEAM entries would evaluate as follows with an AAA9 format

Expression:

WSG4 Acceptable

ABC2 Acceptable

UYH8 Acceptable

UYTT2 Error (One too many letters preceding the number 2.)

UH34 Error (The 3 should be a letter.)

---

Related topics

• Validation Specifications
• Select Database
• Collar Checks
  • Unique Collar Location
  • Collar on Surface
• Downhole Checks
  • Empty Table
  • Total Depth
  • Overlapping Intervals
  • Increasing and Decreasing
  • Maximum variation
  • Unique Values
  • Sequence
  • Derived Value
• Along Record Checks
  • Field Sum
• Individual Field Checks
  • Minimum and Maximum Values
  • Translations
  • Case Of
  • Mandatory
  • Expression
• Report
• Save and Run