LogoLogo
ProductsPricingGlossary Launch Acho
  • 🎉Welcome
  • Introduction
  • What is Acho?
  • How does Acho work?
    • Proof of Concept (PoC)
  • App Builder
    • Get Started
    • Core Concepts
    • Overview
    • App construction
      • App Configuration
      • Pages
      • Interactions
        • Add an interaction
        • Add conditions to interactions
        • Event payload
        • Ordering interactions with action flow
        • Transformer
        • Actions
          • Navigation
          • Element
          • Data Source
          • App
          • Page
          • API Service
          • Database
          • Media Service
      • Table
      • Metric
      • Query
      • Data Store
      • Elements
        • Table & Chart
          • Searchable Table
          • Table
          • Chart
          • Score Card
        • Form Elements
          • Form
          • Search Bar
          • Checkbox
          • Date Picker
          • Custom Form
          • Input
          • Multiselect
          • Radio Button
          • Radio List
          • Rich Text Editor
          • Select
          • Switch
          • Textarea
          • Upload
        • Web Elements
          • Badge
          • Button
          • Clickable
          • Collapse Menu
          • Divider
          • Icon
          • Image
          • Link
          • Message
          • Modal
          • Notification
          • Pagination
          • Popover
          • Rate
          • Rich Text
          • Tabs
          • Text
        • Layout Elements
          • Container
          • List
        • Advanced elements
          • Code Block
          • Condition
          • Print
        • CSS Styles
          • General techniques
          • Layout
          • Spacing
          • Size
          • Position
          • Typography
          • Background
          • Border
          • Effect
        • Form Check
        • Tooltip
      • Accessors
      • Plugin Store
    • Popular Use Cases
      • Build a chart from Table Nodes
      • Create a table
      • Create a list
      • Create a filter
      • Create a search bar
      • Use Custom Form Container to collect user inputs
      • Drill down on a table
      • Download file from query node
      • Set loading animations
      • Modify a database
      • Navigate to a different page
      • Set up dynamic routing
      • Update app data using accessors
      • Create a Chart with Code Block and D3 Library
      • Rich text and rich text editor
      • Send an Email via Mailjet Plugin
    • Preview
    • Publish
      • Embed published app on website
    • Version Control
    • App User Management
      • Onboarding Page
      • Sign in page
      • Guest Isolation and Private Session
    • Theme
    • FAQ
  • Acho Studio
    • Quick Start
    • Resources
      • Add a resource
      • Supported data sources
        • Airtable
        • Amazon Ads
        • Amplitude
        • Amazon Seller Partner
        • Apify Dataset
        • Appstore
        • Asana
        • API Connector
        • API Template
        • AWS CloudTrail
        • Azure Table Storage
        • Batch Files
        • Bamboo HR
        • BigCommerce
        • BigQuery
        • Bing Ads
        • Braintree
        • Cart.com
        • Chargebee
        • Chargify
        • Chartmogul
        • Clickhouse
        • Close.com
        • CockroachDB
        • Confluence
        • Customer.io
        • Delighted
        • Dixa
        • Drift
        • Facebook Marketing
        • Freshdesk
        • Freshsales
        • Freshservice
        • GitHub
        • GitLab
        • Google Ads
        • Google Analytics
        • Google Sheets
        • Google Search Console
        • Greenhouse
        • Harness
        • Harvest
        • HubSpot
        • IBM Db2
        • Instagram
        • Intercom
        • Iterable
        • Jenkins
        • Jira
        • Kafka
        • Klaviyo
        • Kustomer
        • Lemlist
        • Lever Hiring
        • LinkedIn Ads
        • Linnworks
        • Mailchimp
        • Marketo
        • Microsoft Teams
        • Mixpanel
        • Monday
        • MongoDB
        • MySQL
        • My Hours
        • NetSuite
        • Notion
        • Okta
        • OneDrive
        • OneSignal
        • Oracle DB
        • Outreach
        • PagerDuty
        • Paypal Transaction
        • Paystack
        • Pipedrive
        • PersistIq
        • Pinterest
        • Plaid
        • PostgreSQL
        • PostHog
        • PrestaShop
        • Qualaroo
        • QuickBooks
        • Recharge
        • Recurly
        • Remote File
        • S3
        • Salesforce
        • Salesloft
        • SearchMetrics
        • Sendgrid
        • Sentry
        • Short.io
        • Shopify
        • Single File
        • Slack
        • Smartsheets
        • Snapchat Marketing
        • Snowflake
        • SQL Server
        • Square
        • Stripe
        • SurveyMonkey
        • Tempo
        • TikTok Marketing
        • Trello
        • Twilio
        • Typeform
        • VictorOps
        • WooCommerce
        • YouTube Analytics
        • Zendesk Chat
        • Zendesk Sunshine
        • Zendesk Talk
        • Zendesk Support
        • Zenloop
        • Zoho CRM
        • Zoom
        • Zuora
    • Data Prep (Projects)
      • Create a Data Prep Project
        • Create a table tab
        • Copy a table tab
        • Hide a table tab
      • Apply an action
        • View
          • Hide Columns
          • Filter
          • Sort
          • Cut
          • Rename
          • Move Column
        • Combine Tables
          • Join
          • Union
        • Transformation
          • Pivot Table
          • Unpivot
        • Data Cleaning
          • Cleanse
          • Replace
          • Change Type
          • Deduplicate
          • Split
          • Flatten
        • Tools
          • Formula
          • SQL Editor
            • SQL Editor Queries
            • All functions in Formula/SQL
              • Mathematical Functions
              • String Functions
              • Date Functions
              • Datetime Functions
              • Time Functions
              • Timestamp Functions
              • Conditional Functions
              • Type Conversion
              • Other Functions
        • Reserved Keywords
      • Pipeline
      • Edit your pipelines
      • Generate column summary for inspection
      • Use URL to access and share your project
      • Write a description for your project
      • Delete a resources/project/tab
    • Data Flow
      • Export data
        • Download CSV files
        • Excel Connector
        • Google Sheets Connector
        • Embed a table on your website
          • Data Usage Agreement
        • Apache Superset
        • Chartio
        • Looker
        • Metabase
        • Power BI
        • Qlik
        • Tableau
        • MongoDB
        • MySQL
        • MSSQL
        • Snowflake
        • PostgreSQL
        • BigQuery
    • Set up Data Sync
    • FAQ
  • Organization
    • Get started
    • Create an organization
    • Invite people to your organization
    • Share your resources
    • Share your projects
    • Share your apps
    • Change payment method on file
  • FAQ
    • I can't find data after uploading a big CSV file
