Parse
Frends Task for parsing CSV string.
Task version: 1.6.0
Required Frends version: 5.5+
Required .NET version: 6.0
Compatible Agents: Crossplatform
Source code: https://github.com/FrendsPlatform/Frends.CSV2/tree/main/Frends.CSV.Parse
Task Parameters
Csv : String
Input csv string
Default: -
Example: 1;Foo;Bar
Delimiter : String
Delimiter.
Default: ;
Example: ;
ColumnSpecifications : ColumnSpecification[]
You can map columns to specific types.
The order of the columns are used for mapping, that means that the ColumnSpecification elements need to be created in the same order as the CSV fields.
Default: -
Example: [ foo, String ]
ContainsHeaderRow : Boolean
This flag tells the reader if there is a header row in the CSV string.
Default: true
Example: true
TrimOutput : Boolean
This flag tells the reader to trim whitespace from the beginning and ending of the field value when reading.
Default: true
Example: true
SkipRowsFromTop : Int32
If the CSV string contains metadata before the header row you can set this value to ignore a specific amount of rows from the beginning of the csv string.
Default: -
Example: 2
SkipEmptyRows : Boolean
A flag to let the reader know if a record should be skipped when reading if it's empty.
A record is considered empty if all fields are empty.
Default: true
Example: true
ReplaceHeaderWhitespaceWith : String
If intended header value contains whitespaces replace it(them) with this string, default action is to do nothing.
Default:
Example: " "
CultureInfo : String
The culture info to read/write the entries with, e.g. for decimal separators.
InvariantCulture will be used by default.
See list of cultures here: https://learn.microsoft.com/en-us/dotnet/api/system.globalization.cultureinfo.name?view=net-7.0
NOTE: Due to an issue with the CsvHelpers library, all CSV tasks will use the culture info setting of the first CSV task in the process; you cannot use different cultures for reading and parsing CSV files in the same process.|
Default: -
Example: fi-FI
TreatMissingFieldsAsNulls : Boolean
The flag for reader to treat missing fields as nulls instead of throwing a MissingFieldException.
In case of providing column specifications manually the value of empty field defined as string will be empty instead of null
Default: false
Example: false
IgnoreQuotes : Boolean
A flag to let the reader know if quotes should be ignored.
Default: false
Example: false
Task Result
Success : Boolean
Operation complete without errors.
Example: true
Data : List<List1>`
Processed data.
Example: { {foo, bar}, {bar, foo} }
Headers : List<String>
Headers.
Example: { foos, bars }
ConfigurationCultureInfo : String
The culture info used to read/write the entries.
Example: fi-FI
Task Changelog
Changelog for Task Frends.CSV.Parse.
[1.6.0] - 2026-01-21
Changed
Removed XML and JSON outputs; the task now returns only an object as intended; use ConvertToJSON and ConvertToXML tasks if needed.
[1.5.0] - 2025-12-05
Changed
Update package CsvHelper to version 33.1.0.
[1.4.0] - 2025-10-08
Added
Added option to ignore quotes
[1.3.0] - 2024-08-20
Added
Updated NewtonSoft.Json to the latest version 13.0.3.
[1.2.1] - 2023-12-20
Fixed
Empty and whitespace header values are now replaced if ReplaceHeaderWhitespaceWith is used.
[1.2.0] - 2023-12-20
Changed
Type of Xml-property of Result-object changed from object to string.
Fixed
Task now produces valid XML in case no header row is provided in input CSV string.
[1.1.2] - 2023-11-28
Fixed
Fixed documentational issues and changed Jtoken result object type to dynamic.
[1.1.1] - 2023-11-23
Fixed
Fixed issue with inverted Trim option by inverting the if statement.
[1.1.0] - 2023-07-31
Added
Implements option for treating missing fields as null when parsing the CSV content
[1.0.0] - 2023-02-10
Added
Initial implementation
Last updated
Was this helpful?