Datameer Product Documentation
Spaces
Apps
Templates
Create
Datameer X v10
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
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
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
Joining 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
Glossary
Contact & Help
Blogs
You‘re viewing this with anonymous access, so some content might be blocked.
Close
Datameer X v10
/
LEFT
LEFT
Juliane Wetzel
Owned by
Juliane Wetzel
Feb 07, 2020
Analytics
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
, multiple selections available,
Related content
Info icon
Collapse
LEFT
LEFT
Datameer X v11
More like this
LEFT
LEFT
Datameer v7
More like this
RIGHT
RIGHT
Datameer X v11
More like this
RIGHT
RIGHT
Datameer X v10
More like this
RIGHT
RIGHT
Datameer v7
More like this
CODE
CODE
Datameer v7
More like this
{"serverDuration": 15, "requestCorrelationId": "5f8dd7212651474abb3c64306f91e69f"}