Delimited Text Translation

Text

GoAnywhere MFT can read and write common data exchange formats like delimited text files. Most column delimiters are supported including commas (e.g. CSV files), tabs, colons, semicolons, tilde and vertical pipes.

Reading Delimited Text

Text

The data read in from delimited text files can be used to insert into database tables, translated into other file formats like Excelfixed-widthXML, and more. GoAnywhere MFT can read a delimited text file 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

 

Image
Delimited Read
Delimited Read

Writing Delimited Text

Text

GoAnywhere MFT can create delimited text files using data extracted from databases or other files including Excelfixed-width, and XML. The following user-specified options are available when generating a delimited text file:

  • 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
  • Append to the end of existing text files
  • Replace existing text files
  • Pass in variables (at runtime) to override attributes

 

Image
delimited write
Delimited Write

 

Text

After a delimited text file is generated, GoAnywhere MFT can compress or encrypt the output file and store it on the network or distribute the file to a remote server.

 

Request a quote to automatically read and write delimited text files using GoAnywhere MFT.