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

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.

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.

String, Get Number of Words

String, Get Number of Words

Gets the number of words in the text. Words separated by spaces (including tabs, double-byte spaces, and line breaks) are counted. The number of words counted, including commas and periods as delimiters, can also be obtained.

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

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

Stripe: Customer, Destination Charge

Stripe: Customer, Destination Charge

Creates the Charge object with Transfer Amount to charge the Customer ID for any amount in any currency. Any Connected Account are available. If the primary payment method (Customer object) fails, the backup payment method will be charged. If all method fails, no Charge object will be created and an Abended Error log will be output.

Stripe: Customer, Charge

Stripe: Customers, Charge

Creates the Charge object on the payment platform Stripe. If the primary payment method (Customer object) fails, the backup payment method will be charged. If all method fails, no Charge object will be created and an Abended Error log will be output.

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

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: Quser to Email-String

Converter: Quser to Email-String

Converts Quser type data to Email string by referencing the latest information registered in the Workflow Platform. It is also possible to obtain “User ID”, “User Name”, “Main Organization”, “ID of Main Organization”, “Name of Main Organization”.

Converter (Email-Str to Quser)

Converts string type data (email string) to Quser type data. If it does not match any registered address, the user type data item will not be updated. When multiline string, it is judged in order from the first line until it matches.

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 “line including 12 jpy”, “line including 123 jpy”, “line including 1,234 jpy”