The text function enables you to return part of a string, search for text within a string, or concatenate string values. Some additional functions help you to control the formats for dates, times, and numbers.
Following is the list of text functions supported in Wyn Enterprise:
Description
The CONCATENATE function joins two text strings into one text string.
Syntax
CONCATENATE(<text1>, <text2>)
Parameters
Return Value
The concatenated string.
Example
CONCATENATE("Year:",Year('Sale'[Date]))
The CONCATENATEX function concatenates the result of an expression evaluated for each row in a table.
CONCATENATEX(<table>, <expression> [,delimiter])
A text string.
CONCATENATEX(Addresses, [Country] & " " & [City], ",")
The FIND function returns the starting position of one text string within another text string. FIND is case-sensitive.
FIND(<find_text>, <within_text>)
The number shows the starting point of the text string you want to find.
FIND("Jack", 'Customer'[Name])
The LEFT function returns the specified number of characters from the start of a text string.
LEFT(<text>, <num_chars>)
LEFT('Product'[Name], 3)
The LEFTTRIM function removes all spaces from text left except for single spaces between words.
LEFTTRIM(<text>)
The string with spaces removed.
LEFTTRIM('Product'[ColorName])
The LEN function returns the number of characters in a text string.
LEN(<text>)
A whole number that indicates the number of characters in the text string.
LEN('Product'[Name])
The LOWER function converts all letters in a text string to lowercase.
LOWER(<text>)
Text in lowercase.
LOWER('Product'[Name])
The MID function returns a string of characters from the middle of a text string, given a starting position and length.
MID(<text>, <start_num>, <num_chars>)
A string of text of the specified length.
MID("abcde", 2, 1))
The REPLACE function replaces part of a text string, with a different text string.
REPLACE(<source>, <old_text>, <new_text>)
REPLACE('Products'[ProductName],"OB","OC")
The RIGHT function returns the last character or characters in a text string, based on the number of characters you specify.
RIGHT(<text>, <num_chars>)
A text string containing the specified right-most characters.
RIGHT('Products'[ProductName], 3)
The RIGHTTRIM function removes all spaces from text right except for single spaces between words.
RIGHTTRIM(<text>)
RIGHTTRIM('Product'[ColorName])
The UPPER function converts a text string to all uppercase letters.
UPPER (<text>)
The same text, in uppercase.
UPPER ('Product'[Name])