What is the MySQL ACOS function

Tableau Features (by Category)

function

syntax

definition

ASCII

Returns the ASCII code for the first character of.

Example:

CHAR

Returns the character for the ASCII encoded.

Example:

CONTAINS

Returns TRUE if the string contains the specified substring.

Example:

ENDSWITH

Returns TRUE if the string ends with the specified substring. Trailing spaces are ignored.

Example:

FIND

Returns the index position of in or 0 if not found. If the optional argument is added, the function ignores all instances that occur before the index position. The first character in the string is position 1.

Examples:








FINDNTH

Returns the position of the nth occurrence of a substring in a specified string, where n is defined by the occurrence argument.

Note: FINDNTH is not available for all data sources.

Example:

LEFT

Returns the left part of a string with the specified number of characters.

Example:

LEN

Returns the length of the string.

Example:

LOWER

Outputs in lower case only.

Example:

LTRIM

Returns the string removing any leading spaces.

Example:

MAX

Returns the maximum for and (which must be of the same type). This function is usually used to compare numbers, but can also be used for strings. For strings, finds the highest value in the collating sequence defined by the database for that column. Returns if either of the two arguments has the following value:.

Example:

MID

Returns the string starting at the index position. The first character in the string is position 1. If the optional argument is added, the returned string contains only the specified number of characters.

Examples:


MIN

Returns the minimum of and (which must be of the same type). This function is usually used to compare numbers, but can also be used for strings. For strings, finds the lowest value in the collating sequence. Returns if either of the two arguments has the following value:.

Example:

REPLACE

Look for for and replace it with. If it is not found, the string remains unchanged.

Example:

RIGHT

Returns the right part of a string with the specified number of characters for.

Example:

RTRIM

Returns, removing any trailing spaces.

Example:

SPACE

Returns a string consisting of the number of spaces specified under.

Example:

SPLIT

Returns a substring of a string and divides the string into a sequence of tokens based on delimiters.

The string is interpreted as an alternating sequence of separators and tokens. For example, for the character string with the separator ‘- die, the tokens are abc, defgh, i, and jkl. Think of these as tokens 1 through 4. SPLIT returns the tokens according to their token number. If the token number is positive, the tokens are counted from the left end of the string. If the token number is negative, they are counted from the right end.

Examples:



Note: The Share and Custom Share commands are available for the following types of data sources: Tableau Data Extracts, Microsoft Excel, Text File, PDF File, Salesforce, OData, Microsoft Azure Market Place, Google Analytics, Vertica, Oracle, MySQL, PostgreSQL , Teradata, Amazon Redshift, Aster Data, Google Big Query, Cloudera Hadoop Hive, Hortonworks Hive and Microsoft SQL Server.

Some data sources have limits on how a string can be split. The following table shows which data sources support negative token numbers (division from the right) and whether there is a limit to the number of divisions permitted per data source. A SPLIT function that specifies a negative token number and would be permitted with other data sources will return this error for these data sources: "The data source does not support splitting from the right."

Data SourceLeft / Right RestrictionsMaximum number of splitsVersion restrictions
Tableau Data ExtractBothUnlimited
Microsoft ExcelBothUnlimited
Text fileBothUnlimited
SalesforceBothUnlimited
ODataBothUnlimited
Google AnalyticsBothUnlimited
Tableau data serverBothUnlimitedSupported in version 9.0.
VerticaOnly left10
OracleOnly left10
MySQLBoth10
PostgreSQLLinks only for version prior to 9.0, both for version 9.0 and higher10
TeradataOnly left10Version 14 and higher
Amazon RedshiftOnly left10
Aster DatabaseOnly left10
Google BigQueryOnly left10
Hortonworks Hadoop HiveOnly left10
Cloudera HadoopOnly left10Impala is supported from version 2.3.0.
Microsoft SQL ServerBoth102008 and higher

STARTSWITH

Returns true if starts with. Leading spaces are ignored.

Example:

TRIM

Returns the string, removing all leading and trailing spaces.

Example:

UPPER

Returns a string in uppercase only.

Example: