Skip to content

Export Text Activity

The Export Text activity creates columns within a dataset by separating data from a specified text file. It uses defined value ranges to segment the text, transforming raw text into structured dataset columns. This activity is essential for parsing fixed-width or range-delimited text data into a usable tabular format.

Field Description Requirement
Text name The reference name of the text file, which has already been opened or created, is chosen in the dropdown. Required
Headers Header names for the dataset are written. Optional
Value ranges Value start and end indexes for each column of the dataset are written. Required
Trim This option provides trimming whitespace characters from the beginning and end of the values. Optional
New dataset name The reference name is given to the dataset that will be created in this field. Required

Action Types & Examples

Text Name

  • Format: String
  • Example Result: newText

Headers

  • Format: Comma-separated string
  • Example Result: adı,soyadı

Value Ranges

  • Format: Comma-separated string of index ranges (e.g., start-end)
  • Example Result: 0-12,13-25

New Dataset Name

  • Format: String
  • Example Result: newDS

Implementation Examples

Field Setup - Text name: newText - Headers: adı,soyadı - Value ranges: 0-12,13-25 - Trim: true - New dataset name: newDS

Execution Parameters - Text name: newText - Headers: adı,soyadı - Value ranges: 0-12,13-25 - Trim: true - New dataset name: newDS

Technical Notes

The Export Text activity processes text files based on character index ranges. It is crucial to ensure that the specified Value ranges accurately reflect the desired data segments within the source text to prevent data truncation or misalignment. The activity handles various text encodings, but consistent encoding across the source file and processing environment is recommended for optimal results.