OMrun Help Online Manual for OMrun Version 4

CSV Converter

Plug-in to convert any flat file into comma separated values file (CSV) within OMrun.

Input - Execution parameters to invoke a conversion:


Field "@param1" (Input file) [mandatory]

  • Description: Source location incl. file name + extension
  • Syntax: <full path>\<file name>.<ext>
  • Example: @TestData\Flatfile.txt

Field "@param2" (Output path + file) [mandatory]

  • Description: Target location of converted file incl. file name + extension
  • Syntax: <full path>\<file name>.<ext>
  • Example: @TestData\Converted.csv

Field "@param3" (2 Delimiter character/s) [1 mandatory]

  • Description: Delimiter before/after conversion without any space (delimiter will not change if one is applied only)
  • Syntax: <1 or 2 delimiters>
  • Example: |; [delimiter before conversion = | and after conversion = ;]

Field "@param4" (Additional character before and after any value) [optional]

  • Description: additional character around any value after conversion (needed in special cases to keep leading/trailing spaces)
  • Syntax: <character>
  • Example: @

Output
The converted file contains the same content but with replaced delimiters and double quotes before and after each value ["value"].
Output format of the CSV file will be ANSI by default. Different formats could be set in config file (admin rights needed):
C:\Program Files\OMIS\OMrun\BuiltInTests\OMrunPlugIn_CsvConverter.exe.config