TSV CSV

TSV String; Add Prefix to Column

Generates a new TSV with concatenating the prefix Str to all cells in the column. The concatenated strings are added at the end of the line. Available at categorization etc. Removes whitespace from both ends of a string.

TSV String; Multiply N by Number Column

TSV String; Multiply N by Number Column

Generates a new TSV with multiplying N by each number in the number column. Calculation results are rounded off and added at the end of the line. Available for tax calculation etc. Removes whitespace from both ends of a string.

TSV String; Add N to Number Column

Generates a new TSV with adding N to each number in the number column. Calculation results are added at the end of the line. Available at discounted price table etc. Removes whitespace from both ends of a string.

TSV String, Filter by Datetime

TSV String, Filter by Datetime

Filters TSV strings using a Datetime range. Only the rows where the specified Datetime column is included in the Datetime range are output. If OR multiple ranges, like “2021-01-01 00:00<2021-01-07 23:59,2021-01-21 00:00<2021-01-27 23:59".

TSV String, Filter by Date

TSV String, Filter by Date

Filters TSV strings using a date range. Only the rows where the specified date column is included in the date range are output. If OR multiple ranges, specify in comma separated like “2021-01-01<2021-01-07,2021-01-21<2021-01-27".

TSV String, Filter Out by Text

TSV String, Filter Out by Text

Filters out TSV lines by any search text (Exclude Filter). Only lines that DO NOT contain the search text in the specified column are output. If you want to do an OR search with multiple texts, specify them as a comma-separated list such as “USA,U.S.,United States”.

TSV String, Filter by Text

TSV String, Filter by Text

Filters TSV string with any search text. Only lines that contain the search text in the specified column are output. If you want an OR search with multiple texts, specify them as a comma-separated list such as “USA,U.S.,United States”.

Questetra BPMS: Process, Extract as TSV

Questetra BPMS: Process, Extract as TSV

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)

TSV String; Re-order Columns

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.