In Simplify, you can use the validation rules by the way we listed below.

  • Optional: When user don't want to use the rule of system or reseller, but user cannot change the current rule of the higher level, so they can use the optional rule to override the higherlevel rule.
  • Empty: Force the value to be empty if user don’t want the originnal value.
  • AddParChar: Add characters after the original value.
    Rule configuration includes:
    • Length: The number of repeat characters.
    • Character: The character use to repeat.
  • Counter: Providing the count of the current document within a set of documents, grouped by a qualifier.
    Rule configuration includes:
    • Group: If a document has many fields need to be count individually, user need to name the group of each counter.
    • Seed: The counter will be start from a seed.
    • Increase By: Increment by a certain number. If no parameter is specified, then it will assume to increment by 1.
    • Format: This sets the minimum number of digits. It begins with ‘D’ and then the digit number.
  • DocumentCounter: Count documents in the whole system by Global counter group.
    Rule configuration includes:
    • Global counter group: Select a group what was defined by administrator.
  • GetFromField: Get the data from specific field.
    Rule configuration includes:
    • Field for value: Use to attach the path you want to get.
    • Source Tree (Button): Select the path.
    • Required (Check Box):
      • Checked: Field A get data from file B, if value of B is null, the file will be failed validation.
      • Unchecked: Field A will be empty if B is empty.
  • DefaultValue: A set of default values can be applied to the field if the field's value is empty.
    Rule configuration includes:
    • Default value: Enter the data you want to assign.
  • ToDecimal: Converting a value to the decimal.
  • ToUpper: Converting string values to uppercase letters.
  • Truncate: Remove the specific value in the field's value.
  • Round: Rounds a number to a specified number of decimal places.
  • HardCode: Hardcode the field value, no matter what its original data is.
  • LookupTable: A set of name-value pairs. If the field value matches the "Name", it will be replaced with the "Value" in the output.
    Rule configuration includes: 
    • Lookup table name: Select the lookup table.
    • Required (Check Box):
      • Checked: If the source value is not matched with any “Name”, the file will be failed validation.
      • Unchecked: The value will be the original value if it doesn’t match.
  • DateTimeFormat: Try formatting the input value into a datetime format, then convert it to another datetime format.
    Rule configuration includes:
    • Required (Check Box):
      • Checked: If the parse datetime got exception, the file will be failed validation.
      • Unchecked: If the parse datetime got exception, the value is the original value.
  • Mandatory: The value is mandatory.
  • NineDigitsRequired: Check input is nine digits.
  • Numeric: Check input is numeric.
  • AddWorkingDays: Add days without weekend and formatting the input value into a datetime format, then convert it to another datetime format.
    Rule configuration includes:
    • Required (Check Box):
      • Checked: If the parse datetime got exception, the file will be failed validation.
      • Unchecked: If the parse datetime got exception, the value is the original value.
  • ExtractNumbers: Extract the numbers from the input.
  • StringTrim: Trim the character from the input.
    Rule configuration includes:
    • Character: The string what will be trim by system.
    • Orientation:
      • Both: Removes all leading characters from the current string.
      • Start: Removes all leading and trailing characters from the current string.
      • End: Removes all trailing characters from the current string.
  • SubString: Extracts part of a string using specific start and end positions.
    Rule configuration includes:
    • Operation:
      • Mid: extracts the number of characters from the StartIndex.
      • Left: extracts from the left by Length.
      • Right: extracts from the right by Length.
  • ReplaceString: Replace a string by another.
  • MathExpression: Perform decimal calculations using basic math symbols (+, -, *, /) and parentheses. For instance, with an input value of 10, an equation like [value] + 100 - 5 (3/4) equals 106.25.
    Rule configuration includes:
    • Expression: Enter a mathematical expression that includes support for addition, subtraction, multiplication, division, and parentheses.
    • Required (Check Box):
      • Checked: If the math expression is not correct, like plus the string with the number, the file will be failed validation.
      • Unchecked: If the math expression is not correct, like plus the string with the number, value is the original data.
  • SSCCFormat: The length of the value must be between 18 or 20 characters with a prefix of “00”.