Add-ons

Home » Add-ons
String, Get Number of Characters

String, Get Number of Characters

Gets the number of characters in the text. Consecutive blanks (including tabs and double-byte spaces) are counted as one character. The number of characters that do not count linefeed codes and blanks can also be obtained.

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.

Converter: TSV-String to Table

Converter: TSV-String to Table

Converts TSV String to Table-type data. The string value of all cells in the TSV string is copied over Table-type data B. If there is an inconsistency in the Table column design, an error may occur.

Table, Duplicate

Table, Duplicate

Duplicates Table-type data. All cell value stored in Table-type data A is copied over Table-type data B. If the table column definitions are different, an error may occur.

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

Two Tsv Strings, Compare Numeric Cells

Two Tsv Strings, Compare Numeric Cells

Compares numeric column strings in TSV-A and TSV-B, and lists the amount of change from A to B. If there is no string that matches the key column of A, it will not be listed. If there are multiple matches, it will be compared with the key above.

Two Tsv Strings, Extract Cell-Mismatched Lines

Two Tsv Strings, Extract Cell-Mismatched Lines

Extracts B lines that DO NOT exist in A-Cell with comparing the specific column of TSV-A and the specific column of TSV-B. If A and B match exactly, an empty string is returned. If they are completely different, all lines in B are returned.

Two Tsv Strings, Extract Cell-Matched Lines

Two Tsv Strings, Extract Cell-Matched Lines

Extracts B lines that DO exist in A-Cell with comparing the specific column of TSV-A and the specific column of TSV-B. If A and B match exactly, all lines in B are returned. If they are completely different, an empty string is returned.

Generator (Text File)

Stores the values in a Any text type data item into a File type data item as a Text. It does not affect existing files. Just add.

TSV String, Filter Out by Text

TSV String, Filter Out by Text

Filters out TSV lines by any search text (Exclude Filter). Only lines that DO NOT contain the search text in the specified column are output. If OR search with multiple texts, specify them as a comma-separated list such as “USA,U.S.,United States”.