TSV CSV

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.

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.

TSV String; Add Static Value to All Lines

Adds the new string cell to the end of all rows. If there are space characters or line feed characters at the beginning and end of the TSV, they will be deleted beforehand. If the number of tab separators does not match, an error will occur.

Converter (ZENGIN to MizuhoCSV)

Generates a general transfer file for Mizuho Bank. The file of “ZENGIN format” defined by the Japanese Bankers Association is converted to the file for “Mizuho Business Web” service. Each line consists of “Customer Code 1” and “payment amount”.

Journal-TSV Create

Creates the Journal-Slip TSV. The transfer slip TSV of the sales is generated based on the Invoice data. To generate a file that can be imported into the accounting system, place a converter such as “TSV to Excel-CSV FILE” in the downstream process.

Converter (Table to Excel-CSV FILE sjis)

2020-02-27 (C) Questetra, Inc. (MIT License)https://support.questetra.com/addons/converter-tabletoexcelcsvsjis/ Download Converter-TableToExcelCsvSjis.xml Capture Notes It is also possible to change the order of columns, filter columns, list columns duplicately etc. The file entity consists of comma-separated-values (Shift-JIS) Compare to tab-separated-values (utf-16le-bom) version, the availability of smartphone display and data import increases, but comma information in data misses.

Converter (TSV to Excel-CSV) SJIS

Download Converter-TsvToExcelCsvSjis.xml Capture Notes It is also capable of changing the order of columns, filtering, listing duplicately. The file entity consists of comma-separated-values (Shift-JIS) Compare to tab-separated-values (utf-16le-bom) version, the availability of smartphone display and data import increases, but comma information in data misses. See also 2017-04-03 Episode 529: Making PayPal Operation into Subroutine

Journal Slip TSV from Invoice Data

Generate transfer slip TSV (tab-separated-values) with sales amount, sales date, due date. It supports cases where add a sales collectively or divided into several months or mixture of those. In order to generate a file for the accounting system, you need to place a converter such as “TSV to Excel-CSV FILE”.