Chapter 6. Text DataSource

Table of Contents

Overview
Text DataSource Wizard
Working with Text DataSource
Using Separator Characters
Defining a URL with a Dynamic Parameter
Using Fixed Width Columns
Using Regular Expressions
Using Start and Stop Expressions

Overview

In Elixir Data Designer the data from a text file can be accessed using the Text DataSource.

The tool provides encoding support, which includes multi-lingual formats, so text data sources which are encoded in different formats can be added. Also, text data sources with fields having different date, time and timestamp formats can be added.

A Text DataSource can be created simply by right-clicking on an CSV file on the repository and select “Define as a Text DataSource”.

In addition to straightforward field-based access, regular expressions are supported to give power users very flexible filtering and extraction options.