List of ER functions of the text category
Electronic reporting (ER) text functions can be used to perform operations on data sources of the String data type. This article provides a summary of these functions.
List of supported functions
Function | Description |
---|---|
Char | This function returns a String value that presents a single character that is referenced by the specified Unicode number. |
Concatenate | This function returns all the specified text strings as a String value after they have been joined into one string. |
Format | This function returns the specified string a String value after it has been formatted by substituting any occurrences of %N with the Nth argument. |
GetEnumValueByName | This function searches for a specific Enum value in the specified enumeration data source by using the enumeration name that is specified as a String value. If the Enum value is found, the function returns it. |
GetLabelText | This function searches for a specific label to return a String value that represents the translation of the specified label in the specified language. |
GuidValue | This function converts the specified input of the String type to a data item of the GUID type. |
JsonValue | This function parses data in JavaScript Object Notation (JSON) format that is accessed at the specified path, and it extracts a scalar value that is based on the specified ID. It then returns the extracted scalar value as a String value. |
Left | This function returns a String value that presents the specified number of characters from the start of the specified string. |
Len | This function returns an Integer value that presents the number of characters in the specified string. |
Lower | This function returns the specified text string as a String value after it has been converted to lowercase letters. |
Mid | This function returns a String value that presents the specified number of characters from the specified string, starting at the specified position. |
NewGUID | This function returns a newly generated GUID value. |
NumberFormat | This function returns a String value that presents the specified number in the specified format and in an optionally specified culture. |
NumeralsToText | This function returns the specified number as a String value after it has been spelled out (that is, converted to text strings) in the specified language. |
PadLeft | This function returns a String value of the specified length, where the start of the specified string is padded with one or more instances of the specified characters. |
QrCode | This function returns a Container value that presents the Quick Response code (QR code) image for the specified string in binary format. |
Replace | This function returns the specified text string as a String value after all or part of it has been replaced with another string. |
Right | This function returns a String value that presents the specified number of characters from the end of the specified string. |
Text | This function returns the specified number as a String value after it has been converted to a text string that is formatted according to the server locale settings of the current application instance. |
Translate | This function returns a String value that contains the result of the replacement the specified text in characters for another provided set of characters. |
Trim | This function returns the specified text string as a String value after tab, carriage return, line feed, and form feed characters have been replaced by a single space character, after leading and trailing spaces have been truncated, and after multiple spaces between words have been removed. |
Upper | This function returns the specified text string as a String value after it has been converted to uppercase letters. |
Additional resources
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru