Extracts process data that match the specified saved filter. Stores the extracted data list as a TSV string. The filter is specified by ReportID which must be saved in the target platform in advance.
Formats the specified range of columns from START index to END index of the TSV (END not included). The index starts from “0”. Negative index counts back from the end. If START is omitted “from the beginning”, and if END is omitted “to the end”.
Extracts the specified range of columns from START index to END index of the TSV (END not included). The index starts from “0”. Negative index counts back from the end. If START is omitted “from the beginning”, and if END is omitted “to the end”.
Adds the calc result as a new column. The result of binary calculations such as “adding column A and column B” or “multiplying column C by 1.1” are added to the end of each TSV row. Subtraction, division, remainder, and exponentiation also supported.
Replaces all strings that match the regular expression. For example, all Phone Numbers ‘\d{3}-\d{3}-\d{4}’ in a text string can be replaced with “999-999-9999”.
Extracts a string that match the RegExp for each line. If set an “Email String”, the email address in the specified cell will be added as a new cell at the end of the line. If no match, an empty will be added. The capture group also available.
Extracts all strings that match the regular expression. For example, if set “URL regular expression”, all URLs in the text will be extracted.
Converts a TSV string to a Markdown string. The first line of the TSV is recognized as a header line, and the second and subsequent lines are recognized as data lines. Also supports column settings such as right alignment and center alignment.
Extracts the values of specified cells in A1 notation. The extracted string can be stored not only in the STRING type data but also in the NUMERIC type, DATE type, DATETIME type, SELECT type, USER type, and ORG type data if the format allows.
CSV/TSV data entered as String-type (multiple lines) is treated as an RDB table, and the data is manipulated by queries (SQL). The results of the query are saved in the specified String-type (multiple lines) Data Item. Two data can also be combined.
This item overwrites the value of a Table type data item with a contents of an Excel compatible CSV file (TSV UTF-16 LE with BOM) stored in a File type data item.
This item stores the values in a Table type data item into a File type data item as an Excel compatible CSV. The file is added and does not affect existing files.
Includes the master table on Workflow Platform as a string property of the process. The IDs and Labels are concatenated into TSV (Tab-Separated Values) and stored into Multiline-String type.
Kicks HttpStartEvent with the specific line data of TSV. When assuming batch start using multiline TSV data, place it in a loop structure. LineIDs start at zero.
Extracts the cell value of the specified ID, starting from zero. The extracted cell string can be stored not only in the String-type data but also in the Numeric-type, Date-type, Datetime-type, Select-type, User-type, and Org-type data.
Duplicates File-type data. All files stored in Data Item A1 (Original Files) will be copied over to Data Item B1 (Clone Files). Also possible to change the file name or Content-Type. If the same Data Item is specified as A1 and B1, overwritten.
Narrows TSV text to column matched rows only. A regular expression (RegExp) can be specified as the match condition, and the column value is matched for each row. It is also possible to store excluded rows (filtered rows).
Filters TSV text to column-matched lines only. The match condition can be either “equals”, “contains”, “begins with”, or “ends with”. A case-insensitive filter can also be specified. It is also possible to separately store the excluded rows (filtered rows).
Converts text files charset (Coded Character Set). For example, converts UTF-8 encoding to Shift_JIS or UTF-16. If multiple files are attached, all will be converted according to the same rules.
Extracts and deletes rows with duplicate column elements. In forward mode it keeps the first row, in reverse mode it keeps the last row. Note that “ABC” and “Abc” are recognized as different columns. (case sensitive)
Checks for the existence of string elements in the list that match the search string.