Transformation Rules

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/page1237

Page Name: Transformation Rules
Page Number: 1237
Page Type: List

Source Table Name: Transformation Rule
Source Table Number: 1237

Show/hide columns in the Transformation Rules page

Seq.Control IDControl NameField No.Field NameEnabledEditableVisible
01067387479Code Search1Code SearchtrueTruetrue
12119124564Description Search2Description SearchtrueTruetrue
2720381541Transformation Type Search3Transformation Type SearchtrueTruetrue

Available options are:

  • “Uppercase”
  • “Lowercase”
  • “Title Case”
  • “Trim”
  • “Substring”
  • “Replace”
  • “Regular Expression – Replace”
  • “Remove Non-Alphanumeric Characters”
  • “Date Formatting”
  • “Decimal Formatting”
  • “Regular Expression – Match”
  • “Custom”
  • “Date and Time Formatting”
  • “Field Lookup”
  • “Round”
  • “Extract From Date”

3654631716Find Value Search10Find Value SearchtrueTruetrue
4800663397Replace Value Search11Replace Value SearchtrueTruetrue
5827214613Start Position Search15Start Position SearchtrueTruetrue
61485215802Length Search16Length SearchtrueTruetrue
72126286505Data Format Search18Data Format SearchtrueTruetrue
8249963479Data Formatting Culture Search20Data Formatting Culture SearchtrueTruetrue

Leave a Reply

Your email address will not be published. Required fields are marked *