Easy-Config Addon

Singleline String, Set Nth Line of Multiline

Singleline String, Set Nth Line of Multiline

Extracts one line of a multi-line string and sets that line in single-line String-type Data Item. The Line ID mut be an integer starting with zero. If the Line ID is not specified, or if a number outside the range is specified, the last line will be extracted.

TSV String, Sum Numeric Column

TSV String, Sum Numeric Column

Sums the values in the numeric column in the TSV. If the numeric field contains commas, they will be removed and then parsed. If you need to add up for each key, use “Summary tabulation” or “Cross tabulation”.

Date, Get Weekend Sunday

Date, Get Weekend Sunday

Gets weekend Sundays of any date. If Sunday is specified, that day itself will be returned. If you want to get “Monday of the next week” or “Tuesday of the current week”, you need to convert like #q_date.addDays(1) or #q_date.addDays(-5).

Converter, CSV-String to TSV-String

Converts a CSV string to a TSV string. The TSV is output as the simplest tab-delimited string. If the field contains line breaks or tab, they are replaced with spaces. If the double-quotes in the input CSV are not escaped, the output will be unintended.

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

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 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.