Strings functions in SAP analytics cloud are used to performed the task and calculation on string. It is built-in formulas, functions, to create calculations in the modeler or stories in SAC. String functions are the keywords which is specify, what kind of task perform on two or more set of string based on type of string formulas example: LENGTH, TRIM, SPLIT and CONCAT.
These SAP analytics cloud functions are rally helpful to perform a task which is needed to cleaning data to get desire output and dashboard related view and visualization.
Below are the list of all string functions in SAP analytics cloud and you can see the details with example once you will click on the formula in below table
List of String Functions in SAC
SUBSTRING
This function extracts and returns a part of a string, known as a substring. Starting from a specific position and continuing for a defined number of characters. It allows you to isolate or retrieve only a portion of a larger text.
Syntax:
SUBSTRING(string, startIndex, length)
LENGTH
This function calculates and returns the number of characters in a given string, including letters, numbers, spaces, and symbols. It is commonly used to determine how long a piece of text is.
Syntax:
LENGTH (string)
CONCAT
This Concat() function concatenates one specified string with another specified string to form a single string.
Syntax:
CONCAT (string1, string2 )
SPLIT
This function splits a string of text into parts using a specific character or symbol called a delimiter and then returns one of those parts. The process is case sensitive, which means it distinguishes between uppercase and lowercase letters.
Syntax:
SPLIT (string, delimiter, index )
RIGHT
This function returns the specified number of characters from the end of the string.
Syntax:
RIGHT (string, length number)
LEFT
This function returns the specified number of characters from the beginning of the string.
Syntax:
LEFT (string, length number)
FINDINDEX
This string function looks for a specific sequence of characters called as substring, within a larger string and returns the position number where that substring first appears. The position is given as a 0 based index. Returns -1 if the target is not found.
Syntax:
FINDINDEX (string1, string2, startIndex )
REPLACE
This function use to replace one existing string with another specified new string.
Syntax:
REPLACE (string, target, replacement)
LOWERCASE
This function returns lowercase of a String value.
Syntax:
LOWERCASE (String)
UPPERCASE
This function change the lower case into the uppercase of a String. It does not change numbers, symbols, or characters that are already uppercase.
Syntax:
UPPERCASE (String)
ENDSWITH
This function returns true 1 if the string ends with the specified substring. It is case sensitive and doesn’t ignore trailing white spaces.
Syntax:
ENDSWITH (string1, string2 )
Conclusion:
These are the String functions in SAP analytics cloud, which can be used to perform the calculation based on string/dimension, it will really helpful when you are dealing with string manipulation in data. It needed sometime when you deal with data cleaning to get desire output and dashboard related view and visualization.