Field transformations Field transformations enable an administrator to transform raw field input into standardized values that are more meaningful to an organization. Rules control transformations and can be configured for use in queries. Field transformation standardizes a value in a specific field using rules. An example of this type of standardization might be a name format that removes designations such as Jr. and II from names. Another example is a mode that rounds the amount of computer RAM detected by Discovery to a useful interval (4112 MB to 4000 MB). Transform records make up the rules that define how a field transformation is executed. Order values determine the order in which each rule is evaluated. A check box on each transform enables an administrator to determine where processing stops when a rule evaluates to true. Note: The sys_user record that actions the transform process must have its date format set to the default format of "yyyy-MM-dd." Any other date format causes an error during transformation. This problem is only specific to transforming TO TARGET fields of type Date/Time. This problem is not an issue if the target field type is of type String or if the field mapping for the date field is changed to the same date format as the transformation process. Field transformation scriptingScripts that update records or insert records into the database (GlideRecord) are also normalized.Create a normalized query for field transformationsAn administrator can configure transformations to apply to queries issued against transformed fields in lists.Field transformations data jobsWhen a Transform is created, a Transform application data job is also created.Field transformations testing modeTransformation is a powerful tool that can cause data issues if used incautiously. Test all transformations before committing the changes to the CMDB.Transform a fieldThis topic lists in order the tasks you need to perform to transform a field.Create a raw fieldA raw field is a custom field created by an administrator to show the original (raw) input in a field on a form after it has been normalized or transformed.Transformed field identificationTransformed fields in records are marked with an icon that links to different targets, depending on the user's role.Transform definitionsTransform definitions define the transformation actions available for a given field type.Transform categoriesTransform categories are used to group the transform definitions together appropriately to present to users when creating new field transforms.Regular expressions and patterns in field normalization rulesField Transformation definitions support the use of regular expressions (referred to in the platform as regex) and pattern matching for determining the position of characters in a string.