Datameer Product Documentation
Spaces
Apps
Templates
Create
Datameer X v11
All content
Space settings
Content
Results will update as you type.
New and Noteworthy
•
General Information
Product Description
Setup and Installation
Administration Guide
Importing and Accessing Data
Working with Workbooks
Workbook General Information
•
Workbook Sheet Types
Datameer Functions
•
Alphabetical List of Supported Datameer Functions
•
Using the Formula Builder
•
Using Operators
•
Using Regular Expressions
•
Convert Data Field Types with Functions
Comparison Functions
Date and Time Functions
Encoding Functions
File Functions
General Functions
Grouping Functions
HTML Functions
List Functions
Logical Functions
Math Functions
Statistical Functions
Text Functions
•
CHAR
•
CODE
•
CONCAT
•
CONTAINS
•
CONTAINS_IC
•
COUNTMATCHES
•
COUNTTEXT
•
ENDSWITH
•
ERRORMATCHES
•
INDEX
•
JSON_ELEMENT
•
JSON_ELEMENTS
•
JSON_KEYS
•
JSON_MAP
•
JSON_VALUE
•
JSONARRAYSIZE
•
JSONTOLIST
•
LEFT
•
LEN
•
LOWER
•
LTRIM
•
MATCHES
•
NGRAM
•
NGRAM_OLD
•
PROPER
•
REGEX
•
REGEXTRACT
•
REGEXTRACT_LIST
•
REPLACE
•
REPLACEALL
•
REPT
•
RIGHT
•
RTRIM
•
SPLIT
•
STARTSWITH
•
SUBSTITUTEALL
•
SUBSTITUTEFIRST
•
SUBSTR
•
T
•
TOKENIZE
•
TRIM
•
UPPER
•
LIKE
•
MATCHING_DICTIONARY
•
MATCHING_DICTIONARY_FUZZY
•
SIMILARTO
Text Mining Functions
Trigonometry Functions
URL Functions
XML Functions
Smart Analytics
•
Smart Sampling
•
Workbook Inspector
•
Workbook Settings
•
Workbook Sharing Permissions and Security Settings
•
Workbook Details
•
Workbook Tips and Tricks
•
Creating a Workbook
•
Storing a Workbook
•
Viewing a Workbook
Working with Sheets, Columns and Cells
•
Adding Additional Data Soucres
•
Exchanging Data Sources
•
Using Variables Within Workbooks
•
Sorting Data
•
Filtering Data
Join Data
•
Unioning Data
•
Pivoting Data
•
Deduplicating Data
•
Using Formulas
Working With Date and Time Information
Using SQL Sheets
•
Flipping a Sheet
•
Using Smart Analytics
•
Using the Visual Explorer
•
Reverting Actions
•
Launching Production Mode
•
Synchronizing Workbooks
•
Optimizing a Workbook
•
Completing Workbook Level Tasks
Exporting Data
Smart Execution
Guide for Developers
Visualizing Data (Deprecated)
Contact & Help
•
Glossary
Blogs
Datameer X v11
/
/
Text Functions
/
LEFT
Summarize
LEFT
Juliane Wetzel
Konsta Danyliuk (Deactivated)
Owned by
Juliane Wetzel
Last updated:
May 10, 2023
by
Konsta Danyliuk (Deactivated)
Loading data...
Syntax
LEFT(<
string
>;<
number
>)
Description
Returns the leftmost characters from a text value.
Examples
Column1
Number
LEFT returns
Hello Hannes
3
Hel
Datameer
5
Datam
Good morning
2
Go
{"serverDuration": 12, "requestCorrelationId": "5ec70d226cb742aab0d0c9ac1657cba9"}