This chapter describes how to configure the AWK parser.

  • You are in the File Connector user interface.
  • The Parsers page is open.
  1. Select New Configuration > AWK Parser Configuration.
  1. In the New parser configuration dialog, fill in the following fields:
  • Enter a unique Configuration Name.
  • Enter a Description.
  • Enter the Program you have created for your parser.
  • Enter the Extension for the AWK file output.
  1. Select Save.
  1. (Optional) To test the parser, select Parser Test or manually select of a file to parse.
  • Files that were successfully processed are displayed in Directory page.

Example for a parsing program

Example of a CSV file to be imported:

In this example file, the Name has position 1, the Date and Time position 2 and the Value positon 3.

To parse this file, the following code can be used:

{ print $1, ptime('02.01.2006 15:04:05', $2), $3 }

The File Connector's AWK parser has a built-in helper function for the time stamps. This way, For more information, see Troubleshooting.