Generate Data Table From Text

Parses delimited text into a structured DataTable.

Behaviour

Risk: None · Idempotent: Yes · Safe to retry: Yes · Recovery: Not replayed after a crash

Package System activities VeloPhex.System.Activities 0.7.1-rc.12 · Supported (Core profile) · type id velophex.system.generateDataTableFromText

Properties#

Input#

Text#

Text · String · Required · Default: Not specified in package metadata

The delimited text content to convert into a DataTable.

Column Separators#

ColumnSeparators · String · Optional · Default: ,

The delimiter used to separate column values (e.g. ',' or ' ').

New Line Separator#

NewLineSeparator · String · Optional · Default: Not specified in package metadata

The line separator. Defaults to standard newline.

Has Headers#

HasHeaders · Boolean · Optional · Default: True

Specifies whether the first non-empty line contains column names.

CSV Parsing#

CsvParsing · Boolean? · Optional · Default: True

Honour double quotes: a quoted value may contain the separator, and "" is one quote. Off splits on every separator.

Auto Detect Types#

AutoDetectTypes · Boolean · Optional · Default: False

Give a column Int32, Int64, Decimal, Boolean or DateTime when every value in it parses as that type (invariant culture); otherwise String.

Use Row Header#

UseRowHeader · Boolean · Optional · Default: False

The first column holds row labels: it is kept as String and left out of type detection.

Ignore First Column#

IgnoreFirstColumn · Boolean · Optional · Default: False

Leave the first column of the text out of the table.

Column Sizes#

ColumnSizes · Int32[] · Optional · Default: Not specified in package metadata

Fixed-width text: each column's width in characters, e.g. new[] { 10, 8, 12 }. Set, it replaces Column Separators; the last column takes the rest of the line.

Output#

Data Table#

DataTable · DataTable · Output

The created DataTable.

Retry and risk#

This activity is safe to retry: running it again after a transient failure does not repeat a side effect. If a run is interrupted and the outcome of a step is unknown, the step is never retried automatically (what to do). How activities declare this: characteristics, retries and risk.

Every activity also has the engine's common properties: Timeout and Continue On Error.

Related activities#

• Add Data Column
• Add Data Row
• Build Data Table
• Clear Data Table
• Filter Data Table
• Get Row Item
• Join Data Tables
• Lookup Data Table

Generated from VeloPhex.System.Activities 0.7.1-rc.12. Category: Data Table. Keywords: datatable, csv, parse, import, text, generate, fixed width.

Properties

Input

Output

Retry and risk

Related activities