> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.syncspider.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Value Manipulation Field

# TABLE OF CONTENTS

* [1. What is Value Manipulation Field](#1.-What-is-Value-Manipulation-Field)
* [2. Value Manipulation Field Options](#2.-Value-Manipulation-Field-Options)
* [2.1 Name](#2.1-Name)
* [2.2 Field to Manipulate](#2.2-Field-to-Manipulate-%C2%A0)
* [2.3 Action over field](#2.3-Action-over-field-%C2%A0)
* [3. Example and how to use it](#3.-Example-and-how-to-use-it)

---
### 1. What is Value Manipulation Field

Value manipulation field represents a field whose value is made by taking value from an existing schema field and manipulate (transform) it in the chosen format.

### 2. Value Manipulation Field Options

![](https://storage.crisp.chat/users/helpdesk/website/-/a/b/d/d/abdd883bd5670800/c6a4cd90-5885-41e4-b626-c09f02_14vkyfg.png)

#### 2.1 Name
####

The name of the Value manipulation custom field that you would like to see in the Mapping section.

#### 2.2 Field to Manipulate
####

The Fields that you would like to manipulate in the Value manipulation field.

#### 2.3 Action over field

Introducing a function designed to manipulate a selected field from a schema. This function offers a range of operations, including but not limited to converting to uppercase, converting to lowercase, changing data type, removing emojis, and more.

### 
### 3. Example and how to use it

The Value Manipulation Field is a highly versatile feature that offers a range of functionalities, each serving a specific purpose. Let's delve into the details of each field and explore their potential use cases:

**Change type:** This field allows you to convert the data type of a value. For instance, you can convert a string to a number or vice versa, enabling you to manipulate and process data more effectively.

![](https://storage.crisp.chat/users/helpdesk/website/-/c/f/0/4/cf0488ff3ae77000/778299c6-9d92-49ab-9ffb-c7f754_lx70xt.png)

**Uppercase:** With this field, you can transform text to uppercase, ensuring consistency and uniformity in your data. It's particularly useful when dealing with case-sensitive operations or when you want to present information in a standardized format.

![](https://storage.crisp.chat/users/helpdesk/website/-/1/0/f/b/10fbc1078372ce00/5346478f-28d7-44f0-b566-863c7d_vo2ica.png)

**Lowercase:** Similar to the Uppercase field, the Lowercase field enables you to convert text to lowercase. This can be beneficial when you need to normalize data or perform case-insensitive comparisons.

![](https://storage.crisp.chat/users/helpdesk/website/-/5/c/9/e/5c9eccc328167000/f92e92bb-7c10-456f-9d8b-780b44_qaknv6.png)

**Trim:** The Trim field removes any leading or trailing whitespace from a string. This is valuable when working with user inputs or data that may contain unintentional spaces, ensuring data integrity and accuracy.

![](https://storage.crisp.chat/users/helpdesk/website/-/7/5/8/6/7586c72331cf3c00/5685df51-1ac9-4e72-b3fd-248a5b_1txemyb.png)

**Left Trim:** Specifically focusing on the beginning of a string, the Left Trim field eliminates leading whitespace. This is useful in scenarios where you need to clean up data inputs that may have undesired spaces at the start.

![](https://storage.crisp.chat/users/helpdesk/website/-/b/c/f/c/bcfc54cc14214800/e74da78f-7794-44b4-99ab-b7725b_1db51nx.png)

**Right Trim:** In contrast to Left Trim, the Right Trim field removes trailing whitespace from the end of a string. It comes in handy when you want to tidy up data entries that might have trailing spaces.

![](https://storage.crisp.chat/users/helpdesk/website/-/5/5/7/e/557e4ce7425c5400/53880f15-5cba-4a4e-9ee6-79a698_qj68vy.png)

**Preg Replace:** By employing regular expressions (REGEX), the Preg Replace field enables you to search for specific patterns within a string and replace them with desired content. This offers powerful manipulation capabilities when dealing with complex data transformations.

![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3096446751/original/DvMEoWc-v5yL2-sUmwH2ZFmqSs4Nhp96XQ.png?1685621155)

**B64 to JPEG:** This field allows you to convert Base64-encoded data into a JPEG image format. It comes in handy when you have encoded images and need to decode them for display or further processing.

![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3096446782/original/oHMvuo5uK8d05JiHWwjukup_oEIQcvRtOQ.png?1685621216)

**Replace:** The Replace field enables you to find and replace specific values or characters within a string. This is useful for data cleanup tasks or when you need to substitute certain elements with others.

![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3096446873/original/p7yDci_hwELmC8pmxrh0Hwqq7QRHrc2csA.png?1685621325)

**Emoji To HTML:** This field converts emojis within a string into their corresponding HTML entities. It is particularly useful when dealing with user-generated content or social media data that contains emojis.

![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3096447192/original/IwrEQqy7HELQAaPO-4XikkDXwj5LCARS0A.png?1685621544)

**Remove Emoji:** As the name suggests, this field removes emojis from a string. It proves beneficial when working with text that needs to be stripped of any emoticons or non-standard characters.

![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3096447289/original/dK4vCUyLevtGi80r3MIOk-p_nNxcMv4HmQ.png?1685621603)

**Merge With Multiple Value Fields:** This field allows you to combine multiple value fields into a single field, providing a consolidated view of related data. It's ideal for situations where you want to aggregate information from different sources or create a unified output.

![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3096447361/original/RB0lykUz6zHmyeuD3glPxaiR0VwQOMxWcA.png?1685621677)

Exploring the capabilities of each field provides a comprehensive understanding of how the Value Manipulation Field can be leveraged for various use cases, enabling efficient data manipulation and processing.

---

To check the list of the tools and features we support please click [here](https://syncspider.com/integrations/)!

If you don't see your favorite tool on our list, please take the time and send us the request [here](https://roadmap.syncspider.com/boards/integrations?sort=cached_votes_up) to create an integration for you or UP-vote if it's already on the list :)

We develop integrations based on the requests and up-votes :)

We hope that this covers everything. If you have any further questions or need additional clarification please reach out to us via [[email protected]](/cdn-cgi/l/email-protection#d9aaaca9a9b6abad99aaa0b7baaaa9b0bdbcabf7bab6b4) or our chat widget!