Data source is a Text File

The Reader is capable of extracting data from delimited or fixed width files. All parameters are user definable. It can also skip a number of Header and Footer lines

The Text tab defines the format of the source text file.

The Data Reading Restriction tab can be used to speed up testing while working with a very large file or table.

The Rejected records file can have a pre-defined format. The Rejected File tab allows the user to set this up.

One of the useful features of the Advanced ETL Processor is the ability to view the resultant data prior, or subsequently processed. The data view looks like a spreadsheet view as follows:

The data view toolbar allows you to change various aspects of the data view, such as refreshing data as it changes and setting properties for how the data will look. You can also switch between viewing of the data and checking to see how the data is defined i.e. the data dictionary, via the “Switch to Data Definition View”.

  1. Reader Properties
  2. Refresh Data
  3. Edit file in an external editor
  4. Swap Reader and Writer
  5. Add a new column
  6. Delete the last column
  7. Switch to Data View
  8. Switch to Data Definition View
Note: You may rename fields and change field’s width here. (Works only for text files)

Within the Data Definition view, you can perform a number of actions. These allow you to change how you want data to be represented in the data view screens. The navigation also allows switching between views.

  1. Reader Properties
  2. Refresh Data
  3. Print Data Definition
  4. Print Preview Data Definition
  5. Find
  6. Edit file in an external editor
  7. Add a new column
  8. Delete the last column
  9. Switch to Data View
  10. Switch to Data Definition View

 Set Field’s Names takes field’s names from certain file line. 
 
 It is also possible to copy and paste fields from excel 
 

Video Tutorials

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL Forum

  • aetl/processing_data/reader/text.txt
  • Last modified: 18/06/2015 12:04
  • by admin