-
Automatic Estimate Aggregation
Retrieves data from the Quotation Process and sends an email with a list of the total number and value of quotes issued in the last week. This is…
-
OpenAI: Chat, Interact with Parameters
Communicates with OpenAI API (ChatGPT). Instructions with conversation history and/or advanced parameters (PROMPT) are possible; Sampling temperature, Sampling Top_P, Presence penalty, Frequency penalty, Logit bias. Model ID used…
-
Multiline String, Filter by RegExp
Narrows down to just the matched lines from the multiline text. A regular expression (RegExp) can be specified as the match condition. Each line is determined to match…
-
TSV String, Filter by RegExp
Narrows TSV text to column matched rows only. A regular expression (RegExp) can be specified as the match condition, and the column value is matched for each row.…
-
Multiline String, Filter by Keywords
Narrows multi-line text down to matching lines only. The match condition can be either “equals”, “contains”, “begins with”, or “ends with”. A case-insensitive filter can also be specified.…
-
TSV String, Filter by Keywords
Filters TSV text to column-matched lines only. The match condition can be either “equals”, “contains”, “begins with”, or “ends with”. A case-insensitive filter can also be specified. It…
-
Text Files, Convert Character Encoding
Converts text files charset (Coded Character Set). For example, converts UTF-8 encoding to Shift_JIS or UTF-16. If multiple files are attached, all will be converted according to the…
-
Multiline String, Remove Duplicate Lines
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…
-
TSV String, Remove Column-Duplicate Lines
Extracts and deletes rows with duplicate column elements. In forward mode it keeps the first row, in reverse mode it keeps the last row. Note that “ABC” and…
-
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…
-
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…
-
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…
-
TSV String, Create Cross Table for Numeric Column
Aggregates the values in a numeric column by 2 aggregation-key columns: Pivot table. Sum, Percentage, Count and Average are tabulated as a cross table TSV. Eg, “Sales for…
-
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…
-
TSV String, Calc Changes in Two Numeric Columns
Calculates the difference and rate of change for the two numeric columns in the TSV. Adds the calculated value to the rightmost column. It realizes month-on-month and year-on-year…
-
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…
-
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…
-
Text Files, Convert Character Encoding
Converts text files charset (Coded Character Set). For example, converts UTF-8 encoding to Shift_JIS or UTF-16. If multiple files are attached, all will be converted according to the…
-
Image-Charts #Bar-Chart: Create
Creates a Bar/Line Chart from numeric TSV (population by country, monthly sales) using Image-Chart. The Y-axis tick marks are automatically generated. The X-axis tick marks are refered to…
-
Questetra BPMS #Process: Concat All Strings
Concatenates all string type data. Searches and joins string data and title strings stored as workflow data of Questetra BPM Suite. A line break is added between each…
-
Questetra BPMS #Process: List All File URLs
Lists the download URLs for the files stored as workflow data in Questetra BPM Suite. If two or more files are attached multiple lines of text will be…