Skip to content
background-image background-image

csv_parser

CSV serializer

  • Version

    3.3

  • Agent restriction

    None

  • Processing type

    Row by row

  • Multi-input step

    Not Supported

Configuration

CSV format configuration

Column separator

Columns separator dividing data of single columns. Currently available separators:

  • Comma ,

  • Semicolon ;

If the parsed text is using another separator to divide data, consider using any of the available data manipulation connectors to replace the dividers before the parsing step.

CSV header

Check this box, if the first row of the file contains the header (information about the column names). If you fail to check the box, the headers will be considered as part of the data.

CSV parser CSV format

Date and number format

Date and number format

Select the appropriate input date and number format from the list or use the option to define your custom format.

Available date and number formats:

Invariant

Pattern type Pattern Example
LongDatePattern "dddd, MMMM d, yyyy" "Tuesday, July 10, 2023"
ShortDatePattern "M/d/yyyy" "7/10/2023"
LongTimePattern "h:mm:ss tt" "4:30:15 PM"
ShortTimePattern "h:mm tt" "4:30 PM"
NumberFormatPattern "#,0.###" "1,234.567"

Please note that the invariant culture is a culture-independent representation that does not vary with the specific culture settings. Therefore, the patterns and examples provided for the invariant culture will be consistent across different cultures and can be used as a standard format.

Czech republic cs-CZ

Pattern type Pattern Example
LongDatePattern "dddd d. MMMM yyyy" "úterý 10. července 2023"
ShortDatePattern "dd.MM.yyyy" "10.07.2023"
LongTimePattern "H:mm:ss" "16:30:15"
ShortTimePattern "H:mm" "16:30"
NumberFormatPattern "0,0.###" "1 234,567"

German (Germany) de-DE

Pattern type Pattern Example
LongDatePattern "dddd d. MMMM yyyy" "Dienstag, 10. Juli 2023"
ShortDatePattern "dd.MM.yyyy" "10.07.2023"
LongTimePattern "H:mm:ss" "16:30:15"
ShortTimePattern "H:mm" "16:30"
NumberFormatPattern "0,0.###" "1.234,567"

English (United States) en-US

Pattern type Pattern Example
LongDatePattern "dddd, MMMM d, yyyy" "Tuesday, July 10, 2023"
ShortDatePattern "M/d/yyyy" "7/10/2023"
LongTimePattern "h:mm:ss tt" "4:30:15 PM"
ShortTimePattern "h:mm tt" "4:30 PM"
NumberFormatPattern "#,0.###" "1,234.567"

Custom - If custom is used, make sure the section Decimal separator and the DateTime format are filled.

CSV parser Date Number Format

Decimal separator

Select the decimal separator:

  • Decimal Point (e.g. 3.14)

  • Decimal Comma (e.g. 3,14)

DateTime format

Specify the date time format. Follow the C## conventions (case sensitive). The default value is set to: yyyy-MM-dd.

Input & Output Schema

Input

Data schema is mandatory

The connector requires mandatory input or output data schema, which must be selected by the user from the existing data schema repository or a new one must be created. The connector will fail without structured data.

Output

Text (ver. 1.0.0)

Column Data type Allow null Description
Text String No Converted plain text.

Release notes

3.3.1

  • Plugin binaries update as a result of included connector change.

3.3.0

  • Fixed Date and number format configuration title.

3.2.1

  • Fixed shared nuget package versions.