Text Functions

CONCATENATE

CONCATENATE(text1,text2,…)

Joins two or more text strings into one string.

For example, CONCATENATE(A,B,C), returns ABC.

Note:
Use commas to separate adjoining text items and use quotation marks to wrap strings.

For example, you can set the following Formula to concatenate time, name, and student number into a new string:

CONCATENATE(TEXT(DATE(time),"yyyyMMdd"),"-","name","-","student number")

CHAR

CHAR(number)

Translates other types of code numbers into characters.

The CHAR function has the following argument:

number: A number between 1 and 255 specifying which character you want.

For example, CHAR(10) returns a line break "\n".

At present, Jodoo supports only the following numeric codes.

Number	Character	Meaning
9	\t	Tab
10	\n	Line Break
34	"	Double Quotation Marks
39	’	Single Quotation Mark
92	\	Backslash

EXACT

EXACT(text1,text2)

Compares two text strings (case-sensitive) and returns TRUE if they are exactly the same, FALSE otherwise. For example:

IP

IP()

Gets the IP address of the current user.

ISEMPTY

ISEMPTY(text)

Checks whether the value is an empty string, object, or array.

Fields that are supported to use the ISEMPTY function are: Single Line, Multi Line, Number, Date&Time, Radio, Checkbox, Single Select, Muti Select, Member, Members, Department, Departments, and URL Parameter.

The following three expressions all indicate that the Radio field is empty.

ISEMPTY(text)

ISEMPTY(text)==TRUE()

ISEMPTY(text)==1

Note:
The determination is whether the radio field is empty after it has been edited.

The ISEMPTY function can also be used for Validations on form submission.

JOIN

JOIN(array, delimiter)

Combines the values of an array into a text string using a specified delimiter.

For example, you can use "-" to combine options selected in the Checkbox field into a text string.

LEFT

LEFT(text,[num_chars])

Returns a substring with specified characters from the beginning of a text string.

LEN

LEN(text)

Returns the number of characters in a text string (spaces count as characters).

LOWER

LOWER(text)

Converts all uppercase letters in a text string to lowercase.

MID

MID(text,start_num,num_chars)

Returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.

The MID function has the following arguments:

text: Required. The text string containing the characters you want to extract.
start_num: Required. The position of the first character you want to extract in the text. The first character in text has start_num 1, and so on.
num_chars: Required. The number of characters you specify to return from text.

REPLACE

REPLACE(old_text,start_num,num_chars,new_text)

Replaces part of a text string, based on the number of characters you specify, with a different text string.

The REPLACE function has the following arguments:

old_text: Required. Text in which you want to replace some characters.
start_num: Required. The position of the character in old_text that you want to replace with new_text.
num_chars: Required. The number of characters in old_text that you want to replace with new_text.
new_text: Required. The text that will replace characters in old_text.

REPLACE(string1,2,4,string2) means that it replaces the four bytes after the 2nd byte in string1 with string2.

REPT

REPT(text,number_times)

Repeats text a given number of times.

The REPT function has the following arguments:

text: Reuqired. The text you want to repeat.
number_times: Required. A positive number specifies the number of times to repeat text.

RIGHT

RIGHT(text,[num_chars])

Returns a substring from the end of a specified string.

The RIGHT function has the following arguments:

text: Required. The text string containing the characters you want to extract.
num_chars: Optional. The number of characters you specify to extract.

As shown below, you can get the last four characters of the text content.

SEARCH

SEARCH(find_text,within_text,[start_num])

Returns the position at which text1 is first found within text2, from left to right, ignoring the case of English letters; returns 0 means not found.

The SEARCH function has the following arguments:

find_text: Required. The text that you want to find.
within_text: Required. The text in which you want to search for the value of find_text
start_num: Optional. The character number in within_text at which you want to start searching. If it is not filled in, the search starts from the first character by default.

SPLIT

SPLIT(text,text_separator)

Divides text around a specified character or string, and puts each fragment into an array.

TRIM

TRIM(text)

Removes leading and trailing spaces in a specified string.
If there are multiple consecutive spaces in the string, it will be deleted until only one space remains.

TEXT

TEXT(num,text_format)

Converts a number into text in a specific format.

The meanings of text_format are as follows.

＃: numeric placeholder. Display only meaningful data. If the number after the decimal point is greater than the number of #, it will be rounded up by the number of digits of #. If the number after the decimal point is less than the number of #, it returns the actual value. For example, enter ##. ## in the text box, it returns 23.1 when the number is 23.1 and returns 23.16 when the number is 23.1578.
0: numeric placeholder complement. If the number of digits before the decimal point is greater than the number of placeholders, it returns the actual data, and if it is less than the number of placeholders, it is made up with 0. If the number of the digits after the decimal point is greater than the placeholder, it is rounded to the number of 0. If the number after the decimal point is less than the number of 0, use 0 to make up the number. For example, enter 000.00 in the text box, it returns 023.10 when the number is 23.1 and returns 023.16 when the number is 23.1578.
,: thousands separator. It can be inserted in #, 0 or numbers. You can use it:

Before the decimal point.
Between ＃ or 0.

%: percentage. Placed after a numeric placeholder or complement. The data is displayed as a percentage. For example, it returns 2310% when entering #%,23.1.
[Num0] displays the raw data. The prefix is added directly before [Num0] or # or 0, and supports English Case, ¥, $ and Space.