Files Duplicate From Multi Items
Duplicates File-type data to other File-type Data Items. All files stored in File-type Data Item A is copied over to File-type Data Item B
Easy-Config Addon
String, Batch Replace to LowerCase
Replaces uppercase letters in the text with corresponding lowercase letters. An input of “ABC”, “Abc”, “abc” will all be output as “abc”. It is used to store case-insensitive data such as Internet domain or search words.
String, Batch Replace to UpperCase
Replaces lowercase letters in the text with corresponding uppercase letters. An input of “ABC”, “Abc”, “abc” will all be output as “ABC”. It is used to store case-insensitive data such as MS-DOS file names or BASIC codes.
Google Chat: Space, Create Message
Posts a message in a Google Chat Space. Bold decoration (with asterisks) and Inline-code decoration (with backticks) are also applied as they are. It is also possible to attach some Process Data in card format.
String, Batch Add Thousands Separators
Detects numbers with more than three digits in the text and adds thousand separators to each number. A comma, dot, or space can be specified as the digit separator. Note that this replacement will also be applied to decimals, postal codes and years.
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.
Singleline String, Set One Line from Multiline Randomly
Extracts one line randomly from the multi-line string and sets that line in singleline string data. For example, it can be used to test sales copy or to set the response text for lottery results. It is also possible to exclude specific rows from the selection candidates.
Singleline String, Set One Line from Multiline using Round-Robin
Extracts one line from the multi-line string in order using a round robin method and sets that line in single-line string data. For example, it can be used to test sales copy or to set the response text for lottery results. It is also possible to exclude specific rows from the selection candidates.
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”.
Multiline String, Search by Text
Searches a multiple-line string with any search text. Only lines that exactly matches the search text are output.
Select-type Data Item, Auto Assignment (el-enabled)
The selection result is set to a Select-type Data Item by an arbitrary string. EL expressions can also be used for strings.
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).
Date, Get Day of Week String
Gets the string for the day of the week. The notation of the day is set in the config such as “Sun,Mon,Tue,Wed,Thu,Fri,Sat” or “Closed,Open,Open,Open,Open,Open,Closed”. The beginning is Sunday.
TSV String, Switch Rows and Columns
Switches the row and column indices of the rectangle TSV. The output matrix (Transposed Matrix) is obtained by changing cell(x,y) to (y,x). Used for data arrangement for frequency distribution tables and histograms.
TSV String, Verify Rectangle
Verifies that the cells are in a matrix format. If the number of cell values are different for each row, tabs will be added. It is also possible to get the number of rows and columns after formatting. No trailing newline will be added to the verified TSV.
Multiline String, Get Range Lines
Extracts the specified range of rows. The range is specified by Begin Index and End Index. The index is zero-based and the index on the first row is zero. Note that the row specified by the End Index is not included in the range.
Multiline String, Delete Empty Lines
Removes all blank rows. Line breaks at the end of the text (including TSV and CSV) are also removed. If there is even one single-byte space on the line, it will not be deleted.
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
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
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.
Corporate-Number String, Test Check Digit
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.