Delimited Text Read

GoAnywhere Director™ can read data from delimited text files (e.g. CSV files) using a variety of user-specified options:
  • Include/exclude column headings
  • Field delimiters (commas, tabs, pipes, etc.)
  • Record delimiters (CR, LF, CR/LF, LF/CR)
  • Formatting options for dates and numbers
  • Text qualifiers
  • Null substitute values
  • Pass in variables (at runtime) to override attributes
The data read from delimited text files can be imported into database tables. Delimited text files can also be translated into other formats including Excel, fixed-width text and XML formats.
 
Delimited Read

GoAnywhere Director can be installed onto Windows, VMware, Linux, IBM i, AIX (pSeries), UNIX, HP-UX, Mac OS and Solaris platforms.  IBM i is also referred to as System i, iSeries, as400, as/400 and i5.