Converts an Email string to USER data. If the address is not registered as a user address, an error will occur (USER not updated). If multiple addresses are enumerated in multiline or comma-delimited string, determined sequentially from the top.
Starts a conversation with the OpenAI API (ChatGPT). The MODEL used is “gpt-4” by default (configurable). A response (COMPLETION) to an instruction question (PROMPT) is automatically obtained.
Starts a conversation with the OpenAI API (ChatGPT). The model ID used is “gpt-3.5-turbo”. A response (COMPLETION) to an instruction question (PROMPT) is automatically obtained.
Duplicates File-type data. All files stored in Data Item A1 (Original Files) will be copied over to Data Item B1 (Clone Files). Also possible to change the file name or Content-Type. If the same Data Item is specified as A1 and B1, overwritten.
Extracts and deletes all duplicate rows. In forward order mode, the first row is retained; in reverse order mode, the last row is retained. Note that “ABC” and “Abc” are recognized as different columns. (case sensitive)
Calculates the duration between Datetime-A and Datetime-B; like elapsed days (e.g. “1.38 d”), hours (e.g. “33.33 h”), minutes (e.g. “2000.00 min”) and/or time (e.g. “33:20”). A minus sign is given if Datetime-B is earlier than Datetime-A.
Converts strings such as “2022-12-31” or “2022-12-31 00:00” to Datetime (or Date) data. Also supports strings like “2022/12/31” and “19700101”. Any string is evaluated as local time. The timestamp value (seconds since 1 Jan 1970) is also gettable.
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
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.
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.
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.
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.
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.
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.
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.
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”.
Searches a multiple-line string with any search text. Only lines that exactly matches the search text are output.
The selection result is set to a Select-type Data Item by an arbitrary string. EL expressions can also be used for strings.
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).
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.
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.