Converts a timestamp number (UNIX time) to datetime data. That is, the number of seconds elapsed since UTC 1970-01-01 00:00:00 is assigned to the datetime type data according to the workflow platform time zone. (10-digit integer after 2002)
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”.
Gets the number of lines of text. The number of lines that do not count the trailing newline codes can also be stored.
Gets a specific line of a multi-line string. The line ID specification starts with 0.
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.
Overwrite the value of String type data item with the contents of a text file stored in File type data item.
Outputs business data to the Auto-Processing Log. Administrators of the Workflow App can verify the data that was stored when the Process reached this step.
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.
Determines whether a Corporate-Number string is valid. If valid, OK is logged. If invalid, the processing is abended to control with Error Boundary Event. The numbers are 13-digit IDs assigned to companies and other organizations registered in Japan.
Determines whether a My-Number string is valid. If valid, OK is logged. If invalid, the processing is abended to control with Error Boundary Event. My-Number is a 12-digit ID issued to all citizens and residents of Japan, including foreigners.
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.
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”.
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.
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.
Deletes data of any data type. By overwriting with a null value, all input values in the data item will be deleted.
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.
Duplicates Files-type data. All files stored in Files-type data A is copied over Files-type data B.
Replaces all full-width numbers with half-width numbers. Numbers from “０” to “９” are to be replaced. Symbols and letters are NOT replaced. The replacement count is output to the log.
Replaces all half-width numbers with full-width numbers. Numbers from “0” to “9” are to be replaced. Symbols and letters are NOT replaced. The replacement count is output to the log.
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”.
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”.