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.
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.
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.