Download PDF - RJS Support Center

Chapter 4: Fitting DataImport to Your Needs
40
Input and Output......................................................................................................................40
Input Files .................................................................................................................41
Output Files...............................................................................................................43
Cleaning-Up Input Files ..........................................................................................................45
Special Characters.....................................................................................................45
Blank Lines ...............................................................................................................45
Page Ejects................................................................................................................45
Duplicate Lines .........................................................................................................46
Extracting Data........................................................................................................................46
Columnar Data ..........................................................................................................46
Default Line Treatment .............................................................................................52
Titles and Headings...................................................................................................52
Reorganizing Data...................................................................................................................52
Resequencing Data Columns.....................................................................................53
Unstacking Multiple Lines of Data ...........................................................................53
Getting Data from Multiple Lines into the Same Cell...............................................55
Pulling Data out of Page and Section Headings........................................................55
Extracting Data from Forms......................................................................................58
Filling Blank Column Cells.......................................................................................60
Transpose Rows and Columns ..................................................................................61
Recognizing Data Types and Formats.....................................................................................61
Numeric ....................................................................................................................62
Text ...........................................................................................................................63
Date...........................................................................................................................64
Time of Day ..............................................................................................................65
Name Parse ...............................................................................................................65
Address Parse............................................................................................................65
Signed Overpunch Numbers .....................................................................................65
Code Page Settings ...................................................................................................66
Performing Calculations..........................................................................................................67
Formulas in Columns ................................................................................................67
Inserting Formula Rows ............................................................................................67
Working with Database Files ..................................................................................................69
Chapter 5: DataImport Mask Reference
72
DataImport Mask.....................................................................................................................72
File ............................................................................................................................72
Search .......................................................................................................................77
Column......................................................................................................................79
Tag ............................................................................................................................84
Include ......................................................................................................................87
Exclude .....................................................................................................................90
Line ...........................................................................................................................95
Unstack .....................................................................................................................98
Options....................................................................................................................100
DataImport
Contents • 4