Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |
| syntax:functions [2023/11/24 20:34] – craigt | 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. | |
