# CSV Converter

### ![](https://1143774439-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1ooXfQ2qWGFRh6lihybt%2Fuploads%2Fgit-blob-b1ff09efdc12bf5f66706c589ab22a99da1cb7dd%2FIcon_TOB_program.gif?alt=media)

### Abstract

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\dbi\OMrun\BuiltInTests\OMrunPlugIn_CsvConverter.exe.config`