-
TSV String, Verify Rectangle
Verifies that the cells are in a matrix format. If the number of cell values are different for each row, tabs will be added. It is also possible…
-
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 the rightmost column. It realizes month-on-month and year-on-year…
-
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 matching rows from TsvB (right table); Left Outer…
-
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 and the index on the first row is…
-
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 there is even one single-byte space on the…
-
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 contains line breaks or tab, they are replaced…
-
TSV String, Convert
Changes the column order of TSV text. The new order is specified by enumerating the column IDs of the original TSV, like “0,1,3,0”. The new TSV text can…
-
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 attached, all will be converted according to the…
-
Converter: TSV-String to Table
Converts a TSV String to Table-type data. The string values of all cells in the TSV string are copied over to Table-type data B. If there is an…
-
MoneyForward Journal, Create
Creates the Journal-Slips (TSV or Excel) for MoneyForward Cloud Accounting. It supports not only batch sales invoices but also invoices that are prorated for each month.
-
Two Tsv Strings, Extract Cell-Matched Lines
Compares a specific column of TSV string A with a specific column of B and extracts the rows of B that have a matching cell in A. If…
-
Two Tsv Strings, Extract Cell-Mismatched Lines
Compares a specific column of TSV string A with a specific column of B and extracts the rows of B that do not have a cell match for…
-
Master Table, Create by TSV String
[su_box title="Master Table, Create by TSV String" style="soft" box_color="#ff99ff" title_color="#000000" radius="0"] Creates a new master file (OptionsXML) by referring to the TSV String. The specified column data 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 generated. The X-axis tick marks are refered to…
-
TSV String, Create Cross Tab for Numerical Sum
Creates a crosstab table (or pivot table) for the numeric fields of TSV data. For example, the "Amount" in the order history (TSV) is aggregated on the two…
-
TSV String; Sum of Number Column
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.
-
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…
-
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…
-
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…
-
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…
-
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…