Workflow Automation
-
Automatic Estimate Aggregation
Retrieves data from the Quotation Process and sends an email with a list of the total number and value of…
-
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…
-
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…
-
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…
-
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…
-
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”.…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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)…
-
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…
-
TSV String, Verify Rectangle
Verifies that the cells are in a matrix format. If the number of cell values are different for each row,…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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…