TSV CSV
-
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…
-
String List, Check for Existence of Search String
Checks for the existence of string elements in the list that match the search string.
-
TSV String, Convert date data to yyyy-MM format
Converts the date data in the specified column to yyyy-MM or yyyy format and appends the value to the end…
-
Google Sheets #Row_Range: Delete
Deletes rows in the specified range. Existing cells will be shifted upward. Both the start and end rows are specified…
-
Questetra BPMS: Process, Batch Extract as TSV
Extracts process data as a multiline TSV string from local or remote workflow platform via API. Field-Items are specified in…
-
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,…
-
Converter: Multiline-String to Singleline-CSV-String
Converts a multiline string to a CSV string. Converts each row of a multiline string as the value of each…
-
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…
-
Questetra BPMS #Process: Batch Extract by Filter as TSV
Extracts process data that match the specified saved filter. Stores the extracted data list as a TSV string. The filter…
-
TSV String, Create Cross Table of Count
Aggregates the count of data by 2 aggregation-key columns: Pivot table. Count and Percentage are tabulated as a cross table…
-
TSV String, Create Summary Table of Count
Aggregates the count of data by aggregation-keys. Count and Percentage are tabulated as a summary table TSV. Eg, Survey Results…
-
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, Create Summary Table for Numeric Column
Aggregates the values in a numeric column by aggregation-keys. Sum, Percentage, Count and Average are tabulated as a summary table…
-
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…
-
Two TSV Strings, Join on Common Column
Merges two TSVs based on a common key-field. Keeps all the rows from TsvA (left table) and brings in any…
-
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…
-
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…
-
TSV String, Convert
Changes the column order of TSV text. The new order is specified by enumerating the column IDs of the original…