> For the complete documentation index, see [llms.txt](https://docs.k3-labs.com/introduction/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.k3-labs.com/introduction/automate/functions-overview/transform-function-details.md).

# Transform Function Details

**Overview**

The Transform Function in K3 Labs is designed to enable users to manipulate and process data in workflows with a range of customizable options. Below, you can find a breakdown of how the function setup and key features work.

\
**Setup Components:**

1. Field Selector: Allows users to select fields for formula creation, similar to the IF function.
2. Variable Field: A variable selector allowing users to add input points into their formulas.

Note: One transform function can perform one action.

\
**Formula Functions:**

Upon selecting the formula option, users can choose from a drop-down menu with various mathematical, string, and array operations, categorized as follows:

1. Math Operations
   1. Custom Formula: Allows for custom formulas. See more [here](/introduction/automate/functions-overview/transform-function-details/transform-custom-formula.md). 
   2. Abs: Returns the absolute value.
   3. Average: Calculates the average of a set of numbers.
   4. Floor: Rounds a number down to the nearest integer.
   5. Median: Finds the median value in a set of numbers.
   6. Mod: Returns the remainder from a division.
   7. Rand: Generates a random number.
   8. Min: Returns the smallest value from a set of inputs.
   9. Max: Returns the largest value from a set of inputs.
   10. Power: Raises x to the power of y (i.e., computes x^y).
   11. Percentage Change:  Calculates the percentage change from a to b, using the formula ((b - a) / a) \* 100.
2. String Functions
   1. Length: Returns the length of a string.
   2. LowerCase: Converts text to lowercase.
   3. UpperCase: Converts text to uppercase.
   4. REGEX\_Replace: Replaces a substring using regular expressions.
   5. Replace: Replaces occurrences of a string with another string.
   6. Substring: Extracts a portion of a string.
   7. Trim: Removes leading and trailing spaces.
   8. TrimLeft: Removes spaces from the beginning of a string.
   9. TrimRight: Removes spaces from the end of a string.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.k3-labs.com/introduction/automate/functions-overview/transform-function-details.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.