TSV CSV
-
Questetra BPMS #Tasks: Extract by Report ID
Extracts task (workitem) data via API in TSV format. The data is extracted using the ReportID of the filtered list…
-
Questetra BPMS #Cases: Extract by Report ID
Extracts case data via API in TSV format. The data is extracted using the ReportID of the filtered list configured…
-
Questetra BPMS #Process: Batch Extract by Filter as TSV
Extracts process data that match the specified saved filter. Stores the extracted data list as a TSV string. The filter…
-
#TSV-String: Add Thousands Separators
Formats the specified range of columns from START index to END index of the TSV (END not included). The index…
-
#TSV-String: Extract Range Columns
Extracts the specified range of columns from START index to END index of the TSV (END not included). The index…
-
#TSV-String: Basic Math on Numeric Strings
Adds the calc result as a new column. The result of binary calculations such as “adding column A and column…
-
#String: Replace All by RegExp
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…
-
#TSV-String: Extract by RegExp for each Line
Extracts a string that match the RegExp for each line. If set an “Email String”, the email address in the…
-
#String: Extract by RegExp
Extracts all strings that match the regular expression. For example, if set “URL regular expression”, all URLs in the text…
-
Converter: #TSV String to #Markdown String
Converts a TSV string to a Markdown string. The first line of the TSV is recognized as a header line,…
-
TSV String: Extract Cells
Extracts the values of specified cells in A1 notation. The extracted string can be stored not only in the STRING…
-
Update CSV Data
CSV/TSV data entered as String-type (multiple lines) is treated as an RDB table, and the data is manipulated by queries…
-
Converter (TSV File to Table type data)
This item overwrites the value of a Table type data item with a contents of an Excel compatible CSV file…
-
Converter (Table type data to Excel-CSV File)
This item stores the values in a Table type data item into a File type data item as an Excel…
-
Master Table: List All Options as TSV String
Includes the master table on Workflow Platform as a string property of the process. The IDs and Labels are concatenated…
-
Questetra BPMS #Process: Kick HttpStartEvent by TSV
Kicks HttpStartEvent with the specific line data of TSV. When assuming batch start using multiline TSV data, place it in…
-
Singleline CSV String, Extract Cell
Extracts the cell value of the specified ID, starting from zero. The extracted cell string can be stored not only…
-
Files, Duplicate
Duplicates File-type data. All files stored in Data Item A1 (Original Files) will be copied over to Data Item B1…
-
TSV String, Filter by RegExp
Narrows TSV text to column matched rows only. A regular expression (RegExp) can be specified as the match condition, and…
-
TSV String, Filter by Keywords
Filters TSV text to column-matched lines only. The match condition can be either “equals”, “contains”, “begins with”, or “ends with”.…
-
Text Files, Convert Character Encoding
Converts text files charset (Coded Character Set). For example, converts UTF-8 encoding to Shift_JIS or UTF-16. If multiple files are…