https://help.easymorph.com/ Sun, 17 May 2026 18:27:57 +0000 FeedCreator 1.8 https://help.easymorph.com/lib/exe/fetch.php?media=wiki:logo.png https://help.easymorph.com/ https://help.easymorph.com/doku.php?id=syntax:functions:abs&rev=1628709186&do=diff Abs(number) Category: Number function Description This function returns the absolute value of number which is the distance of a number on the number line, from 0, without considering which direction the number lies The absolute value of a number is never negative. anonymous@undisclosed.example.com (Anonymous) Wed, 11 Aug 2021 19:13:06 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:acos&rev=1628980120&do=diff ACos(cosine) Category: Number function Description This function returns the arccosine - the angle, in radians, whose cosine is cosine. Arguments ArgumentTypeDescriptioncosineNumber (between -1 and 1)The cosine of an angle. Return value type: anonymous@undisclosed.example.com (Anonymous) Sat, 14 Aug 2021 22:28:40 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:addhours&rev=1630302783&do=diff AddHours(date, add_hours) Category: Date and Time function Description This function adds add_hours number of hours to date. If add_hours is negative, the hours are subtracted. Arguments ArgumentTypeDescriptiondateDate or Number (date serial) anonymous@undisclosed.example.com (Anonymous) Mon, 30 Aug 2021 05:53:03 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:addmonths&rev=1630302761&do=diff AddMonths(date, add_months) Category: Date and Time function Description This function adds add_months number of months to date. If add_months is negative, the months are subtracted. Arguments ArgumentTypeDescriptiondateDate or Number (date serial) anonymous@undisclosed.example.com (Anonymous) Mon, 30 Aug 2021 05:52:41 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:addyears&rev=1630302851&do=diff AddYears(date, add_years) Category: Date and Time function Description This function adds add_years number of years to date. If add_years is negative, the years are subtracted. Arguments ArgumentTypeDescriptiondateDate or Number (date serial) anonymous@undisclosed.example.com (Anonymous) Mon, 30 Aug 2021 05:54:11 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:age&rev=1630302947&do=diff Age(date1, date2) Category: Date and Time function Description This function returns the number of full years between two dates (date1 and date2). Arguments ArgumentTypeDescriptiondate1Date or Number (date serial)An expression representing a date. The date value to calculate the difference from. anonymous@undisclosed.example.com (Anonymous) Mon, 30 Aug 2021 05:55:47 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:agemonths&rev=1630303084&do=diff AgeMonths(date1, date2) Category: Date and Time function Description This function returns the number of full months between two dates (date1 and date2). Arguments ArgumentTypeDescriptiondate1Date or Number (date serial)An expression representing a date. The date to calculate the difference from. anonymous@undisclosed.example.com (Anonymous) Mon, 30 Aug 2021 05:58:04 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:arctan&rev=1628980856&do=diff ArcTan(number_y, number_x) Category: Number function Description This function returns the angle, in radians, whose tangent is the quotient of number_y and number_x. Arguments ArgumentTypeDescriptionnumber_yNumberThe y coordinate of point. anonymous@undisclosed.example.com (Anonymous) Sat, 14 Aug 2021 22:40:56 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:asin&rev=1628980186&do=diff ASin(sine) Category: Number function Description This function returns the arcsine - the angle, in radians, whose sine is sine. Arguments ArgumentTypeDescriptioncosineNumber (between -1 and 1)The sine of an angle. Return value type: Number anonymous@undisclosed.example.com (Anonymous) Sat, 14 Aug 2021 22:29:46 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:asnumber&rev=1631463208&do=diff AsNumber(expression) Category: Special function Description This function converts expression to a number. Use cases This is useful when you wish to validate the contents of a field or retrieve the number value of a field. Arguments Argument anonymous@undisclosed.example.com (Anonymous) Sun, 12 Sep 2021 16:13:28 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:astext&rev=1631502513&do=diff AsText(expression) Category: Special function Description This function converts value to text. Use cases This is useful when you wish to validate the contents of a field or retrieve the text value of a field. Arguments ArgumentTypeDescription anonymous@undisclosed.example.com (Anonymous) Mon, 13 Sep 2021 03:08:33 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:atan&rev=1628979999&do=diff ATan(tangent) Category: Number function Description This function returns the arctangent - the angle, in radians, whose tangent is tangent. Arguments ArgumentTypeDescriptiontangentNumber (between -1 and 1)The tangent of an angle. Return value type: anonymous@undisclosed.example.com (Anonymous) Sat, 14 Aug 2021 22:26:39 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:ceiling&rev=1628709329&do=diff Ceiling(number) Category: Number function Description This function rounds number up to the nearest integer - or full, non-fractional number - towards positive infinity. Arguments ArgumentTypeDescriptionnumberNumberThe value, usually fractional, to be rounded. anonymous@undisclosed.example.com (Anonymous) Wed, 11 Aug 2021 19:15:29 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:char&rev=1628992502&do=diff Char(char_code) Category: Text function Description This function returns the ASCII character associated with char_code. Arguments ArgumentTypeDescriptionchar_codeNumberThe numeric (decimal) ASCII value to be converted into the ASCII character. anonymous@undisclosed.example.com (Anonymous) Sun, 15 Aug 2021 01:55:02 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:coalesce&rev=1631504744&do=diff Coalesce(value1, value2…) Category: Special function Description This function returns the first value in the argument list that is not an empty value. Alternate formats This function can take from 2 to 6 values as arguments. coalesce(value1, value2, value3, value4, value5, value6) anonymous@undisclosed.example.com (Anonymous) Mon, 13 Sep 2021 03:45:44 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:code&rev=1628992576&do=diff Code(text) Category: Text function Description This function returns the UTF-8 code (from 0 to 2047) of the first character of text. Arguments ArgumentTypeDescriptiontextTextA text string from which the UTF-8 value of the first character is returned. anonymous@undisclosed.example.com (Anonymous) Sun, 15 Aug 2021 01:56:16 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:columnexists&rev=1631460592&do=diff ColumnExists(col_name) Category: Special function Description This function tests whether a column named col_name exists in the input dataset. TRUE is returned if the named column exists, otherwise, FALSE is returned. Arguments ArgumentType anonymous@undisclosed.example.com (Anonymous) Sun, 12 Sep 2021 15:29:52 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:combinepath&rev=1631126042&do=diff CombinePath(path1, path2) Category: File function (found in the "Special" category in the EasyMorph application) Description This function combines two paths into one, intelligently dealing with backslashes and relative paths. Use cases anonymous@undisclosed.example.com (Anonymous) Wed, 08 Sep 2021 18:34:02 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:combineurl&rev=1628707013&do=diff CombineURL(url, path) Category: Web function Description This function combines a URL and a URL path into one URL. Arguments ArgumentTypeDescriptionurl Text A string representing a URL. path Text A string representing the URL path to be appended to the anonymous@undisclosed.example.com (Anonymous) Wed, 11 Aug 2021 18:36:53 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:commonsubstring&rev=1729527747&do=diff CommonSubstring(text1, text2) Category: Text function Description This function returns the longest substring common to both text1 and text2. Arguments ArgumentTypeDescriptiontext1TextAny text, or value that can implicitly converted to text. anonymous@undisclosed.example.com (Anonymous) Mon, 21 Oct 2024 16:22:27 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:compact&rev=1628992685&do=diff Compact(text) Category: Text function Description This function removes repeating whitespace from text, reducing it to a single space. Note that line breaks and other special characters are not counted as whitespace. Arguments ArgumentType anonymous@undisclosed.example.com (Anonymous) Sun, 15 Aug 2021 01:58:05 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:contains&rev=1628992774&do=diff Contains(text, look_for) Category: Text function Description This function determines whether text contains the look_for string. If found, this function returns TRUE, otherwise it returns FALSE. Arguments ArgumentTypeDescriptiontextTextThe text value to search within for the anonymous@undisclosed.example.com (Anonymous) Sun, 15 Aug 2021 01:59:34 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:cos&rev=1628978387&do=diff Cos(angle) Category: Number function Description This function returns the cosine of the angle angle specified in radians. Arguments ArgumentTypeDescriptionangleNumberThe measurement of an angle, in radians. Return value type: Number anonymous@undisclosed.example.com (Anonymous) Sat, 14 Aug 2021 21:59:47 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:countwords&rev=1729528411&do=diff CountWords(text, [delimiters]) Category: Text function Description This function returns the number of words in text. Optionally, the second text argument (delimiters) can contain a list of delimiter characters. Arguments ArgumentTypeDescription anonymous@undisclosed.example.com (Anonymous) Mon, 21 Oct 2024 16:33:31 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:date&rev=1700877966&do=diff Date(datetime, format) Category: Date and Time function Description This function converts datetime as text into a date-time value represented as a number (date-time serial value) according to format string. Use cases Date is used to convert a text-based date-time value into its corresponding date-time serial value so it may be used in date-time-related calculations, e.g. the differences between two dates, day-of-the-week determinations, etc. anonymous@undisclosed.example.com (Anonymous) Sat, 25 Nov 2023 02:06:06 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:day&rev=1630303354&do=diff Day(date) Category: Date and Time function Description This function returns the number of the corresponding day of the month, from 1 through 31, from date. Arguments ArgumentTypeDescriptiondateDate or Number (date serial)An expression representing a date. The date to extract the day of the month from. anonymous@undisclosed.example.com (Anonymous) Mon, 30 Aug 2021 06:02:34 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:decode&rev=1632013590&do=diff Decode(method, text) Category: Web function Description This function decodes a text string using one of the available methods below. Arguments ArgumentTypeDescriptionmethod Text The decoding method to use on text. See the table below. anonymous@undisclosed.example.com (Anonymous) Sun, 19 Sep 2021 01:06:30 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:detectformat&rev=1700877358&do=diff DetectFormat(text_date) Category: Date and Time function Description This function detects the date-time format of the text date (or timestamp) provided as the argument ("text_date"). Arguments ArgumentTypeDescriptiontext_dateTextText value representing a date or timestamp. anonymous@undisclosed.example.com (Anonymous) Sat, 25 Nov 2023 01:55:58 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:directory&rev=1630212939&do=diff Directory(full_path) Category: File function (found in the "Special" category in the EasyMorph application) Description This function extracts the directory path from a full file path, excluding the file name. Arguments ArgumentTypeDescription anonymous@undisclosed.example.com (Anonymous) Sun, 29 Aug 2021 04:55:39 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:distance&rev=1628992930&do=diff Distance(text1, text2) Category: Text function Description This function returns the edit distance between two text strings calculated as the Damerau-Levenshtein distance. This shows the number of text edits, such as character insertions or deletions, that is needed to produce anonymous@undisclosed.example.com (Anonymous) Sun, 15 Aug 2021 02:02:10 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:div&rev=1628709374&do=diff Div(dividend, divisor) Category: Number function Description This function returns the quotient of two numbers. Arguments ArgumentTypeDescriptiondividendNumberThe value being divided.divisorNumber (non-zero)The value the divident is being divided by. anonymous@undisclosed.example.com (Anonymous) Wed, 11 Aug 2021 19:16:14 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:empty&rev=1631505963&do=diff Empty() Category: Special function Description This function creates an empty value. Use cases Use empty() to insert empty values into cells, or within other functions. Arguments This function does not require arguments. Return value type: Empty value anonymous@undisclosed.example.com (Anonymous) Mon, 13 Sep 2021 04:06:03 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:encode&rev=1632013408&do=diff Encode(method, text) Category: Web function Description This function encodes a text string using one of the available methods below. Arguments ArgumentTypeDescriptionmethod Text The encoding method to use on text. See the table below. anonymous@undisclosed.example.com (Anonymous) Sun, 19 Sep 2021 01:03:28 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:endswith&rev=1628982140&do=diff EndsWith(text, end_string) Category: Text function Description This function is a search function used to check if a string (text) ends with a specific text value (end_string). If so, this function returns TRUE. Otherwise, it returns FALSE. anonymous@undisclosed.example.com (Anonymous) Sat, 14 Aug 2021 23:02:20 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:error&rev=1631579700&do=diff Error(error_text) Category: Special function Description This function creates an error value with the given error_text. Use cases Use this function to raise an error when a known situation occurs that could cause issues downstream, and should not be permitted to continue. i.e., empty datasets, values outside expected parameters, etc. anonymous@undisclosed.example.com (Anonymous) Tue, 14 Sep 2021 00:35:00 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:eval&rev=1684263767&do=diff Eval(text_expression) Category: Special function Description This function evaluates the text_expression argument as an EasyMorph expression. Use cases This function makes it possible to define EasyMorph expressions externally using parameters. anonymous@undisclosed.example.com (Anonymous) Tue, 16 May 2023 19:02:47 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:exp&rev=1628709401&do=diff Exp(power) Category: Number function Description This function raises the mathematical constant e to the power of the argument power. Arguments ArgumentTypeDescriptionpowerNumberThe exponent to raise e to. Return value type: Number anonymous@undisclosed.example.com (Anonymous) Wed, 11 Aug 2021 19:16:41 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:false&rev=1629095635&do=diff False() Category: Logical function Description This function creates a Boolean value equal to FALSE. Use cases Use this function to set, or test for, a Boolean FALSE value. Arguments This function does not take any arguments. Return value type: anonymous@undisclosed.example.com (Anonymous) Mon, 16 Aug 2021 06:33:55 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:fileextension&rev=1683042061&do=diff FileExtension(full_path) Category: File function (found in the "Special" category in the EasyMorph application) Description This function extracts the file extension (with dot) from a full file path. Arguments ArgumentTypeDescriptionpath anonymous@undisclosed.example.com (Anonymous) Tue, 02 May 2023 15:41:01 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:filename&rev=1668178973&do=diff Filename(full_path) Category: File function (found in the "Special" category in the EasyMorph application) Description This function extracts the filename (without extension) from a full file path. Arguments ArgumentTypeDescriptionfull_path anonymous@undisclosed.example.com (Anonymous) Fri, 11 Nov 2022 15:02:53 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:find&rev=1628993041&do=diff Find(text, look_for) Category: Text function Description This function finds the exact position of look_for within text and returns the position of the first character. If look_for is not found within text then it returns 0. The first character in anonymous@undisclosed.example.com (Anonymous) Sun, 15 Aug 2021 02:04:01 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:floor&rev=1628709464&do=diff Floor(number) Category: Number function Description This function rounds number down to the nearest integer - or full, non-fractional number - towards negative infinity. Arguments ArgumentTypeDescriptionnumberNumberThe value, usually fractional, to be rounded. anonymous@undisclosed.example.com (Anonymous) Wed, 11 Aug 2021 19:17:44 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:format&rev=1630303454&do=diff Format(datetime, format) Category: Date and Time function Description This function converts datetime as a date serial value into a date-time text value formatted according to format. Arguments ArgumentTypeDescriptiondatetime Date or Number (date serial) anonymous@undisclosed.example.com (Anonymous) Mon, 30 Aug 2021 06:04:14 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:fromunixtime&rev=1708030056&do=diff FromUnixTime(unix_time) Category: Date and Time function Description This function converts a Unix timestamp (the number of seconds since Jan 1st, 1970) to the numeric date-time serial value used in EasyMorph (and Excel). Arguments Argument anonymous@undisclosed.example.com (Anonymous) Thu, 15 Feb 2024 20:47:36 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:fv&rev=1635049989&do=diff FV(rate, num_per, payment) Category: Number (Financial) function Description This function calculates the future value of an investment based on a constant interest rate. Additional syntax Optional current value (cur_val) argument. fv(rate, num_per, payment, cur_val) anonymous@undisclosed.example.com (Anonymous) Sun, 24 Oct 2021 04:33:09 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:guid&rev=1697254771&do=diff GUID() Category: Special function Description This function generates a 128-bit globally unique identifier ("GUID") text string similar to the Generate GUID action. Arguments No arguments are required for this function. Return value type: anonymous@undisclosed.example.com (Anonymous) Sat, 14 Oct 2023 03:39:31 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:hash&rev=1631580556&do=diff Hash(value) Category: Special function Description This function calculates a 128-bit hash in Base64 encoding. The function returns the same result for the same value on any computer. Arguments ArgumentTypeDescriptionvalueAnyThe source value used to generate the hash value. anonymous@undisclosed.example.com (Anonymous) Tue, 14 Sep 2021 00:49:16 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:hashhex&rev=1631934583&do=diff HashHex(algorithm, text) Category: Web function Description This function calculates the hexadecimal hash of a given text value using one of the algorithms listed in the table, below. Arguments ArgumentTypeDescriptionalgorithm Text The method to use to generate the hash from anonymous@undisclosed.example.com (Anonymous) Sat, 18 Sep 2021 03:09:43 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:hexdecode&rev=1632013611&do=diff HexDecode(encoding, hex_text) Category: Web function Description This function converts the provided hex string into a text value. The text is assumed to have the specified encoding. Arguments ArgumentTypeDescriptionencoding Text The method that was used to create the encoded anonymous@undisclosed.example.com (Anonymous) Sun, 19 Sep 2021 01:06:51 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:hexencode&rev=1632013629&do=diff HexEncode(encoding, text) Category: Web function Description This function converts the provided text value into a hex string. The text is assumed to have the specified encoding. Refer to the supported encodings, below. Arguments Argument anonymous@undisclosed.example.com (Anonymous) Sun, 19 Sep 2021 01:07:09 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:hmachex&rev=1632009037&do=diff HMACHex(algorithm, text, key) Category: Web function Description This function calculates a keyed hexadecimal hash of a given text value using one of the algorithms listed in the table, below. Arguments ArgumentTypeDescriptionalgorithm Text anonymous@undisclosed.example.com (Anonymous) Sat, 18 Sep 2021 23:50:37 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:if&rev=1629096137&do=diff If(condition, when_true, when_false) Category: Logical function Description This function evaluates condition and returns the when_true value if the condition is true, or when_false if not. Arguments ArgumentTypeDescriptionconditionExpression anonymous@undisclosed.example.com (Anonymous) Mon, 16 Aug 2021 06:42:17 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:ifempty&rev=1629098260&do=diff IfEmpty(expression1, expression2) Category: Logical function Description This function returns the result of expression2 if the result of expression1 is empty. Otherwise, it returns the result of expression1. Use cases This function can be used as an error handler in cases where an expression could potentially return an empty value. In such a case, the return value from anonymous@undisclosed.example.com (Anonymous) Mon, 16 Aug 2021 07:17:40 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:iferror&rev=1629098158&do=diff IfError(expression1, expression2) Category: Logical function Description This function returns the result of expression2 if the result of expression1 is an error. Otherwise, it returns the result of expression1. Use cases This function can be used as an error handler in cases where an expression could potentially return an error. In such a case, the return value from anonymous@undisclosed.example.com (Anonymous) Mon, 16 Aug 2021 07:15:58 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:in&rev=1629102863&do=diff In(text, look_in, delimiter) Category: Logical function Description This function returns Boolean TRUE if text is found within any of the values listed in look_in. Otherwise, it returns Boolean FALSE. Arguments ArgumentTypeDescriptiontext anonymous@undisclosed.example.com (Anonymous) Mon, 16 Aug 2021 08:34:23 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:ipmt&rev=1635049938&do=diff IPmt(rate, per, num_per, curr_val) Category: Number (Financial) function Description This function calculates the interest payment for a given period for an investment . Additional syntax Optional future value (fut_val) argument. IPmt(rate, per, num_per, curr_val, fut_val) anonymous@undisclosed.example.com (Anonymous) Sun, 24 Oct 2021 04:32:18 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:isboolean&rev=1629103647&do=diff IsBoolean(expression) Category: Logical function Description This function returns TRUE if the result of expression is a Boolean (either TRUE or FALSE). Otherwise, it returns FALSE. Arguments ArgumentTypeDescriptionexpressionExpressionAny expression that could potentially result a Boolean value. anonymous@undisclosed.example.com (Anonymous) Mon, 16 Aug 2021 08:47:27 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:isemail&rev=1631731150&do=diff IsEmail(email_addr) Category: Web function Description This function determines if email_addr is a properly formatted email address, returning TRUE if so, or FALSE if not. Arguments ArgumentTypeDescriptionemail_addr Text A string representing an email address to be tested for proper formatting. anonymous@undisclosed.example.com (Anonymous) Wed, 15 Sep 2021 18:39:10 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:isempty&rev=1630198128&do=diff IsEmpty(expression) Category: Logical function Description This function returns TRUE if the result of expression is an empty value. Otherwise, it returns FALSE. Text cells with empty contents (e.g. '') will return TRUE as well. Arguments anonymous@undisclosed.example.com (Anonymous) Sun, 29 Aug 2021 00:48:48 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:iserror&rev=1629104274&do=diff IsError(expression) Category: Logical function Description This function returns TRUE if the result of expression is an error. Otherwise, it returns FALSE. Arguments ArgumentTypeDescriptionexpressionExpressionAny expression that could potentially result in an error. anonymous@undisclosed.example.com (Anonymous) Mon, 16 Aug 2021 08:57:54 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:iseven&rev=1628709759&do=diff IsEven(number) Category: Number function Description This function tests if number is even and returns Boolean TRUE if so, or FALSE if not. Arguments ArgumentTypeDescriptionnumberIntegerThe value to be tested as even. Return value type: Boolean (TRUE/FALSE) anonymous@undisclosed.example.com (Anonymous) Wed, 11 Aug 2021 19:22:39 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:isinteger&rev=1630196187&do=diff IsInteger(expression) Category: Logical function Description This function returns TRUE if the result of expression is an integer number. Otherwise, it returns FALSE. Arguments ArgumentTypeDescriptionexpressionExpressionAny expression that could potentially result in an integer. anonymous@undisclosed.example.com (Anonymous) Sun, 29 Aug 2021 00:16:27 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:isjson&rev=1632009541&do=diff IsJSON(text) Category: Web function Description This function returns TRUE if the argument can be parsed as a JSON object or JSON array. Otherwise, it returns FALSE. Arguments ArgumentTypeDescriptiontext Text The string being tested as JSON or a JSON object . anonymous@undisclosed.example.com (Anonymous) Sat, 18 Sep 2021 23:59:01 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:isnum&rev=1428101720&do=diff IsNum(expression) Returns TRUE if result of expression is a number, otherwise returns FALSE. Example FieldA Result IsNum( [FieldA] ) 200 TRUE IsNum( [FieldA] ) It's a number! FALSE IsNum( [FieldA] ) FALSE anonymous@undisclosed.example.com (Anonymous) Fri, 03 Apr 2015 22:55:20 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:isnumber&rev=1630196568&do=diff IsNumber(expression) Category: Logical function Description This function returns TRUE if the result of expression is a number. Otherwise, it returns FALSE. Arguments ArgumentTypeDescriptionexpressionExpressionAny expression that could potentially result in a number. anonymous@undisclosed.example.com (Anonymous) Sun, 29 Aug 2021 00:22:48 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:isnumeric&rev=1630197553&do=diff IsNumeric(expression) Category: Logical function Description This function returns TRUE if the result of expression is a number or text that looks like a number. Otherwise, it returns FALSE. Arguments ArgumentTypeDescriptionexpressionExpression anonymous@undisclosed.example.com (Anonymous) Sun, 29 Aug 2021 00:39:13 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:isodd&rev=1628709842&do=diff IsOdd(number) Category: Number function Description This function tests if number is odd and returns Boolean TRUE if so, or FALSE if not. Arguments ArgumentTypeDescriptionnumberIntegerThe value to be tested as odd. Return value type: Boolean (TRUE/FALSE) anonymous@undisclosed.example.com (Anonymous) Wed, 11 Aug 2021 19:24:02 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:isoweeknumber&rev=1630305108&do=diff ISOWeekNumber(date) Category: Date and Time function Description This function returns the ISO week number which ranges from 1 to 53 from date. Arguments ArgumentTypeDescriptiondateDate or Number (date serial)An expression that results in a date-time serial value. The date to derive the ISO week number from. anonymous@undisclosed.example.com (Anonymous) Mon, 30 Aug 2021 06:31:48 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:ispathrooted&rev=1630213620&do=diff IsPathRooted(full_path) Category: File function (found in the "Special" category in the EasyMorph application) Description This function detects if a path to a file or folder contains a root. Network locations are supported. Use cases Use this function to differentiate between an anonymous@undisclosed.example.com (Anonymous) Sun, 29 Aug 2021 05:07:00 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:isregexmatch&rev=1653044201&do=diff IsRegExMatch(text, regex_text) Category: Text function Description This function determines if text matches the regular expression ("RegEx") pattern regex_text and returns TRUE if it does. Otherwise, it returns FALSE. Arguments ArgumentType anonymous@undisclosed.example.com (Anonymous) Fri, 20 May 2022 10:56:41 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:istext&rev=1630198015&do=diff IsText(expression) Category: Logical function Description This function returns TRUE if the result of expression is text. Otherwise, it returns FALSE. Text cells with empty contents (e.g., ' ') will return TRUE as well. Arguments Argument anonymous@undisclosed.example.com (Anonymous) Sun, 29 Aug 2021 00:46:55 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:istextdate&rev=1700877263&do=diff IsTextDate(text_date) Category: Date and Time function Description This function determines if the argument ("text_date") is a recognizable text date and returns TRUE if so. Arguments ArgumentTypeDescriptiontext_dateTextText value that represents a date. anonymous@undisclosed.example.com (Anonymous) Sat, 25 Nov 2023 01:54:23 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:isurl&rev=1729534460&do=diff IsURL(text) Category: Text function Description This function tests if text is a valid web address (URL). If so, TRUE is returned, otherwise, FALSE. Arguments ArgumentTypeDescriptiontextTextThe text string to be tested as being a valid URL anonymous@undisclosed.example.com (Anonymous) Mon, 21 Oct 2024 18:14:20 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:isweekend&rev=1630305126&do=diff IsWeekend(date) Category: Date and Time function Description This function returns TRUE if date falls on a weekend day (Saturday or Sunday). Otherwise, it returns FALSE. Arguments ArgumentTypeDescriptiondateDate or Number (date serial)An expression representing a date. The date to test whether it falls on a weekend day, or not. anonymous@undisclosed.example.com (Anonymous) Mon, 30 Aug 2021 06:32:06 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:isxml&rev=1632009885&do=diff IsXML(text) Category: Web function Description This function returns TRUE if the given text is an XML object. Otherwise, it returns FALSE. Arguments ArgumentTypeDescriptiontext Text The string being tested as an XML object. Return value type: anonymous@undisclosed.example.com (Anonymous) Sun, 19 Sep 2021 00:04:45 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:jsonvalue&rev=1714964330&do=diff JSONValue(JSON_text, JSONPath) Category: Web function Description This function extracts a single value or a JSON object/array from a node specified by JSONPath. Arguments ArgumentTypeDescriptionJSON_text Text A string representing a JSON node. JSONPath anonymous@undisclosed.example.com (Anonymous) Mon, 06 May 2024 02:58:50 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:keepafter&rev=1640255747&do=diff KeepAfter(text, after_string) Category: Text function Description This function returns characters after the first occurrence of after_string in text, if found. If after_string is not found within text and "empty" value is returned. Alternative syntax anonymous@undisclosed.example.com (Anonymous) Thu, 23 Dec 2021 10:35:47 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:keepbefore&rev=1628993378&do=diff KeepBefore(text, before_string) Category: Text function Description This function returns characters before the first occurrence of before_string in text, if found. If before_string is not found within text and "empty" value is returned. Alternative syntax anonymous@undisclosed.example.com (Anonymous) Sun, 15 Aug 2021 02:09:38 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:keepbetween&rev=1628993511&do=diff KeepBetween(text, keep_start, keep_end) Category: Text function Description This function returns the characters between the first occurrence of keep_start and the first occurrence of keep_end in text. Arguments ArgumentTypeDescriptiontext anonymous@undisclosed.example.com (Anonymous) Sun, 15 Aug 2021 02:11:51 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:keepchars&rev=1628993587&do=diff KeepChars(text, keep_string) Category: Text function Description This function keeps only the characters given in keep_string and removes the others from text. Arguments ArgumentTypeDescriptiontextTextThe text value to search within for the anonymous@undisclosed.example.com (Anonymous) Sun, 15 Aug 2021 02:13:07 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:left&rev=1628993720&do=diff Left(text, no_of_chars) Category: Text function Description This function returns the specified number of symbols from the left of text as a text value. Arguments ArgumentTypeDescriptiontextTextThe text value to extract the symbols from.no_of_chars anonymous@undisclosed.example.com (Anonymous) Sun, 15 Aug 2021 02:15:20 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:len&rev=1628993816&do=diff Len(text) Category: Text function Description This function returns the number of characters (length) in the text value. Use cases This function can be used to determine if there are unexpected non-printing characters in a text string. anonymous@undisclosed.example.com (Anonymous) Sun, 15 Aug 2021 02:16:56 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:linebreak&rev=1629011745&do=diff LineBreak() Category: Text function Description This function returns the line break character (in Windows). Note that files generated in other operating systems (e.g., Linux, Unix, or MacOS) may have different line break characters. Use cases anonymous@undisclosed.example.com (Anonymous) Sun, 15 Aug 2021 07:15:45 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:localtime&rev=1630305163&do=diff LocalTime(date) Category: Date and Time function Description This function converts a UTC date-time into a local date-time. Arguments ArgumentTypeDescriptiondateDate or Number (date serial)An expression representing a date. The UTC date-time value to convert to a local date-time value. anonymous@undisclosed.example.com (Anonymous) Mon, 30 Aug 2021 06:32:43 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:log&rev=1628709894&do=diff Log(number) Category: Number function Description This function returns the natural logarithm of number. Arguments ArgumentTypeDescriptionnumberNumber (positive, non-0 value)The value for which the natural logarithm is returned. Return value type: anonymous@undisclosed.example.com (Anonymous) Wed, 11 Aug 2021 19:24:54 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:lower&rev=1628993937&do=diff Lower(text) Category: Text function Description This function returns text converted to lowercase letters. Use cases This function can be used to perform a case-insensitive comparison of text values when the current case of the values are not known. The anonymous@undisclosed.example.com (Anonymous) Sun, 15 Aug 2021 02:18:57 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:makedate&rev=1632603899&do=diff MakeDate(year, month, day) Category: Date and Time function Description This function returns a date serial number based on the year, month and day numeric values. Arguments ArgumentTypeDescriptionyearNumberA number value representing the 4-digit year of the date. anonymous@undisclosed.example.com (Anonymous) Sat, 25 Sep 2021 21:04:59 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:match&rev=1631587585&do=diff Match(value, text_list, delimiter) Category: Special function Description This function returns the position index of value in a list of values (text_list), separated by delimiter. Use cases This function makes it possible to define EasyMorph expressions externally using parameters. anonymous@undisclosed.example.com (Anonymous) Tue, 14 Sep 2021 02:46:25 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:max&rev=1628709945&do=diff Max(number1, number2) Category: Number function Description This function returns the largest of two numbers. Arguments ArgumentTypeDescriptionnumber1NumberThe value to be compared to number2.number2NumberThe value to be compared to number1 anonymous@undisclosed.example.com (Anonymous) Wed, 11 Aug 2021 19:25:45 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:metadata&rev=1631729961&do=diff Metadata(keyword) Category: Special function Description This function returns project metadata - specific details about the project. The keyword must be one of the text constants shown below. Arguments ArgumentTypeDescription'current module' anonymous@undisclosed.example.com (Anonymous) Wed, 15 Sep 2021 18:19:21 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:mid&rev=1629086531&do=diff Mid(text, start, length) Category: Text function Description This function returns a substring of text from text, length characters long, and starting with the character in position start. Arguments ArgumentTypeDescriptiontextTextAny text value from which the substring of text is returned. anonymous@undisclosed.example.com (Anonymous) Mon, 16 Aug 2021 04:02:11 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:min&rev=1628709998&do=diff Min(number1, number2) Category: Number function Description This function returns the smallest of two numbers. Arguments ArgumentTypeDescriptionnumber1NumberThe value to be compared to number2.number2NumberThe value to be compared to number1 anonymous@undisclosed.example.com (Anonymous) Wed, 11 Aug 2021 19:26:38 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:mirror&rev=1629087669&do=diff Mirror(text) Category: Text function Description This function returns a string with the reverse order of characters in text. Use cases This function allows for using text functions such as KeepBefore and KeepAfter to operate with the last occurrence of a substring in a text value. Refer to the example below. anonymous@undisclosed.example.com (Anonymous) Mon, 16 Aug 2021 04:21:09 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:month&rev=1630305595&do=diff Month(date) Category: Date and Time function Description This function returns the corresponding month number, 1 through 12, from date. Arguments ArgumentTypeDescriptiondateDate or Number (date serial)An expression representing a date. The date value to derive the month number from. anonymous@undisclosed.example.com (Anonymous) Mon, 30 Aug 2021 06:39:55 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:monthend&rev=1631327270&do=diff MonthEnd(date) Category: Date and Time function Description This function returns the date serial number of the last day of the month date falls in. Arguments ArgumentTypeDescriptiondateDate or Number (date serial)An expression representing a date to derive the month's last day date value from. anonymous@undisclosed.example.com (Anonymous) Sat, 11 Sep 2021 02:27:50 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:monthname&rev=1631328415&do=diff MonthName(month_num) Category: Date and Time function Description This function returns the abbreviated (3-letter) name of the month corresponding to the month_num, from 1 to 12. Arguments ArgumentTypeDescriptionmonth_numNumberA number representing a month, from 1 to 12. anonymous@undisclosed.example.com (Anonymous) Sat, 11 Sep 2021 02:46:55 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:monthnamelocal&rev=1631328514&do=diff MonthNameLocal(month_num) Category: Date and Time function Description This function returns the abbreviated (3-letter) name of the month corresponding to the month_num, from 1 to 12, according to the current regional locale. Arguments Argument anonymous@undisclosed.example.com (Anonymous) Sat, 11 Sep 2021 02:48:34 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:monthstart&rev=1631327947&do=diff MonthStart(date) Category: Date and Time function Description This function returns the date serial number of the first day of the month date falls in. Arguments ArgumentTypeDescriptiondateDate or Number (date serial)An expression representing a date to derive the month's first day date value from. anonymous@undisclosed.example.com (Anonymous) Sat, 11 Sep 2021 02:39:07 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:mround&rev=1667772617&do=diff MRound(number, grain) Category: Number function Description This function rounds a number to the desired multiple (grain). Arguments ArgumentTypeDescriptionnumberNumberThe value, usually fractional, to be rounded.grainNumberThe multiple to round anonymous@undisclosed.example.com (Anonymous) Sun, 06 Nov 2022 22:10:17 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:now&rev=1632604129&do=diff Now() Category: Date and Time function Description This function returns the current date-time as a date serial number. Arguments This function does not require arguments. Return value type: Number (date serial value). Remarks In a date-time serial number, the whole number part of the value represents the anonymous@undisclosed.example.com (Anonymous) Sat, 25 Sep 2021 21:08:49 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:nper&rev=1635050096&do=diff NPer(rate, payment, curr_val) Category: Number (Financial) function Description This function calculates the number of periods for an investment based on periodic payments and interest rate. Additional syntax Optional future value (fut_val) argument. anonymous@undisclosed.example.com (Anonymous) Sun, 24 Oct 2021 04:34:56 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:padend&rev=1628994085&do=diff PadEnd(text, pad_char, total_len) Category: Text function Description This function pads the end of text with pad_char up to a total length defined by total_len. Arguments ArgumentTypeDescriptiontextTextThe text value to be padded.pad_char anonymous@undisclosed.example.com (Anonymous) Sun, 15 Aug 2021 02:21:25 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:padstart&rev=1628994037&do=diff PadStart(text, pad_char, total_len) Category: Text function Description This function pads the beginning of text with pad_char up to a total length defined by total_len. Use cases This function is useful for creating text values from numbers that require leading zeros. anonymous@undisclosed.example.com (Anonymous) Sun, 15 Aug 2021 02:20:37 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:parsefloat&rev=1629088946&do=diff ParseFloat(text) Category: Text function Description This function parses a number in scientific notation (as a text value) into a decimal number. Arguments ArgumentTypeDescriptiontextTextThe value of a number in scientific notation. Return value type: anonymous@undisclosed.example.com (Anonymous) Mon, 16 Aug 2021 04:42:26 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:pi&rev=1628710046&do=diff Pi() Category: Number function Description This function returns the value of Pi (π): 3.1415926535897932384626433833… Arguments This function requires no arguments. Return value type: Number Remarks Pi is an irrational number with no final digit and can be represented by the fraction anonymous@undisclosed.example.com (Anonymous) Wed, 11 Aug 2021 19:27:26 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:pick&rev=1631588409&do=diff Pick(index, text_list, delimiter) Category: Special function Description This function returns the value in index position within text_list, a list of text values separated by delimiter. Use cases This function makes it possible to define EasyMorph expressions externally using parameters. anonymous@undisclosed.example.com (Anonymous) Tue, 14 Sep 2021 03:00:09 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:pmt&rev=1635049607&do=diff Pmt(rate, num_per, curr_val) Category: Number (Financial) function Description This function calculated the periodic payment for an annuity. Additional syntax Optional future value (fut_val) argument. pmt(rate, num_per, curr_val, fut_val) anonymous@undisclosed.example.com (Anonymous) Sun, 24 Oct 2021 04:26:47 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:pow&rev=1628710182&do=diff Pow(number, power) Category: Number function Description This function raises number to the power of power. Arguments ArgumentTypeDescriptionnumberNumberThe (base) value to be raised to the power of power.powerNumber (non-negative, >=0)The exponent to raise anonymous@undisclosed.example.com (Anonymous) Wed, 11 Aug 2021 19:29:42 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:ppmt&rev=1635049799&do=diff PPmt(rate, per, num_per, curr_val) Category: Number (Financial) function Description This function calculates the payment on the principal for an investment over a given period. Additional syntax Optional future value (fut_val) argument. anonymous@undisclosed.example.com (Anonymous) Sun, 24 Oct 2021 04:29:59 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:proper&rev=1628994159&do=diff Proper(text) Category: Text function Description This function converts text to the proper case (or "title case"), i.e. the first letter of each word becomes uppercase, the remaining letters become lowercase. Arguments ArgumentTypeDescription anonymous@undisclosed.example.com (Anonymous) Sun, 15 Aug 2021 02:22:39 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:pv&rev=1635050194&do=diff PV(rate, num_per, payment) Category: Number (Financial) function Description This function calculates the present value of a loan or an investment, based on a constant interest rate. Additional syntax Optional future value (fut_val) argument. anonymous@undisclosed.example.com (Anonymous) Sun, 24 Oct 2021 04:36:34 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:quote&rev=1629088268&do=diff Quote() Category: Text function Description This function returns a single quote character ('). Use cases This function is useful when you need to construct an expression with a text string containing single quotes. Arguments This function does not take any arguments. anonymous@undisclosed.example.com (Anonymous) Mon, 16 Aug 2021 04:31:08 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:randbetween&rev=1634324510&do=diff RandBetween(min_num, max_num) Category: Number function Description This function generates a random whole number between the values min_num and max_num. Arguments ArgumentTypeDescriptionmin_numNumberThe minimum value of the returned number. Must be less than or equal to anonymous@undisclosed.example.com (Anonymous) Fri, 15 Oct 2021 19:01:50 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:random&rev=1634324175&do=diff Random() Category: Number function Description This function generates a random number between 0 and 1. Arguments This function does not require arguments. Return value type: Number Remarks Generating random numbers within a given range anonymous@undisclosed.example.com (Anonymous) Fri, 15 Oct 2021 18:56:15 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:rate&rev=1635050304&do=diff Rate(num_per, payment, curr_val) Category: Number (Financial) function Description This function calculates the interest rate per period of an annuity. Additional syntax Optional future value (fut_val) argument. rate(num_per, payment, curr_val, fut_val) anonymous@undisclosed.example.com (Anonymous) Sun, 24 Oct 2021 04:38:24 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:regexmatch&rev=1653044085&do=diff RegExMatch(text, regex_text) Category: Text function Description This function returns the first substring that matches the regular expression pattern regex_text. Use cases RegExMatch is useful for fuzzy-matching and extracting substrings of text using a specific pattern of characters. anonymous@undisclosed.example.com (Anonymous) Fri, 20 May 2022 10:54:45 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:regexreplace&rev=1742331727&do=diff RegExReplace(text, replace_text, regex_text) Category: Text function Description This function replaces the first substring within text that matches the regular expression pattern (regex_text) with the given replacement string, replace_text. anonymous@undisclosed.example.com (Anonymous) Tue, 18 Mar 2025 21:02:07 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:rem&rev=1628710364&do=diff Rem(dividend, divisor) Category: Number function Description This function returns the remainder of the quotient of two numbers. Arguments ArgumentTypeDescriptiondividendNumberThe value being divided.divisorNumber (non-zero)The value the divident anonymous@undisclosed.example.com (Anonymous) Wed, 11 Aug 2021 19:32:44 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:remove&rev=1629010406&do=diff Remove(text, start, length) Category: Text function Description This function removes a substring of text from text, length characters long, and starting with the startth character. Arguments ArgumentTypeDescriptiontextTextAny text value from which the substring of text is removed. anonymous@undisclosed.example.com (Anonymous) Sun, 15 Aug 2021 06:53:26 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:removechars&rev=1629010302&do=diff RemoveChars(text, chars) Category: Text function Description This function removes the individual characters specified in chars from text. Arguments ArgumentTypeDescriptiontextTextAny text value from which the characters in chars are removed. anonymous@undisclosed.example.com (Anonymous) Sun, 15 Aug 2021 06:51:42 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:removeend&rev=1629010340&do=diff RemoveEnd(text, length) Category: Text function Description This function returns text excluding the last length characters, including spaces and non-printing characters. Arguments ArgumentTypeDescriptiontextTextAny text value from which the trailing anonymous@undisclosed.example.com (Anonymous) Sun, 15 Aug 2021 06:52:20 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:removestart&rev=1629010453&do=diff RemoveStart(text, length) Category: Text function Description This function returns text excluding the first length characters, including spaces. Arguments ArgumentTypeDescriptiontextTextAny text value from which the leading length characters are removed. anonymous@undisclosed.example.com (Anonymous) Sun, 15 Aug 2021 06:54:13 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:removetext&rev=1629010477&do=diff RemoveText(text, string) Category: Text function Description This function removes all instances of string from text. Arguments ArgumentTypeDescriptiontextTextAny text value from which the text string is removed.stringTextThe text string removed from anonymous@undisclosed.example.com (Anonymous) Sun, 15 Aug 2021 06:54:37 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:replace&rev=1742331636&do=diff Replace(text, old_text, new_text) Category: Text function Description This function replaces all instances of old_text with new_text within text. Arguments ArgumentTypeDescriptiontextTextAny text value or value that can be implicitly converted to text. anonymous@undisclosed.example.com (Anonymous) Tue, 18 Mar 2025 21:00:36 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:replacebetween&rev=1742331478&do=diff ReplaceBetween(text, string1, contents, string2 [,N]) Category: Text function Description This function replaces the characters between string1 and string2 in text with contents. Use cases This function can be used for patching or editing anonymous@undisclosed.example.com (Anonymous) Tue, 18 Mar 2025 20:57:58 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:replacebetweenmany&rev=1742330989&do=diff ReplaceBetweenMany(text, string1, contents, string2 [,N]) Category: Text function Description This function replaces in text the first N occurrences (or last N occurrences if a negative value is used) of any text between string1 and string2 with anonymous@undisclosed.example.com (Anonymous) Tue, 18 Mar 2025 20:49:49 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:right&rev=1628994642&do=diff Right(text, no_of_chars) Category: Text function Description This function returns the specified number of symbols from the right of text as a text value. Arguments ArgumentTypeDescriptiontextTextThe text value to extract the symbols from. anonymous@undisclosed.example.com (Anonymous) Sun, 15 Aug 2021 02:30:42 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:round&rev=1677633218&do=diff Round(number, dec_places) Category: Number function Description This function rounds a number to dec_places number of decimal digits. Alternative syntax The 2nd argument in this function is optional. If omitted, it's assumed to be 0. Round(number) //The same as Round(number, 0) anonymous@undisclosed.example.com (Anonymous) Wed, 01 Mar 2023 01:13:38 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:roundxl&rev=1677633289&do=diff RoundXL(number, dec_places) Category: Number function Description This function rounds number to dec_places decimal digits using the Excel rounding logic. Excel rounding logic rounds a decimal value of 5 or greater up to the next nearest value (towards positive infinity) and 4 or less anonymous@undisclosed.example.com (Anonymous) Wed, 01 Mar 2023 01:14:49 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:sanitize&rev=1628994541&do=diff Sanitize(text) Category: Text function Description This function replaces tabs and line breaks with spaces and removes hidden system characters with ASCII codes 0 to 31 in text. Use cases This function can be used to remove unexpected unseen characters from text. anonymous@undisclosed.example.com (Anonymous) Sun, 15 Aug 2021 02:29:01 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:setcontainsall&rev=1712901606&do=diff SetContainsAll(list1, list2[, separator]) Category: Text function Description This function returns TRUE if list1 contains all the distinct values from list2. Arguments ArgumentTypeDescriptionlist1List (Text)A delimited set of string values. anonymous@undisclosed.example.com (Anonymous) Fri, 12 Apr 2024 06:00:06 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:setcontainsany&rev=1712901584&do=diff SetContainsAny(list1, list2[, separator]) Category: Text function Description This function returns TRUE if list1 contains at least one value from list2, otherwise it returns FALSE. Arguments ArgumentTypeDescriptionlist1List (Text)A delimited set of string values. anonymous@undisclosed.example.com (Anonymous) Fri, 12 Apr 2024 05:59:44 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:setdifference&rev=1712901923&do=diff SetDifference(list1, list2[, separator]) Category: Text function Description This function removes values in list2 from list1 with deduplication. Arguments ArgumentTypeDescriptionlist1List (Text)A delimited set of string values.list2List (Text) anonymous@undisclosed.example.com (Anonymous) Fri, 12 Apr 2024 06:05:23 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:setintersection&rev=1712902086&do=diff SetIntersection(list1, list2[, separator]) Category: Text function Description This function returns a deduplicated list of values that exist in both list1 and list2. Arguments ArgumentTypeDescriptionlist1List (Text)A delimited set of string values. anonymous@undisclosed.example.com (Anonymous) Fri, 12 Apr 2024 06:08:06 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:setlength&rev=1712902389&do=diff SetLength(list[, separator]) Category: Text function Description This function returns the number of distinct values in the list. Arguments ArgumentTypeDescriptionlistList (Text)A delimited set of string values.separatorTextThe delimiter to use in the concatenation of the output string. If not defined, the default is comma. anonymous@undisclosed.example.com (Anonymous) Fri, 12 Apr 2024 06:13:09 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:setsort&rev=1712902603&do=diff SetSort(list[, separator]) Category: Text function Description This function returns the distinct values of the list sorted in ascending order. This function can also be used for set normalization. Arguments ArgumentTypeDescriptionlistList (Text) anonymous@undisclosed.example.com (Anonymous) Fri, 12 Apr 2024 06:16:43 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:setunion&rev=1712902797&do=diff SetUnion(list1, list2[, separator]) Category: Text function Description This function returns a deduplicated list with all values from list1 and list2. Arguments ArgumentTypeDescriptionlist1List (Text)A delimited set of string values.list2 anonymous@undisclosed.example.com (Anonymous) Fri, 12 Apr 2024 06:19:57 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:sign&rev=1628710515&do=diff Sign(number) Category: Number function Description This function determines whether number is positive, negative, or zero. If positive the value 1 is returned. If negative, the value -1 is returned. If number is 0, then 0 is returned. Arguments anonymous@undisclosed.example.com (Anonymous) Wed, 11 Aug 2021 19:35:15 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:sin&rev=1628978328&do=diff Sin(angle) Category: Number function Description This function returns the sine of the angle angle specified in radians. Arguments ArgumentTypeDescriptionangleNumberThe measurement of an angle, in radians. Return value type: Number Examples anonymous@undisclosed.example.com (Anonymous) Sat, 14 Aug 2021 21:58:48 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:sqrt&rev=1628710551&do=diff Sqrt(number) Category: Number function Description This function returns the square root of number. Arguments ArgumentTypeDescriptionnumberNumber (positive, >=0)The value from which the square root is calculated. Return value type: Number anonymous@undisclosed.example.com (Anonymous) Wed, 11 Aug 2021 19:35:51 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:square&rev=1628710579&do=diff Square(number) Category: Number function Description This function returns the square of number. Arguments ArgumentTypeDescriptionnumberNumberThe value to be squared (multiplied by itself). Return value type: Number Examples square(2) //Returns 4 anonymous@undisclosed.example.com (Anonymous) Wed, 11 Aug 2021 19:36:19 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:startswith&rev=1628982109&do=diff StartsWith(text, start_string) Category: Text function Description This function is a search function used to check if a string (text) starts with a specific text value (start_string). If so, this function returns TRUE. Otherwise, it returns FALSE. anonymous@undisclosed.example.com (Anonymous) Sat, 14 Aug 2021 23:01:49 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:strip&rev=1628994451&do=diff Strip(text) Category: Text function Description This function removes the first and the last characters from a text value. Use cases This function is typically used to remove wrapping characters such as quotes, parentheses, or brackets. anonymous@undisclosed.example.com (Anonymous) Sun, 15 Aug 2021 02:27:31 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:substringcount&rev=1628994349&do=diff SubstringCount(text, look_for) Category: Text function Description This function returns the number of instances of look_for found within text. Arguments ArgumentTypeDescriptiontextTextThe text value to search within for the look_for string. anonymous@undisclosed.example.com (Anonymous) Sun, 15 Aug 2021 02:25:49 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:system&rev=1637584734&do=diff System(keyword) Category: Special function Description This function returns the system value specified by the keyword argument. The keyword must be a text constant from the table below and may not be a data field reference or parameter. Arguments anonymous@undisclosed.example.com (Anonymous) Mon, 22 Nov 2021 12:38:54 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:tan&rev=1628978488&do=diff Tan(angle) Category: Number function Description This function returns the tangent of the angle angle specified in radians. Arguments ArgumentTypeDescriptionangleNumberThe measurement of an angle, in radians. Return value type: Number anonymous@undisclosed.example.com (Anonymous) Sat, 14 Aug 2021 22:01:28 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:today&rev=1630306542&do=diff Today() Category: Date and Time function Description This function returns today's date as a date serial number. Arguments This function does not require arguments. Return value type: Number (date serial value). Remarks This function returns the current date at the time the workflow is run. Each time the workflow is run, the date value updates to the present value. anonymous@undisclosed.example.com (Anonymous) Mon, 30 Aug 2021 06:55:42 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:tounixtime&rev=1630301850&do=diff ToUnixTime(date) Category: Date and Time function Description This function converts an EasyMorph (and Excel) date-time serial value to a Unix timestamp (the number of seconds since Jan 1st, 1970). Arguments ArgumentTypeDescriptiondateDate or Number (date serial) anonymous@undisclosed.example.com (Anonymous) Mon, 30 Aug 2021 05:37:30 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:trim&rev=1628709501&do=diff Trim(text) Category: Text function Description This function trims off all leading and trailing spaces, and other non-printing characters (see Remarks) from text. Arguments ArgumentTypeDescriptiontextTextAny text value or other value that can be implicitly converted to text if required. anonymous@undisclosed.example.com (Anonymous) Wed, 11 Aug 2021 19:18:21 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:trimend&rev=1628709553&do=diff TrimEnd(text) Category: Text function Description This function trims off all trailing spaces and other non-printing characters (see Remarks) from text. Leading spaces are preserved. Arguments ArgumentTypeDescriptiontextTextAny text value or other value that can be implicitly converted to text if required. anonymous@undisclosed.example.com (Anonymous) Wed, 11 Aug 2021 19:19:13 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:trimstart&rev=1628709617&do=diff TrimStart(text) Category: Text function Description This function trims off all leading spaces and other non-printing characters (see Remarks) from text. Trailing spaces are preserved. Arguments ArgumentTypeDescriptiontextTextAny text value or other value that can be implicitly converted to text if required. anonymous@undisclosed.example.com (Anonymous) Wed, 11 Aug 2021 19:20:17 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:true&rev=1629095855&do=diff True() Category: Logical function Description This function creates a Boolean value equal to TRUE. Use cases Use this function to set, or test for, a Boolean TRUE value. Arguments This function does not take any arguments. Return value type: anonymous@undisclosed.example.com (Anonymous) Mon, 16 Aug 2021 06:37:35 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:truncate&rev=1628710621&do=diff Truncate(number) Category: Number function Description This function returns the integer part of a number. Arguments ArgumentTypeDescriptionnumberNumberThe value, usually fractional, to be truncated. Return value type: Number (Integer) anonymous@undisclosed.example.com (Anonymous) Wed, 11 Aug 2021 19:37:01 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:upper&rev=1628994247&do=diff Upper(text) Category: Text function Description This function returns text converted to uppercase letters. Use cases This function can be used to perform a case-insensitive comparison of text values when the current case of the values are not known. The anonymous@undisclosed.example.com (Anonymous) Sun, 15 Aug 2021 02:24:07 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:uridecode&rev=1632013390&do=diff URIDecode(encoding, text) Category: Web function Description This function decodes a URL string such as an entire URL or just query-string values. Arguments ArgumentTypeDescriptionencoding Text The decoding method to use on text. text anonymous@undisclosed.example.com (Anonymous) Sun, 19 Sep 2021 01:03:10 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:uriencode&rev=1632013681&do=diff URIEncode(encoding, value) Category: Web function Description This function encodes a URL string such as an entire URL or just query-string values. Arguments ArgumentTypeDescriptionencoding Text The encoding method to use on text. text anonymous@undisclosed.example.com (Anonymous) Sun, 19 Sep 2021 01:08:01 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:user&rev=1466436516&do=diff user() Returns current user name (including domain). anonymous@undisclosed.example.com (Anonymous) Mon, 20 Jun 2016 15:28:36 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:utctime&rev=1631334241&do=diff UTCTime(date) Category: Date and Time function Description This function converts a local date/time into a UTC date/time. Arguments ArgumentTypeDescriptiondateDate or Number (date serial)An expression representing a date/time to generate the UTC date/time from. anonymous@undisclosed.example.com (Anonymous) Sat, 11 Sep 2021 04:24:01 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:weekday&rev=1632603422&do=diff Weekday(date) Category: Date and Time function Description This function returns the corresponding day-of-the-week number, from 1 (Sunday) to 7 (Saturday), from date. Arguments ArgumentTypeDescriptiondateDate or Number (date serial)An expression representing a date. The date value to derive the weekday number from. anonymous@undisclosed.example.com (Anonymous) Sat, 25 Sep 2021 20:57:02 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:weekdayname&rev=1631218361&do=diff WeekdayName(date) Category: Date and Time function Description This function returns the abbreviated name of the day date falls on. Arguments ArgumentTypeDescriptiondateDate or Number (date serial)An expression representing a date to derive the weekday name from. anonymous@undisclosed.example.com (Anonymous) Thu, 09 Sep 2021 20:12:41 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:weekend&rev=1631219956&do=diff WeekEnd(date) Category: Date and Time function Description This function returns the date serial number of the last day (Saturday) of the week date falls in. Arguments ArgumentTypeDescriptiondateDate or Number (date serial)An expression representing a date to derive the Saturday date value from. anonymous@undisclosed.example.com (Anonymous) Thu, 09 Sep 2021 20:39:16 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:weekstart&rev=1631219906&do=diff WeekStart(date) Category: Date and Time function Description This function returns the date serial number of the first day (Sunday) of the week date falls in. Arguments ArgumentTypeDescriptiondateDate or Number (date serial)An expression representing a date to derive the Sunday date value from. anonymous@undisclosed.example.com (Anonymous) Thu, 09 Sep 2021 20:38:26 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:when&rev=1630199867&do=diff When(condition, expression) Category: Logical function Description This function returns the result of expression if condition is TRUE. Otherwise, it returns empty value. This function is effectively a shorthand version of if(condition, expression, empty()) anonymous@undisclosed.example.com (Anonymous) Sun, 29 Aug 2021 01:17:47 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:workdays&rev=1747334904&do=diff Workdays(from_date, to_date, [exclude],[include]) Category: Date and Time function Description This function returns the number of workdays (i.e. all days except Saturday and Sunday) between from_date and to_date. Both date boundaries are inclusive. anonymous@undisclosed.example.com (Anonymous) Thu, 15 May 2025 18:48:24 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:xmlvalue&rev=1632014067&do=diff XMLValue(XML_text, XPath) Category: Web function Description This function extracts a single value or an XML node from a node specified by XPath. Arguments ArgumentTypeDescriptionXML_text Text A string representing an XML node. JSONPath Text anonymous@undisclosed.example.com (Anonymous) Sun, 19 Sep 2021 01:14:27 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:year&rev=1630305876&do=diff Year(date) Category: Date and Time function Description This function returns the year, as a four-digit number, from date. Arguments ArgumentTypeDescriptiondateDate or Number (date serial)An expression representing a date. The date value to derive the year number from. anonymous@undisclosed.example.com (Anonymous) Mon, 30 Aug 2021 06:44:36 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:yearday&rev=1742332623&do=diff YearDay(date) Category: Date and Time function Description This function returns the number of days since January 1st of year date falls in. Arguments ArgumentTypeDescriptiondateDate or Number (date serial)An expression representing a date from which the number of days since Jan 1st is calculated. anonymous@undisclosed.example.com (Anonymous) Tue, 18 Mar 2025 21:17:03 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:yearquarter&rev=1742332560&do=diff YearQuarter(date) Category: Date and Time function Description This function returns a time period formatted as year-quarter ("yyyy-Q#"), or an error if the argument is not a number date. Arguments ArgumentTypeDescriptiondateDate or Number (date serial) anonymous@undisclosed.example.com (Anonymous) Tue, 18 Mar 2025 21:16:00 +0000 https://help.easymorph.com/doku.php?id=syntax:functions:yearweek&rev=1742332405&do=diff YearWeek(date) Category: Date and Time function Description This function returns a time period formatted as year-ISO week number ("yyyy-W##"), or an error if the argument is not a number date. Arguments ArgumentTypeDescriptiondateDate or Number (date serial) anonymous@undisclosed.example.com (Anonymous) Tue, 18 Mar 2025 21:13:25 +0000