--- title: String Calculated Fields description: String calculated fields allow you to edit texts to get different results. --- [Skip to content](https://gohub.casebook.net/knowledge/string-calculated-fields#main-content) [More support](https://gohub.casebook.net/knowledge/kb-tickets/new) [![logo-raspberry (1)](https://gohub.casebook.net/hs-fs/hubfs/logo-raspberry%20(1).png?width=1286&height=255&name=logo-raspberry%20(1).png)](https://gohub.casebook.net/) - [Knowledge Base](https://gohub.casebook.net/knowledge) - [Video Library](https://gohub.casebook.net/video-library) - [Still Need Help?](https://gohub.casebook.net/knowledge/kb-tickets/new) Open main navigation Close main navigation - [Knowledge Base](https://gohub.casebook.net/knowledge) - [Video Library](https://gohub.casebook.net/video-library) - [Still Need Help?](https://gohub.casebook.net/knowledge/kb-tickets/new) - [More support](https://gohub.casebook.net/knowledge/kb-tickets/new) Hi. How can we help? - There are no suggestions because the search field is empty. 1. [Knowledge Base](https://gohub.casebook.net/knowledge) 2. [Reporting](https://gohub.casebook.net/knowledge/reporting) 3. [Calculated Fields](https://gohub.casebook.net/knowledge/reporting#calculated-fields) # String Calculated Fields ## String calculated fields allow you to edit texts to get different results. **Remember to always include strings between quotation marks (" ").** ### The functions included in the String category are: | Function Name | Syntax and Sample | | --- | --- | | concatenate: concatenate allows you to join multiple strings of text to form a phrase. Spaces are not automatically included, so make sure you include them in your text arguments if necessary. | Syntax: concatenate() | | Sample: concatenate("Getting started"," with"," the"," Reveal"," application") | | | find: find returns the starting position (number) of a first string of text in a second string if text as specified in your arguments. | Syntax: find({find text},{within text},{start number}) | | Sample: find("with","Getting Started with Reveal visualizations",3) | | | len: len returns the number of characters in the string of text you enter. | Syntax: len({text}) | | Sample: len("Getting Started with Reveal") | | | lower: lower converts all upper case characters in a given text string to lower case. | Syntax: lower({text}) | | Sample: lower("Getting Started with Reveal") | | | mid: mid returns a substring (length) of the specified string of text according to what you configure in your arguments. | Syntax: mid({text},{start},{length}) | | Sample: mid("Getting Started with Reveal",9,12) | | | replace: replace replaces a given string of text with a different text as specified in your arguments. | Syntax: replace({text},{old text},{new text}) | | Sample: replace("Getting Started with Reveal","Getting Started","Creating Visualizations with") | | | trim: trim returns the same string of text you enter; however, it will remove any leading or trailing whitespaces, and will only keep the spaces between words. | Syntax: trim({text}) | | Sample: trim(" Getting Started with Reveal ") | | | upper: upper converts all lower case characters in a given text string to upper case. | Syntax: upper({text}) | | Sample: upper("Caution: Hot. Do not touch") | |   - [Getting Started With Casebook](https://gohub.casebook.net/knowledge/getting-started-with-casebook#main-content) - [Casebook Overview](https://gohub.casebook.net/knowledge/getting-started-with-casebook#casebook-overview) - [Getting Started for New Users](https://gohub.casebook.net/knowledge/getting-started-with-casebook#getting-started-for-new-users) - [Services in Casebook](https://gohub.casebook.net/knowledge/getting-started-with-casebook#services-in-casebook) - [Notes](https://gohub.casebook.net/knowledge/getting-started-with-casebook#notes) - [Admin](https://gohub.casebook.net/knowledge/admin#main-content) - [Casebook Security](https://gohub.casebook.net/knowledge/admin#casebook-security) - [Roles and Permissions](https://gohub.casebook.net/knowledge/admin#roles-and-permissions) - [User Management](https://gohub.casebook.net/knowledge/admin#user-management) - [Notifications](https://gohub.casebook.net/knowledge/admin#notifications) - [Data](https://gohub.casebook.net/knowledge/admin#data) - [Field Configuration](https://gohub.casebook.net/knowledge/admin#field-configuration) - [Dynamic Fields](https://gohub.casebook.net/knowledge/admin#dynamic-fields) - [Forms](https://gohub.casebook.net/knowledge/admin#forms) - [Implementation & Adoption](https://gohub.casebook.net/knowledge/admin#implementation-adoption) - [People](https://gohub.casebook.net/knowledge/people) - [Intake](https://gohub.casebook.net/knowledge/intake) - [Engage](https://gohub.casebook.net/knowledge/engage#main-content) - [Text Messages](https://gohub.casebook.net/knowledge/engage#text-messages) - [Configuration](https://gohub.casebook.net/knowledge/engage#configuration) - [Notes](https://gohub.casebook.net/knowledge/engage#notes) - [Track](https://gohub.casebook.net/knowledge/track) - [Access](https://gohub.casebook.net/knowledge/access) - [Workflow & Tasks](https://gohub.casebook.net/knowledge/workflow-tasks) - [Reporting](https://gohub.casebook.net/knowledge/reporting#main-content) - [Overview](https://gohub.casebook.net/knowledge/reporting#overview) - [Datasets](https://gohub.casebook.net/knowledge/reporting#datasets) - [Dashboards](https://gohub.casebook.net/knowledge/reporting#dashboards) - [Pre-built Reports](https://gohub.casebook.net/knowledge/reporting#pre-built-reports) - [Custom Reports](https://gohub.casebook.net/knowledge/reporting#custom-reports) - [Data Visualizations](https://gohub.casebook.net/knowledge/reporting#data-visualizations) - [Filters](https://gohub.casebook.net/knowledge/reporting#filters) - [Calculated Fields](https://gohub.casebook.net/knowledge/reporting#calculated-fields) - [Other](https://gohub.casebook.net/knowledge/reporting#other) - [Audit Logs](https://gohub.casebook.net/knowledge/audit-logs) - [Integrations](https://gohub.casebook.net/knowledge/integrations#main-content) - [Low-code incoming integrations with Zapier](https://gohub.casebook.net/knowledge/integrations#low-code-incoming-integrations-with-zapier) - [Custom incoming integrations with Casebook API](https://gohub.casebook.net/knowledge/integrations#custom-incoming-integrations-with-casebook-api) - [Custom outgoing integrations with Webhooks](https://gohub.casebook.net/knowledge/integrations#custom-outgoing-integrations-with-webhooks) - [Program Area Specific](https://gohub.casebook.net/knowledge/program-area-specific#main-content) - [VOCA Reporting](https://gohub.casebook.net/knowledge/program-area-specific#voca-reporting) - [Customer Support](https://gohub.casebook.net/knowledge/customer-support#main-content) - [Getting Unstuck](https://gohub.casebook.net/knowledge/customer-support#getting-unstuck) - [Account Management](https://gohub.casebook.net/knowledge/customer-support#account-management) - [Product Release Notes](https://gohub.casebook.net/knowledge/product-release-notes#main-content) - [2026](https://gohub.casebook.net/knowledge/product-release-notes#2026) - [2025](https://gohub.casebook.net/knowledge/product-release-notes#2025) - [2024](https://gohub.casebook.net/knowledge/product-release-notes#2024) - [2023](https://gohub.casebook.net/knowledge/product-release-notes#2023) - [2022](https://gohub.casebook.net/knowledge/product-release-notes#2022) - [2021](https://gohub.casebook.net/knowledge/product-release-notes#2021) - [2020](https://gohub.casebook.net/knowledge/product-release-notes#2020) - [Frequently Asked Questions](https://gohub.casebook.net/knowledge/frequently-asked-questions#main-content) - [Global](https://gohub.casebook.net/knowledge/frequently-asked-questions#global) - [Casebook Calendar](https://gohub.casebook.net/knowledge/frequently-asked-questions#casebook-calendar) - [Casebook Services](https://gohub.casebook.net/knowledge/frequently-asked-questions#casebook-services) - [Casebook Forms](https://gohub.casebook.net/knowledge/frequently-asked-questions#casebook-forms) - [Casebook Notes](https://gohub.casebook.net/knowledge/frequently-asked-questions#casebook-notes) - [cb Admin](https://gohub.casebook.net/knowledge/frequently-asked-questions#cb-admin) - [cb Track](https://gohub.casebook.net/knowledge/frequently-asked-questions#cb-track) - [cb Reporting](https://gohub.casebook.net/knowledge/frequently-asked-questions#cb-reporting) - [cb Access](https://gohub.casebook.net/knowledge/frequently-asked-questions#cb-access) - [Program Specific](https://gohub.casebook.net/knowledge/frequently-asked-questions#program-specific) [![logo-raspberry-1-1](https://gohub.casebook.net/hs-fs/hubfs/logo-raspberry-1-1.png?width=32&height=30&name=logo-raspberry-1-1.png "logo-raspberry-1-1")](https://www.casebook.net/) © 2025 Casebook. All rights reserved. Casebook Knowledge Base [Video Library](https://gohub.casebook.net/video-library) [Still Need Help?](https://gohub.casebook.net/knowledge/kb-tickets/new)