Report Functions - String | Asite Help Center

Asite Help Center

All CollectionsBusiness AnalyticsTemplatesFunctions

Report Functions - String

Report Functions - String

This article helps you understand report functions of 'String' type.

Updated this week

Commonly used for interpreting and manipulating text fields. Click on a function name below to continue:

Concatenate	Left	Len	Lower	Mid
NewLine	Replace	Right	Trim	Upper
Value

Concatenate

Description	Joins several text strings into one text string.
Remark	The '&' operator can be used instead of CONCATENATE to join text items.
Example	Ex. Concatenate(“This “, “is “, “one string!” ) – returns This is one string!

Left

Description	Returns the first character of a text string.
Remark	The first argument is the string you want to display. The second argument is number of characters you want.
Example	Ex. Left(“example”, 2 ) – returns ex.

Len

Description	Returns the number of characters in a text string.
Remark	---
Example	Ex. Len(“example” ) – returns 7.

Lower

Description	Converts all uppercase letters in a text string to lowercase.
Remark	---
Example	Ex. Lower(“EXAMPLE” ) – returns example.

Mid

Description	Returns a specific number of characters from a text string starting where you specify.
Remark	Mid takes three input argurments: 1. The text string. 2. The place you want to start. 3. The number of characters you want to display.
Example	Ex. Mid(“example” , 2, 3) – returns xam.

NewLine

Description	Begins a new line of text.
Remark	---
Example	---

Replace

Description	Replaces part of a text string.
Remark	Replace takes four input argurments: 1. The text string to partially replaced 2. The place you want to start replacing. 3. The number of characters to replace. 4. The string you want to substitute.
Example	E.x. *Replace('example', 2, 3, '')** – returns e*ple.

Right

Description	Returns the last characters in a text string.
Remark	The first argument is the string you want to display. The second argument is number of characters you want.
Example	Ex. Right('example', 2) – returns le.

Trim

Description	Removes all spaces from text except for single spaces between words.
Remark	---
Example	Ex. Trim('This sentence has weird spacing.', 2) – returns This sentence has weird spacing.

Upper

Description	Converts text to uppercase.
Remark	---
Example	Ex. Upper('example') – returns EXAMPLE.

Value

Description	Converts a text string that represents a number to a number.
Remark	---
Example	Ex. Value('$1,000') – returns 1000.

Next Article: Report Functions - Formatting