---
sourceDocument: Brazil ServiceNow AI Platform Administration
sourceDocumentLink: https://www.servicenow.com/docs/r/platform-administration

 Release :

    - brazil

ft:locale :

    - en-US

ft:publication_title :

    - Brazil ServiceNow AI Platform Administration

ft:clusterId :

    - platadm

bundleId :

    - platadm

workflow :

    - Platform


---

# Default transform definitions

# Default transform definitions {#ariaid-title1}

Release version: Brazil  
Updated September 10, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 5 minutes to read
Summarize  
![AI sparkle icon](https://servicenow.com/docs/portal-asset/ai-sparkle-icon) Summarized using AI  
This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.  

## Summary of Default transform definitions

ServiceNow provides default transform definitions that allow customers to manipulate and standardize text and numeric field values during data transformation processes.
These predefined transformations help ensure data consistency and accuracy when importing or modifying records.
Show full answer Show less  

## Transform Types and Their Practical Uses

* **Change case:** Converts text field values to upper, lower, proper (title case), or formal case formats, helping standardize text data appearance.
* **Constant:** Replaces any field value with a fixed constant, useful for setting default or uniform values during import.
* **Delete:** Removes a specified sequence of characters from a text value based on starting and ending positions, allowing targeted data cleanup.
* **Insert:** Inserts a fixed string at a specified position in a text value, enabling addition of prefixes, suffixes, or other content inline.
* **Left and Right:** Keeps or deletes a specified number of characters from the left or right side of a text field, facilitating extraction or trimming of data segments.
* **Prefix and Suffix:** Adds defined characters to the beginning or end of a field value, useful for tagging or formatting.
* **Replace:** Uses regular expressions or literal strings to find and replace parts of a text value, supporting complex pattern-based transformations.
* **Round:** Rounds numeric values to specified intervals using various rounding modes (e.g., half up, half down, toward zero), important for aligning numeric data to business rules or reporting standards.
* **Substring:** Keeps or deletes characters within a specified substring range, allowing precise extraction or removal of parts of text values.
* **Trim:** Removes blank spaces from text or numeric field values, ensuring clean data without leading or trailing spaces.

## Key Parameters and Considerations

* Most text-based transforms rely on position parameters (starting and ending positions) with flexible modes to specify which characters to keep or delete.
* Rounding transforms require selecting appropriate intervals based on the data context (e.g., 0.01 for decimals, 256 for megabytes) and choosing a rounding mode that fits the desired business logic.
* Replace transforms support regular expressions, enabling powerful pattern matching beyond simple string replacements.
* Case conversion modes ensure text values conform to desired capitalization standards for consistent presentation.

## Benefits for ServiceNow Customers

By leveraging these default transform definitions, customers can efficiently automate data cleansing, formatting, and normalization during import or integration processes. This reduces manual data correction efforts, improves data quality, and supports reliable reporting and operational workflows within the ServiceNow platform.  
The system offers default transform definitions for fields containing text, text
numeric, and numeric values.
{#r_DefsIncludedWFieldTransformation__table_y13_51d_dr__entry__4}

| Transform Type | Category | Description | Parameters |
|-|-|-|-|
| Change case | Text | Changes the case of the characters in the field value. | Mode: Select one of the following modes: * Upper: Converts the value to all upper case characters * Lower: Converts the value to all lower case characters * Proper: Converts the value to title case, with the first character in each string in upper case, and the remaining characters of the string in lower case. * Formal: Converts the value to a string in which only the first letter of the first word is in upper case. {#r_DefsIncludedWFieldTransformation__ul_eyg_2vy_y1b} |
| Constant | Text Numeric | Converts the value in this field to a constant. | Constant: The constant with which to replace the value in this field. |
| Delete | Text | Delete a specified sequence of characters from a field value. | * Starting position: Specifies the first character in a sequence of characters to delete from a string. See the discussion of position modes at the beginning of this section for details. * Ending position: Specifies the final character in a sequence of characters to delete from a string. See the discussion of position modes at the beginning of this section for details. {#r_DefsIncludedWFieldTransformation__ul_fyg_2vy_y1b} |
| Insert | Text | Insert a fixed character sequence into a field value. | * Position: The character position at which to insert the new value. See the discussion of position modes at the beginning of this section for details. * Insert: The value to insert into this field. {#r_DefsIncludedWFieldTransformation__ul_gyg_2vy_y1b} |
| Left | Text | Deletes or keeps a specified number of characters from the left side of this field value. | * Position: Specifies the number of characters to keep or delete from the left side of the value. See the discussion of position modes at the beginning of this section for details. * Mode: Select the mode for this transform: Keep or Delete. {#r_DefsIncludedWFieldTransformation__ul_hyg_2vy_y1b} |
| Prefix | Text | Adds characters to the beginning of a field value. | Prefix: Defines the characters to add to the beginning of the transformed field value. |
| Replace | Text | Replaces occurrences of one string with another string. The special characters backslash (\\) and dollar sign ($) in the replacement string can cause the transform to be different than if the replacement string were being treated as a literal replacement string. Use a regular expression to replace a string or parts of a string. | * Find: Enter the string or regular expression to replace. * Replace with: Enter the replacement string. {#r_DefsIncludedWFieldTransformation__ul_iyg_2vy_y1b} |
| Right | Text | Retains or deletes a specified number of characters from the right side of a field value. | * Position: The number of characters to delete or keep from the right side of this transformed field. See the discussion of position modes at the beginning of this section for details. * Mode: Select the mode for this transform: Keep or Delete. {#r_DefsIncludedWFieldTransformation__ul_jyg_2vy_y1b} |
| Round | Numeric | Rounds integers to a configured rounding interval using specific criteria. The interval must be appropriate to the value being transformed, such as an interval of 12 for a value expressed in dozens or 0.01 for decimal values expressed in hundredths. | * Interval: Select the rounding interval that is appropriate to the units of the field value. For example. an interval of 256 is appropriate for expressing RAM values in megabytes, but does not work for Disk space expressed in gigabytes. The rounding interval for the examples below is 1 * Mode: Criteria for applying the rounding interval. * Half up: Always round up a value that is exactly half way between two intervals. For example, 3.5 is always rounded up to 4, and -3.5 is always rounded up to -3. * Half down: Always round down a value that is exactly half way between two intervals. For example, 3.5 is always rounded down to 3, and -3.5 is always rounded down to -4. * Half away from zero: Always round an integer that is half way between the specified interval away from zero. For example, 3.5 is always rounded to 4, and -3.5 is always rounded to -4. * Half toward zero: Always round an integer that is half way between the specified interval toward zero. For example, 3.5 is always rounded to 3, and -3.5 is always rounded to -3. * Half to even: Always round an integer that is half way between the specified interval to the nearest interval whose least significant digit is even. For example, 3.5 is always rounded to 4, and 4.5 is always rounded to 4. * Half to odd: Always round an integer that is half way between the specified interval to the nearest interval whose least significant digit is odd. For example, 3.5 is always rounded to 3, and 4.5 is always rounded to 5. * Up: Always round an integer up by the specified rounding interval. For example, 3.4 is always rounded to 4 by a rounding interval of 1.0. * Down: Always round an integer down by the specified rounding interval. For example, 4.6 is always rounded to 4 by a rounding interval of 1.0. * Away from zero: Always round an integer away from zero by the specified rounding interval. For example, 3.3 is always rounded to 4, and -3.3 is always rounded to -4 by a rounding interval of 1.0. * Toward zero: Always round an integer toward zero by the specified rounding interval. For example, 3.3 is always rounded to 3, and -3.3 is always rounded to -3 by a rounding interval of 1.0. {#r_DefsIncludedWFieldTransformation__ul_lyg_2vy_y1b} {#r_DefsIncludedWFieldTransformation__ul_kyg_2vy_y1b} |
| Substring | Text | Keep or delete characters from a specified sub-sequence of characters in the field value. | * Starting position: Specifies the first character in a sub-sequence of characters within the value. See the discussion of position modes at the beginning of this section for details. * Ending position: Specifies the final character in a sub-sequence of characters within the value. See the discussion of position modes at the beginning of this section for details. * Mode: Select whether to Delete the sub-sequence selected or Keep only those characters defined. {#r_DefsIncludedWFieldTransformation__ul_myg_2vy_y1b} |
| Suffix | Text | Appends characters to the end of a field value. | Suffix: Defines the suffix to add to the end of the field value. |
| Trim | Text Numeric | Removes blank spaces from the field value. | No parameters |
[Table 1. Transform Definitions]

{#r_DefsIncludedWFieldTransformation__table_y13_51d_dr}