Powered by GitBook
On this page

Was this helpful?

Last updated 4 years ago

Was this helpful?

CONCAT

CONCAT(string1, string2...)

Description

Concatenate one or more strings into a single string.

Example

Result: Acho_Studio

ASCII

ASCII(string)

Description

Return the ASCII code value of the first character in a string.

Example

Result: 97

Result: 97

ENDS_WITH

ENDS_WITH(string, substring)

Description

Return True if the string ends with the substring.

Example

Result: True

Result: False

INITCAP

INITCAP(string, [delimiters])

Description

Make the first letter of each word uppercase and the rest of the letters lowercase. Words are delimited by white space or other characters that you can specify in delimiters.

Example

Result: "Acho Studio"

Result: "Acho_Studio"

INSTR

INSTR(string, subsstring, [position], [occurence])

Description

Return the position of the first substring in the string. 0 is returned when no match is found. Position determines where the search starts in a string. Occurrence refers to extract the i-th occurrence (ex: 2 means second occurrence).

Example

Result: 4 (the position of the first "o")

Result: 11 (the position of the first "o" from the sixth character)

Result: 2 (the position of the second "o" from the first character)

LEFT

LEFT(string, num_chars)

Description

Return the specified number of characters from the start of the given string.

Example

Result: "Ac"

LENGTH

LENGTH(string)

Description

Return the length of a string in characters or bytes.

Example

Result: 4

LOWER

LOWER(string)

Description

Convert a text string to all lowercase letters.

Example

Result: "acho"

LTRIM

LTRIM(string, [substring])

Description

Remove all leading spaces. If you want to remove strings other than spaces, you can optionally specify a substring.

Example

