C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
11,427 questions
What's the best way to parse a csv file and create entries in a webapi project?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 14.000000000000002%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
titariko
1
Reputation point
I have a csv file with hundreds of rows with 5 columns. Ofc the 1st row consists of the column names while the rest of the rows are the data.
What is the best way to parse and create entries while at the same time excluding some of the data if they don't meet a certain condition?
Thank you
C#
{count} votes
-
AgaveJoe 30,031 Reputation points2021-06-19T18:07:33.99+00:00 NuGet has CSV parsers. The official docs cover reading a text file and looping over each line. Split the line by the comma and apply whatever validation logic you require.
-
titariko 1 Reputation point
2021-06-19T19:13:26.97+00:00 ok thanks, but where should the code for the parsing be written exactly?
-
AgaveJoe 30,031 Reputation points
2021-06-19T22:24:01.103+00:00 In Web API custom code runs within an action invoked from an HTTP method (GET POST etc) Typically, the parsing logic exists in a class or library. The Web API action calls the class or library to perform the task. I think you'll be interested in going through a few Getting Started tutorials found on this site.
https://learn.microsoft.com/en-us/aspnet/core/tutorials/first-web-api?view=aspnetcore-5.0&tabs=visual-studio
https://learn.microsoft.com/en-us/aspnet/core/web-api/?view=aspnetcore-5.0 -
titariko 1 Reputation point
2021-06-20T21:50:37.927+00:00 alright thanks
Sign in to comment
Sign in to answer