Datameer Product Documentation
Spaces
Apps
Templates
Create
Datameer v7
All content
Space settings
Content
Results will update as you type.
New and Noteworthy
Smart Execution
Guide for Analysts
Importing and Accessing Data
Working with Workbooks
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
•
INDEX
•
JSON_ELEMENT
•
JSON_ELEMENTS
•
JSON_KEYS
•
JSON_MAP
•
JSON_VALUE
•
JSONARRAYSIZE
•
JSONTOLIST
•
LEFT
•
LEN
•
LOWER
•
LTRIM
•
MATCHES
•
NGRAM
•
NGRAM_OLD
•
PROPER
•
REGEX
•
REGEXTRACT
•
REPLACE
•
REPLACEALL
•
REPT
•
RIGHT
•
RTRIM
•
SPLIT
•
STARTSWITH
•
SUBSTITUTEALL
•
SUBSTITUTEFIRST
•
SUBSTR
•
T
•
TOKENIZE
•
TRIM
•
UPPER
Text Mining Functions
Trigonometry Functions
URL Functions
XML Functions
Smart Analytics
•
Visual Exploration
SQL Worksheet
•
Flip Side
Filtering Data
Joining Data
•
Sorting Data
•
Unioning Data
•
Pivoting Data
•
Configuring Workbook Settings
•
Workbook Tips and Tricks
Visualizing Data
Exporting Data
Datameer App Market
Setup Guide
Administration Guide
Guide for Developers
•
Glossary
Contact - Help - Evaluation
Blogs
Datameer v7
/
/
Text Functions
/
LEFT
Summarize
LEFT
Charles Bishop (Deactivated)
Owned by
Charles Bishop (Deactivated)
Jan 30, 2018
1 min read
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