Result: "Acho "

Result: "Acho#"

REGEXP_CONTAINS

REGEXP_CONTAINS(string, regexp)

Description

Example

Result: True

Result: False

REGEXP_EXTRACT

REGEXP_EXTRACT(string, regexp, position, occurence)

Description

Example

Result: "contact"

REPLACE

REPLACE(original_string, from_value, to_value)

Description

Replace all occurrences of from_value with to_value in original_string. If the from_value is not found, the string is unchanged.

Example

Result: "apple cobbler"

RIGHT

RIGHT(string, num_chars)

Description

Return the specified number of characters from the end of the given string.

Example

Result: "ho"

RTRIM

RTRIM(string, [substring])

Description

Remove all trailing spaces. If you want to remove strings other than spaces, you can optionally specify a substring.

Example

Result: " Acho"

Result: "###Acho"

STARTS_WITH

STARTS_WITH(string, substring)

Description

Return True if the string ends with the substring.

Example

Result: True

Result: False

STRPOS

STRPOS(string, substring)

Description

Return the position of the substring within a specified string. If the substring occurs in several positions, it will only return the first occurrence.

Example

Result: 4

SUBSTR

SUBSTR(string, position, [length])

Description

Extract a substring from the given string, which starts at the position. The position refers to the position of a character in the given string. You can optionally specify the length to decide the number of characters that you want to extract.

Example

TRIM

TRIM(string, [substring])

Description

Remove all leading and trailing spaces. If you want to remove strings other than spaces, you can optionally specify a substring.

Example

Result: "Acho"

Result: "Acho"

UPPER

UPPER(string)

Description

Convert a text string to all uppercase letters.

Example

Result: "ACHO"

Return True if a string is a partial match for the regular expression pattern. To see supported regular expression, visit .

Extracts the substring of the given string that matches the regular expression pattern. Returns NULL if there is no match. To see supported regular expression, visit . Position determines where the search starts in a string. Occurrence refers to extract i-th occurrence (ex: 2 means second occurrence).

CONCAT("Acho", "_", "Studio")
ASCII('a')
ASCII('acho')
ENDS_WITH("Acho", "o")
ENDS_WITH("Apple", "o")
INITCAP("acho studio")
INITCAP("ACHO_STUDIO", "_")
INSTR("Acho Studio", "o"),
INSTR("Acho Studio", "o", 6),
INSTR("Acho Studio", "o", 1, 2)
LEFT("Acho", 2)
LENGTH('acho')
LOWER("ACHO")
TRIM("   Acho   ")
TRIM("###Acho#", "#")
REGEXP_CONTAINS("contact@acho.io", r"@[a-zA-Z0-9-]+\.[a-zA-Z0-9-.]+")
REGEXP_CONTAINS("acho.io", r"@[a-zA-Z0-9-]+\.[a-zA-Z0-9-.]+")
REGEXP_EXTRACT("contact@acho.io", r"^[a-zA-Z0-9_.+-]+")
REPLACE("apple pie", "pie", "cobbler")
RIGHT("Acho", 2)
TRIM("   Acho   ")
TRIM("###Acho#", "#")
ENDS_WITH("Acho", "A")
ENDS_WITH("Acho", "E")
STRPOS('Acho Studio', 'o')
SUBSTR("Acho Studio", 3)
Return: "ho Studio"
SUBSTR("Acho Studio", 4, 5)
Return: "o Stu"
TRIM("   Acho   ")
TRIM("###Acho#", "#")
UPPER("Acho")
  1. Acho Studio
  2. Data Prep (Projects)
  3. Apply an action
  4. Tools
  5. SQL Editor
  6. All functions in Formula/SQL

String Functions

PreviousMathematical FunctionsNextDate Functions
  • CONCAT
  • ASCII
  • ENDS_WITH
  • INITCAP
  • INSTR
  • LEFT
  • LENGTH
  • LOWER
  • LTRIM
  • REGEXP_CONTAINS
  • REGEXP_EXTRACT
  • REPLACE
  • RIGHT
  • RTRIM
  • STARTS_WITH
  • STRPOS
  • SUBSTR
  • TRIM
  • UPPER
here
here