Parse and write separated-value files in .NET using the Sep library.
npx skills add https://github.com/zhenpengLai/myuseskill --skill dotnet-sep-zhenpenglai
Please help me install this Agent Skill. Skill: dotnet-sep Source: https://github.com/zhenpengLai/myuseskill/tree/main/dotnet-sep Command: npx skills add https://github.com/zhenpengLai/myuseskill --skill dotnet-sep-zhenpenglai
Sep.Reader, access columns as ReadOnlySpan<char>, and convert values with Parse<T> only when needed. - Controlled writing: Generate output with SepWriterOptions, round-trip input specs via reader.Spec.Writer(), and control header, escaping, and column-count behavior. - Async and parallel workflows: Use async readers/writers on .NET 9+ and apply ParallelEnumerate for CPU-heavy transformations after benchmarking. - Use Case: An ETL pipeline reads a large CSV file, transforms numeric columns, and writes normalized output while preserving the original separator and culture settings. ## Quick Start Ask the AI to add the Sep NuGet package to your .NET project and write code that reads a CSV file with Sep and writes the transformed rows to a new file.High-intent search queries and answers about installing and using this skill.
Install the Sep NuGet package, then create a reader with Sep.Reader() and call FromFile or FromText. Iterate rows with foreach and access columns by name with row["ColName"] or by index, using Parse<T> for typed values.
Create a writer with Sep.Writer(...) or reuse input settings via reader.Spec.Writer(), then call ToFile or ToText. For each input row, call writer.NewRow(row) and set or format column values before the row is disposed.
Sep focuses on zero-allocation, span-based parsing for performance-sensitive workloads, while CsvHelper offers a more conventional object-mapping model. Sep is frequently benchmarked against CsvHelper and suits high-throughput pipelines rather than drop-in replacement scenarios.
Yes, Sep provides async APIs such as FromTextAsync and await foreach over reader rows. Async row iteration requires C# 13 and .NET 9 or later, and writers support await using for asynchronous disposal.
SepReader.Row and SepWriter.Row are ref structs, so they cannot be stored beyond their immediate scope or used in async buffering patterns. Materialize values with ToString or Parse<T> if you need random access or LINQ-style collection behavior.
AbdullahmohammadarefParses, transforms, and analyzes CSV data from diverse sources with varied delimiters and encodings.
vctplatformDesign and implement data pipelines and reporting for the VCT Platform.
profmikegreeneEnforce data quality rules on pilot data streams and repositories.
rudironsoniGuide .NET type design decisions for struct versus class performance.