Text Expression in Appsheet feature in Appy Pie.

Text Expression

LEN

The character count in a text is returned by the LEN function.

Syntax

LEN([column])

Example

LEN("Hello") : 5

LEN("") : 0

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

EQUAL(10, LEN([Serial Number])): TRUE if the length of the character in Serial Number is exactly 10.

EQUAL(0, LEN([Some Column])) : TRUE if Some Column has no value.

GREATERTHAN(0,LEN([Some Column]) : TRUE if Some Column has a value.

Arguments

Text of any type.

Return Value

Number: This function returns character count in a text.

Learn more about LEN


LEFT

The left-most characters of a text are extracted using the LEFT function.

Syntax

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

Example

LEFT([Base], 3) : Bas

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

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

Arguments

  • Text of any type


            Note: Non-Number values may be accepted but unexpected results may occur.

  • Number : The number of characters to be extracted from the text.

     

Return Value

Text: The starting number of characters from the text.
Note: If the number of characters is greater than the length of text or less than 0, the text is returned completely.
 
Learn more about LEFT


RIGHT

The RIGHT function returns the rightmost 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

  • Text of any type


                  Note: Non-Number values may be accepted but unexpected results may occur.

  • Number : The number of characters to be extracted from the text.


Return Value

Text: The last number of characters from the text.
Note: If the number of characters is greater than the length of text or less than 0, the text is returned completely.

Learn more about RIGHT


Trim

TRIM removes spaces from the beginning and end of the string, and removes duplicate spaces from the interior of the string.

Syntax

TRIM(text)
TRIM([column_1]) 

Argument

Text from which we wish to remove spaces.

Example

TRIM([Function]): It will remove spaces from the Function column.  


CONCATENATE
 
A new text is returned by the CONCATENATE function after merging together each text in the order given.
 
Syntax
 
CONCATENATE([column_1],[COLUMN_2])
 
Example

 
CONCATENATE([Ba],[Number]) : Ba Number

CONCATENATE("Good", " ", "evening", "!") : Good evening!
 
CONCATENATE("Good evening, ", [First Name], "!") : Good evening, 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 merged text.
 
Return Value
 
Text: A new value after merging together of each part in the order given.
 
Learn more about CONCATENATE


FIND
 
The position of the character in a text is determined by the FIND function.
 
Syntax
 
FIND([Fragment], [find])
 
Example

 
FIND("a", "abc") : 1
 
FIND("b", "abc") : 2
 
FIND("f", "abc") : 0
 
FIND("Red", "I'm bored!") returns 0 as Red--with an uppercase R--doesn't occur in I'm bored!.
 
FIND(UPPER("Red"), UPPER("I'm bored!")) returns 7 as 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 at which the fragment was found, or zero (0) if not found.

Note: Search is case-sensitive, that is both upper- and lower-case letters are not equivalent.

Learn more about FIND


UPPER

The text is converted to uppercase using the UPPER function.

Syntax
 
UPPER(text-to-convert-to-upper-case)
 
Example
 
UPPER([Text]) : TEXT
 
Arguments
 
Text of any type
 
Return Value

Text: conversion of all lowercase letters to uppercase in a text.
 
Learn more about UPPER


LOWER
 
The text is converted to lowercase using the LOWER function.

Syntax
 

LOWER(text-to-convert-to-lower-case)
 
Example
 
LOWER([Text]) : text
 
Arguments
 
Text of any type
 
Return Value

 
Text: conversion of all uppercase letters to lowercase in a text.
 



 

Share this :

Was this article helpful?

Reviews on this page are powered by Trustpilot where Appy Pie is rated 4.9 with 2118+ Excellent reviews.You can post a review for Appy Pie on Trustpilot by clicking on Write a review.