Both sides previous revisionPrevious revisionNext revision | Previous revision |
syntax:functions [2023/11/02 07:43] – [Text functions] dmitry | syntax:functions [2024/04/12 02:30] (current) – [Text functions] craigt |
---|
|[[syntax:functions:right|Right]]|Returns the specified number of characters from the right of a string as a text value.| | |[[syntax:functions:right|Right]]|Returns the specified number of characters from the right of a string as a text value.| |
|[[syntax:functions:sanitize|Sanitize]]|Replaces tabs and line breaks with spaces and removes hidden system characters with ASCII codes 0 to 31 in the specified text. | | |[[syntax:functions:sanitize|Sanitize]]|Replaces tabs and line breaks with spaces and removes hidden system characters with ASCII codes 0 to 31 in the specified text. | |
| |[[syntax:functions:setcontainsall|SetContainsAll]]|Returns TRUE if a list contains all of the distinct values from a second list. | |
| |[[syntax:functions:setcontainsany|SetContainsAny]]|Returns TRUE if a list contains at least one value from a second list. | |
| |[[syntax:functions:setdifference|SetDifference]]|Removes values in one list, from another, with deduplication. | |
| |[[syntax:functions:setintersection|SetIntersection]]|Returns a deduplicated list of values that exist in two lists. | |
| |[[syntax:functions:setlength|SetLength]]|Returns the number of distinct values in a list. | |
| |[[syntax:functions:setsort|SetSort]]|Returns the distinct values of a list, sorted in ascending order | |
| |[[syntax:functions:setunion|SetUnion]]|Returns a deduplicated list from two source lists. | |
|[[syntax:functions:startswith|StartsWith]]|A search function used to check if a string starts with a specific text value. | | |[[syntax:functions:startswith|StartsWith]]|A search function used to check if a string starts with a specific text value. | |
|[[syntax:functions:strip|Strip]]|Removes the first and the last characters from the specified text value. | | |[[syntax:functions:strip|Strip]]|Removes the first and the last characters from the specified text value. | |
|[[syntax:functions:date|Date]]|Converts the given date-time, as text, into a date-time value represented as a number (date-time serial value) according to the specified format string. | | |[[syntax:functions:date|Date]]|Converts the given date-time, as text, into a date-time value represented as a number (date-time serial value) according to the specified format string. | |
|[[syntax:functions:day|Day]]|Returns the number of the corresponding day of the month, from 1 through 31, from the given date. | | |[[syntax:functions:day|Day]]|Returns the number of the corresponding day of the month, from 1 through 31, from the given date. | |
| |[[syntax:functions:detectformat|DetectFormat]]|Detects the date/time format of the text date (or timestamp). | |
|[[syntax:functions:format|Format]]|Converts the given data-time, as a date serial value, into a date-time text value formatted according to the specified format. | | |[[syntax:functions:format|Format]]|Converts the given data-time, as a date serial value, into a date-time text value formatted according to the specified format. | |
|[[syntax:functions:fromunixtime|FromUnixTime]]|Converts the specified Unix timestamp (the number of seconds since Jan 1st, 1970) to the numeric date-time serial value used in EasyMorph (and Excel). | | |[[syntax:functions:fromunixtime|FromUnixTime]]|Converts the specified Unix timestamp (the number of seconds since Jan 1st, 1970) to the numeric date-time serial value used in EasyMorph (and Excel). | |
|[[syntax:functions:isoweeknumber|ISOWeekNumber]]|Returns the ISO week number which ranges from 1 to 53 from the specified date. | | |[[syntax:functions:isoweeknumber|ISOWeekNumber]]|Returns the ISO week number which ranges from 1 to 53 from the specified date. | |
| |[[syntax:functions:istextdate|IsTextDate]]|Determines if the entered term is a recognizable text date. | |
|[[syntax:functions:isweekend|IsWeekend]]|Returns TRUE if the given date falls on a weekend day (Saturday or Sunday). | | |[[syntax:functions:isweekend|IsWeekend]]|Returns TRUE if the given date falls on a weekend day (Saturday or Sunday). | |
|[[syntax:functions:localtime|LocalTime]]|Converts a given UTC date-time into a local date-time. | | |[[syntax:functions:localtime|LocalTime]]|Converts a given UTC date-time into a local date-time. | |
|[[syntax:functions:makedate|MakeDate]]|Returns a date serial number based on the specified year, month and day numeric values. | | |[[syntax:functions:makedate|MakeDate]]|Returns a date serial number based on the specified year, month, and day numeric values. | |
|[[syntax:functions:month|Month]]|Returns the corresponding month number, 1 through 12, from the given date. | | |[[syntax:functions:month|Month]]|Returns the corresponding month number, 1 through 12, from the given date. | |
|[[syntax:functions:monthend|MonthEnd]]|Returns the date serial number of the last day of the month the specified date falls in. | | |[[syntax:functions:monthend|MonthEnd]]|Returns the date serial number of the last day of the month the specified date falls in. | |