---
title: "Introduction to Data Workflow Value/String Operators"
slug: "introduction-to-data-workflow-valuestring-operators"
updated: 2025-09-26T02:04:01Z
published: 2025-09-26T02:04:01Z
canonical: "docs.unqork.io/introduction-to-data-workflow-valuestring-operators"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.unqork.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Introduction to Data Workflow Value/String Operators

The [**Value/String operators**](/v1/docs/valuestring-operators) let you convert Excel files into JSON, convert a JSON string to a JSON object, and find matching values in a table.

## What You'll Learn

In this article, you'll get an overview of the various [Data Workflow](/v1/docs/introduction-to-data-workflow) Value/String operators.

## Value/String Operators

Below is a list of the Data Workflow Value/String operators with descriptions of how to use them.

| Operator | Description |
| --- | --- |
| [Convert Value](/v1/docs/convert-value-operator) | Converts a value from one data type to another based on the value selected in the **Cast To** setting. From this drop-down menu, you can select `Number`, `Integer`, or `String`. The input must be a single key/value pair. To convert to a **Number** or **Integer**, the input must be a numeric value. When converting to an **Integer**, any values after the decimal are removed and not rounded. |
| [Create Value](/v1/docs/create-valueoperator) | Lets you create a value and pass it into the Data Workflow. This operator can create a number, string, or Boolean value. You can either set the value directly in the **Value/Expression** field or use `_arg` to reference the input connected to the top argument port. This operator is commonly used with an [Output](/v1/docs/output-operator) operator to set values for Post Triggers. |
| [Excel to JSON](/v1/docs/excel-to-json-operator) | Converts the Base64 encoding of an Excel file to JSON. Data in the sheet is converted into a headings array and a JSON array. The headings array contains the file's header fields. The JSON array contains the file contents. We recommend using an Excel file that contains headers. Doing so ensures the JSON array has key/value pairs, where the key corresponds to the header. |
| [Formula](/v1/docs/formula-operator) | Performs calculations on your data based on the formula defined in the **Formula/Expression** field. You can use an alias of `A` to represent the data coming into the input port. You can also use `_arg` to reference values coming into the top argument port. For example, the expression `=A*12` multiplies your input by 12. The expression `=A*_arg` multiplies your input by the value entered in the argument port. |
| [Includes](/v1/docs/includes-operator) | Determines if a specified value exists in the input. Then, it outputs a Boolean value. The input should be a value or an array of values. In the **Value** field, enter a value to determine if it is included in your data set. If your data includes that value, the output is **True**. If not, the output is **False**. |
| [JSON Parse](/v1/docs/json-parse-operator) | Parses a string containing properly-formatted JSON and outputs the defined data structure as a JSON object. > [!TIP] > You can use a [Hidden](/v1/docs/hidden-component) component as the input, where the Hidden component's **Default Value** contains the formatted JSON. |
| [NLP](/v1/docs/nlp-operator) | Compares text entering the upper input port to a data set in the lower input port. Then, it outputs an array listing any matching keywords and their corresponding Values. For example, you can create a data table with column names **Keyword** and **Mood**. Then, connect it to the NLP operator's lower input port. This is your Keyword vs. Mood table. In the **Keyword** column, create a list of words. In the **Mood** column, assign emotions (moods) to each word. In the NLP operator's **Source Column** field, enter `Keyword`. When the operator finds a match between the text in your input and the keywords in your table, it adds the Keyword/Mood pair as the output. |
| [Split String](/v1/docs/split-string-operator) | Splits a string into an array of values. In the **Separator** field, enter the separator to split the value on. The separator is not included in the final arrays. > [!NOTE] > The default separator is a comma. If the string is comma-separated you can leave the **Separator** field blank. |

## Resources

- [Introduction to Data Workflow](/v1/docs/introduction-to-data-workflow)
- [Data Workflow Component](/v1/docs/data-workflow-component)
- [Introduction to Data Workflow I/O Operators](/v1/docs/io-operators)
- [Introduction to Data Workflow Gateways Operators](/v1/docs/gateways-operators)
- [Introduction to Data Workflow Table Operators](/v1/docs/tableoperators)
- [Introduction to Data Workflow Array Operators](/v1/docs/array-operators)
- [Introduction to Data Workflow Object Operators](/v1/docs/object-operators)

JSON (JavaScript Object Notation) is an open standard file and data interchange format. Unqork uses JSON for submission (record) data.

Base64 is an encoding and decoding technique used to convert binary data to an ASCII (American Standard for Information Interchange) text format.