Add-ons

2020-02-26

●

2020-02-26

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.
2020-02-21

●

2020-02-21

Files, Duplicate

Duplicates Files-type data. All files stored in Files-type data A is copied over Files-type data B.
2020-02-18

●

2020-02-18

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”.
2020-02-06

●

2020-02-06

Google Sheets: Master Table, Simple Xlookup

Returns a value by referencing master data in Google Spreadsheets. Searches for the Lookup Value in array C, and if an exact match, returns the value in array D at the same index. C and D are defined in A1Notation. The length…
2020-02-04

●

2020-02-04

String, Batch Replace Fullwidth Numbers with Halfwidth Numbers

Replaces all full-width numbers with half-width numbers. Numbers from “０” to “９” are to be replaced. Symbols and letters are NOT replaced. The replacement count is output to the log.
2020-02-04

●

2020-02-04

String, Batch Replace Halfwidth Numbers with Fullwidth Numbers

Replaces all half-width numbers with full-width numbers. Numbers from “0” to “9” are to be replaced. Symbols and letters are NOT replaced. The replacement count is output to the log.
2020-01-30

●

2020-01-30

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…
2020-01-29

●

2020-01-29

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…
2020-01-29

●

2020-01-29

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…
2020-01-14

●

2020-01-14

Google Drive: Copy File

Creates a copy of a file into the Folder
2019-12-26

●

2019-12-26

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”.
2019-12-25

●

2019-12-25

Google Drive: File, Convert

Converts file in Google Drive and save as another MimeType file. Supports both Google Doc files and common files. File ID can be obtained from URI etc. (If Folder-ID not specified, the file will inherit any discoverable parents of the source file.)
2019-12-25

●

2019-12-25

Google Drive: GFile, Export as Text

Exports text information from a GFile in Google Drive. If a file other than a Google file (Docs / Slides) is specified, an error will occur (Please use File Download). File ID can be obtained from URI.
2019-12-12

●

2019-12-12

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 “2020-01-01
2019-12-12

●

2019-12-12

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 “2020-01-01 00:00
2019-12-05

●

2019-12-05

TSV String, Create Cross Tab for Numerical Sum

Creates a crosstab (pivot table) for numeric fields in TSV data. For example, the “Amount” in the order history (TSV) is aggregated on two axes, “Responsible” and “Product”. The fields for X-axis and Y-axis aggregation are specified by TSV field ID.
2019-12-03

●

2019-12-03

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

●

2019-12-03

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…
2019-11-25

●

2019-11-25

TSV String, Filter by Text

Filters TSV string with any search text. Only lines that contain the search text in the specified column are output. If you want an OR search with multiple texts, specify them as a comma-separated list such as “USA,U.S.,United States”.
2019-11-22

●

2019-11-22

Multiline String, Filter by Text

Filters multiple-line string with any search text. Only lines that contain the search text are output. If you want an OR search with multiple texts, specify them as a comma-separated list such as “USA, U.S., United States”.
2019-11-21

●

2019-11-21

Questetra BPMS: Process, Batch Extract as TSV

Extracts process data as a multi-line TSV string from date-filtered processes. Items are specified in CSV format such as “string:0,date:2,select:3”. Tab code and line feed code are deleted. Discussion, Table, Guide-Panel type not supported.

Tag cloud