Text Functions
Asc
Returns an Integer value representing the character code corresponding to a character.
=Asc(Fields!Description.Value)
AscW
Returns an Integer value representing the character code corresponding to a character.
=AscW(Fields!Description.Value)
Chr
Returns the character associated with the specified character code.
=Chr(65)
ChrW
Returns the character associated with the specified character code.
=ChrW(241)
Filter
Returns a zero-based array containing a subset of a String array based on specified filter criteria.
=Filter(Parameters!MultivalueParameter.Value, "3", True, CompareMethod.Binary)
Format
Returns a string formatted according to instructions contained in a format String expression.
=Format(Globals!ExecutionTime, "Long Date")
FormatCurrency
Returns an expression formatted as a currency value using the currency symbol defined in the system control panel.
=FormatCurrency(Fields!YearlyIncome.Value,0)
FormatDateTime
Returns a string expression representing a date/time value.
=FormatDateTime(Fields!BirthDate.Value,DateFormat.ShortDate)
FormatNumber
Returns an expression formatted as a number.
=FormatNumber(Fields!Weight.Value,2)
FormatPercent
Returns an expression formatted as a percentage (that is, multiplied by 100) with a trailing % character.
=FormatPercent(Fields!Sales.Value/Sum(Fields!Sales.Value, "DataSet1"),0)
GetChar
Returns a Char value representing the character from the specified index in the supplied string.
=GetChar(Fields!Description.Value, 5)
InStr
Returns an integer specifying the start position of the first occurrence of one string within another.
=InStr(Fields!Description.Value, "car")
InStrRev
Returns the position of the first occurrence of one string within another, starting from the right side of the string.
=InStrRev(Fields!Description.Value, "car")
Join
Returns a string created by joining a number of substrings contained in an array.
=Join(Parameters!MultivalueParameter.Value,",")
LCase
Returns a string or character converted to lowercase.
=LCase(Fields!Description.Value)
Left
Returns a string containing a specified number of characters from the left side of a string.
=Left(Fields!Description.Value,4)
Len
Returns an integer containing either the number of characters in a string or the number of bytes required to store a variable.
=Len(Fields!Description.Value)
LSet
Returns a left-aligned string containing the specified string adjusted to the specified length.
=LSet(Fields!Description.Value,4)
LTrim
Returns a string containing a copy of a specified string with no leading spaces (LTrim), no trailing spaces (RTrim), or no leading or trailing spaces (Trim).
=LTrim(Fields!Description.Value)
Mid
Returns a string containing a specified number of characters from a string.
=Mid(Fields!Description.Value,3,4)
Replace
Returns a string in which a specified substring has been replaced with another substring a specified number of times.
=Replace(Fields!Description.Value,"tube","headlight")
Right
Returns a string containing a specified number of characters from the right side of a string.
=Right(Fields!Description.Value,4)
RSet
Returns a right-aligned string containing the specified string adjusted to the specified length.
=RSet(Fields!Description.Value,4)
RTrim
Returns a string containing a copy of a specified string with no leading spaces (LTrim), no trailing spaces (RTrim), or no leading or trailing spaces (Trim).
=RTrim(Fields!Description.Value)
Space
Returns a string consisting of the specified number of spaces.
=Space(3)
Split
Returns a zero-based, one-dimensional array containing a specified number of substrings.
=Split(Fields!ListWithCommas.Value,",")
StrComp
Returns -1, 0, or 1, based on the result of a string comparison.
=StrComp(Fields!Description.Value,First(Fields!Description.Value))
StrConv
Returns a string converted as specified.
=StrConv(Fields!Description.Value,vbProperCase)
StrDup
Returns a string or object consisting of the specified character repeated the specified number of times.
=StrDup(3,"M")
StrReverse
Returns a string in which the character order of a specified string is reversed.
=StrReverse(Fields!Description.Value)
Trim
Returns a string containing a copy of a specified string with no leading spaces (LTrim), no trailing spaces (RTrim), or no leading or trailing spaces (Trim).
=Trim(Fields!Description.Value)
UCase
Returns a string or character containing the specified string converted to uppercase.
=UCase(Fields!Description.Value)
No comments:
Post a Comment