TSV CSV

Questetra BPMS #Process: Extract as TSV

Add-ons / 2021-07-06 / Questetra Workflow API, TSV CSV

Extracts process data as single-line TSV string. Items are specified in CSV format such as “0,2,3”. Tab code and line feed code are automatically deleted. Discussion type, Table Extracts process data as a single-line TSV string. Items are specified in a CSV format such as “0,2,3”. Tab code and line feed code are automatically deleted. Discussion-type, Table-type and Guide-Panel type cannot be extracted (Warning Log).type, Guide-Panel type cannot be extracted (Warning Log)

Add-ons

#Email-HTML-String: Create TsvTable

Add-ons / 2021-06-24 / HTML email, TSV CSV

Assembles HTML code for HTML email that can check TSV strings. Inserts TableRow (TR) and TableData (TD) depending on the number of items in the TSV string. It is used when you want to automatically notify the TSV data stored in a workflow by mail.

Add-ons

Google Sheets: ValueRanges, Export as TSV

Add-ons / 2021-04-27 / authSetting(), Google Sheets API v4, Google Workspace, TSV CSV

Stores a specified rectangular range of data as a TSV String. Empty cells are regarded as an empty string. Exporting two ranges at the same time is also supported. For example, the heading line and the 10th and subsequent lines can be exported at the same time.

Add-ons

Questetra BPMS: Process, Kick HttpStartEvent by TSV

Add-ons / 2021-02-17 / httpClient, TSV CSV

Kicks HttpStartEvent with the specific line data of TSV. When assuming batch start using multiline TSV data, place it in a loop structure. LineIDs start at zero.

Add-ons

Master Table, List All Options as TSV String

Add-ons / 2021-02-17 / TSV CSV

Includes the master table on Workflow Platform as a string property of the process. The IDs and Labels are concatenated into TSV (Tab-Separated Values) and stored into Multiline-String type.

Add-ons

Google Sheets: Values, Export as TSV

Add-ons / 2021-02-01 / bearer(oauth2Token), Google Sheets API v4, Google Workspace, TSV CSV

Exports the values in the rectangular range as TSV text, which has the same number of tab delimiters on each line. Empty cells are regarded as the null string. Two range export are also supported: e.g. Freezed headings and recent data.

Add-ons

TSV String; Re-order Columns

Add-ons / 2021-02-01 / TSV CSV

Extracts a new TSV string re-arranged by a column ID list from TSV string. ID repetition in the list is also possible. It can be used to narrow down necessary information or conform to the format. Removes whitespace from both ends of a string.

Add-ons

TSV String, Filter by Numeric

Add-ons / 2021-02-01 / TSV CSV

Filters TSV strings using a numeric range. Only the rows where the specified numeric column is included in the numeric range are output. If you want to OR multiple ranges, specify them in comma separated form like “-100<36.4,37.5<100".

Add-ons

Google Sheets: Sheet Row, Update with Singleline TSV

Add-ons / 2020-10-28 / Google Sheets API v4, Google Workspace, TSV CSV

Updates a Google Sheet with a single line of TSV data. Searches for an A-Column cell that exactly matches the first value of the TSV and overwrite only the first occurrence. The values will be parsed as if they were entered manually by the user. If no matching line exists, it will be appended at the end.

Add-ons

Multiline String, Dequeue First

Add-ons / 2020-10-16 / TSV CSV

Removes the first line from the multiline string. One line less than the original string. By placing in a loop flow or in a recursive workflow, data list can be processed sequentially.

Add-ons

Singleline TSV String, Extract Cell

Add-ons / 2020-10-16 / TSV CSV

Extracts the cell value of the specified ID. The ID starts from zero. The extracted cell string can be stored not only in the STRING type data but also in the NUMERIC type, DATE type, DATETIME type, SELECT type, USER type, and ORG type data.

Add-ons

Google Sheets: Sheet, Append TSV

Add-ons / 2020-10-14 / Google Sheets API v4, Google Workspace, TSV CSV

Adds the TSV dataset after the last row. New rows will be inserted into the sheet if necessary. Only the specified columns of TSV are added, column ID with an identifier “d” as Datetime, and column ID with an identifier “n” as Numeric; eg “0,2d,5n”.

Add-ons

Converter: TSV-String to Table

Add-ons / 2020-02-28 / ListArray, TSV CSV

Converts TSV String to Table-type data. The string value of all cells in the TSV string is copied over Table-type data B. If there is an inconsistency in the Table column design, an error may occur.

Add-ons

TSV String, Sort by Text

Add-ons / 2019-12-03 / Easy-Config Addon, TSV CSV

Sorts TSV lines in the order of the character code of the specified column. If the column value for each line is Jan Feb March, the text is sorted in the order of “line that contains Feb”, “line that contains Jan” and “line that contains March”.

Add-ons

TSV String; Sum of Number Column

Add-ons / 2019-08-05 / TSV CSV

Calculates the sum of values in numeric column. If non-numeric data is mixed in the specified column, the record is regarded as zero and not added.

Questetra BPM Suite