TSV CSV

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 with spaces. If the double-quotes in the input CSV are not escaped, the output will be unintended.

TSV String, Convert

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 also be stored in formats such as TSV file format and CSV file format.

Converter: TSV-String to Table

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 inconsistency in the Table column design, an error may occur.

MoneyForward Journal, Create

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

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 A and B match exactly, all lines in B are returned. If they are completely different, an empty string is returned.

Two Tsv Strings, Extract Cell-Mismatched Lines

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 A. If A and B match exactly, an empty string is returned. If they are completely different, all lines in B are returned.

Master Table, Create by TSV String

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 set as Master IDs, and the other data is set as Master Labels. By placing a [Service Task (Choices Update)] in the downstream process, the update task can be automated.[/su_box]