Essayer gratuitement

Text Expression in Appsheet feature in Tessarl.

LEN

The LEN function returns the character count in a text.

Syntax

LEN([column])

Example

LEN("Hello") : 5

LEN([Home Phone]) : The length of the Home Phone column value.

LEN("") : 0

(LEN([Some Column] & "") = 0) : TRUE if Some Column has no value.

(LEN([Some Column] & "") > 0) : TRUE if Some Column has a value.

(LEN([Serial Number]) = 10) : TRUE if Serial Number is exactly 10 characters long.

Arguments

some-text (any textual type)

Return Value

Number: The count of characters in some-text.

LEFT

The LEFT function returns the left most characters of a text.

Syntax

LEFT([column],number-of-characters)

Example

LEFT([Base], 2) = Ba

LEFT("123 Maple Dr", 5) : 123 M

LEFT("123 Maple Dr", 0) returns blank.

First & Last Initials

Initials from a first and last name:

LEFT([First Name], 1) & LEFT([Last Name], 1)

• LEFT(..., 1) gets the first character of the specified column value.

• LEFT(...) & LEFT(...) concatenates the two initials into a single text value.

Arguments

some-text (any textual type)
how-many (Number) : The number of characters from some-text to return. Non-Number values may be accepted but may produce unexpected results.

Return Value

Text: The first how-many characters from some-text. If how-many is greater than the length of some-text or less than 0, some-text is returned in its entirety.

RIGHT

The RIGHT function returns the right most characters of a text.

Syntax

RIGHT([column],number-of-characters)

Example

RIGHT([Base], 2) = se

RIGHT("123 Maple Dr", 5) : le Dr

RIGHT("123 Maple Dr", 0) returns blank.

Arguments

some-text (any textual type)
how-many (Number) : The number of characters from some-text to return. Non-Number values may be accepted but may produce unexpected results.

Return Value

Text: The last how-many characters from some-text. If how-many is greater than the length of some-text or less than 0, some-text is returned in its entirety.

CONCATENATE

The CONCATENATE function returns a new text after merging together each texts in the order given.

Syntax

CONCATENATE([column_1],[COLUMN_2])

Example

CONCATENATE([Base],[Num]) = Base Num

CONCATENATE("Good", "morning", "!") : Goodmorning!

CONCATENATE("Good", " ", "morning", "!") : Good morning!

CONCATENATE("Good morning, ", [First Name], "!") : Good morning, Martin!

CONCATENATE([Last Name], ", ", [First Name]) : Sandwich, Martin

CONCATENATE("Today is ", MONTH("4/1/2010"), "/", DAY("4/1/2010"), ".") : Today is 4/1.

Arguments

part (any type): A value to be included in the combined text.

Return Value

Text: A new value consisting of each part merged together in the order given.

FIND

The FIND function returns the position of the character in a text.

Syntax

FIND([Fragment], [find])

Example

FIND("a", "abc") : 1

FIND("bc", "abc") : 2

FIND("d", "abc") : 0

FIND("Red", "I'm bored!") returns 0 because Red--with an uppercase R--doesn't occur in I'm bored!.

FIND(UPPER("Red"), UPPER("I'm bored!")) returns 7 because the all-uppercase RED occurs at that position in the all-uppercase I'M BORED!.

FIND("@", [Email]) returns the position of the first at sign (@) in Email, or 0 if not present.

Return Value

Number : The position in the search value (haystack) at which the fragment (needle) was found, or zero (0) if not found. Note that the search is case-sensitive: upper- and lower-case letters are different.

UPPER

The UPPER function converts the text to uppercase.

Syntax

UPPER(text-to-convert-to-upper-case)

Example

UPPER([Base]) = BASE

Arguments