Easy-Config Addon

String, Get MD5-Hash

String, Get MD5-Hash

Calculates the MD5 digest. The MD5 hash algorithm is applied against the source data to generate a unique 128-bit hash value: sequence of 32 hexadecimal digits. This checksum algorithm is a commonly used function for validating data integrity.

String, Replace All

String, Replace All

Replaces all the search strings by the replacement string. All matches are case sensitive. For example, it is possible to completely replace the string “XXXX-XX-XX” in the template text with “2020-05-11”.

String, Extract Substring

String, Extract Substring

Extracts N characters from the beginning. If negative, N characters (absolute value) are extracted from the end. When the length of the original string is shorter than N, returns the original. To be padded to N, set the pad string.

Two Datetimes, Calculate Duration

Two Datetimes, Calculate Duration

Calculates the duration between datetime A and B to output as numerical value (days), numerical value (hours), numerical value (minutes), or string value (h:mm). If B is the past time, a minus sign will be added. Date type also available.

Fiscal Month-Day String, Create

Fiscal Month-Day String, Create

Creates a date ID for fiscal year sorting. The first day of the first month of the fiscal year will be “101”. The 25th day of the last month is “1225”. If the fiscal year starts in Jan, the string will be the same as the calendar format “Mdd”.

String, Get Number of Characters

String, Get Number of Characters

Gets the number of characters in the text. Consecutive blanks (including tabs and double-byte spaces) are counted as one character. The number of characters that do not count linefeed codes and blanks can also be obtained.

String, Get Number of Words

String, Get Number of Words

Gets the number of words in the text. Words separated by spaces (including tabs, double-byte spaces, and line breaks) are counted. The number of words counted, including commas and periods as delimiters, can also be obtained.

Table, Duplicate

Table, Duplicate

Duplicates Table-type data. All cell value stored in Table-type data A is copied over Table-type data B. If the table column definitions are different, an error may occur.

TSV String, Sort by Numeric

TSV String, Sort by Numeric

Sorts TSV text in the numerical order of the specified column. If each column values are “123 jpy”, “1,234 jpy”, and “12 jpy”, they are sorted in the order of “line including 12 jpy”, “line including 123 jpy”, “line including 1,234 jpy”.

TSV String, Sort by Text

TSV String, Sort by Text

Sorts TSV lines in the order of the character code of the specified column. If the column value for each line is Jan Feb March, the text is sorted in the order of “line that contains Feb”, “line that contains Jan” and “line that contains March”.

TSV String, Filter by Text

TSV String, Filter by Text

Filters TSV string with any search text. Only lines that contain the search text in the specified column are output. If you want an OR search with multiple texts, specify them as a comma-separated list such as “USA,U.S.,United States”.

Number, Generate Random

Number, Generate Random

Generates a random number. When a token reaches this automated step, a numerical value within the specified range is generated each time. The decimal part is rounded down toward 0 according to the workflow data definition.