Converter (Table type data to Excel-CSV File)
Stores the values in a Table type data item into a File type data item as an Excel compatible CSV. It does not affect existing files. Just add.
TSV CSV
Google Sheets: Values, Export as TSV
Exports the values in the rectangular range as TSV text, which has the same number of tab delimiters on each line. Empty cells are regarded as the null string. Two range export are also supported: e.g. Freezed headings and recent data.
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 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
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.
Multiline String; Delete Header Lines
Deletes the header lines of a multiline string, like CSV text or TSV text. 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”.
Converter (JapanZipCsv to JapanZipXml)
Generates a postal code master. The zip data “KEN_ALL.CSV” (120k lines) of Japan Post is converted to “Japan-Zip.xml”. You can refer to postal code master in input form settings such as “Select (Search Select box)”.
Converter (JigyosyoZipCsv to JigyosyoZipXml)
Generates a postal code master. The business zip “JIGYOSYO.CSV” (20k lines) by Japan Post Co., Ltd. is converted to “Jigyosyo-Zip.xml”. If “Japan-Zip.xml” (120k lines) is specified, “Jigyosyo-Zip.xml” (140k lines) will be created.
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.
Add Column to Tsv
Adding a character string to the end of each row of the tab delimited text (TSV) and stores it as a new TSV in a String type Data Item.
Delete Rows of Tsv
Remove the specified number of rows from the top from the tab-delimited text (TSV) stored in the String type Data Item
Converter (TSV to Excel-CSV) SJIS
A tab delimited text (TSV) stored in a String type data item is saved as an Excel compatible CSV file in a File type Data Item.
Converter (Table to Excel-CSV FILE sjis)
Stores the values in a Table type data item into a File type data item as an Excel compatible CSV.
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”.