TSV CSV

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 OR search with multiple texts, specify them as a comma-separated list such as “USA,U.S.,United States”.

TSV String, Filter by Numeric

TSV String, Filter by Numeric

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".

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 “2020-01-01<2020-01-07,2020-01-21<2020-01-27".

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 “2020-01-01 00:00<2020-01-07 23:59,2020-01-21 00:00<2020-01-27 23:59".

TSV String, Create Cross Tab for Numerical Sum

TSV String, Create Cross Tab for Numerical Sum

Creates a crosstab (pivot table) for numeric fields in TSV data. For example, the “Amount” in the order history (TSV) is aggregated on two axes, “Responsible” and “Product”. The fields for X-axis and Y-axis aggregation are specified by TSV field ID.

TSV String, Sort by Numeric

TSV String, Sort by Numeric

Sorts TSV text in the numerical order of the specified column. If each column values are “123 jpy”, “1,234 jpy”, and “12 jpy”, they are sorted in the order of “line including 12 jpy”, “line including 123 jpy”, “line including 1,234 jpy”.

TSV String, Sort by Text

TSV String, Sort by Text

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”.

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”.

Multiline String, Filter by Text

Multiline String, Filter by Text

Filters multiple-line string with any search text. Only lines that contain the search text 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”.

Addon: TSV String; Add Suffix to Column

TSV String; Add Suffix to Column

Generates a new TSV with concatenating the suffix Str to all cells in the column. The concatenated strings are added at the end of the line. Available for name honorifics or currency units etc. Removes whitespace from both ends of a string.

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; 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; 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; 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.

Multiline String; Delete Footer Lines

Deletes the Footer lines of a multiline string, like legacy Banking Formats or legacy EDI Data. Note that blank characters at the end or beginning of string data are deleted in advance. If singleline text, an empty string will be returned.