We've now made an updated video that addresses some of your questions about handling semicolon delimiters and CSV files with no header row, check it out! kzfaq.info/get/bejne/nJuSrbGZnM66mJ8.html

Thank you so much sir! Finally understood how to use that lib! You're talented to teach us, clear didactic.

Hey, thanks for this video. It was really informative and helped me out/solved my issue where my csv had a mixture of comma only and comma with quoted data eg 22, 5 , "abc", 6 , "def" . Thanks Great video :)

This has been truly educational and useful. Thank you so much for sharing!

Keep making videos! As simple as CSV readers seem to be this concept has eluded me. Until now... You've got a new subscriber.

Great tutorial, thank you very much!

Thanks. Video was easy to understand and got me going.

The best I've seen! Just FLAWLESS! Thank you!

Brilliant. Thank you. Such a good teacher!!

This was way more concise than anything google threw at me! Thank you very much!

well done. delivered very clearly and easy to follow. cheers, mate!

This is so helpful many thanks mate!

Thank you very much for the tip, we from Brazil are grateful for your video.

great Tutorial!

thank you for the tutorial! it helps a lot.

This video helped me a lot! You've got a new subscriber.

Need to get this csv thing working !! Thanks

Loved one thanks.it very helpful for me

Thank you, very helpful video! Can you tell me what extension do you use to preview csv files in vscode?

wonderful video, Love from Pakistan !

Thanks for this good tutorial.

great quality!

Thank you for the clear explanation! Do you know how I can change the csv path to the downloads folder

Hi Robert, nice videos you have here. Im using CSVHelper and ran into a problem. How can I make it read a string like this (This "is" a string). CSVHelper is breaking when getting double quotes in a string and i can't even handle anything because im only passing the file path. Thanks

How can I deal with column name changes? If over time column names change and maybe their order. Or some are removed. Then I need some backwards compatibility between old reports in my app and new reports with the ever changing new format. When I download different formats that must map to the same class. 1. If the column header is dynamic in name then I can use regex. 2. If some columns are removed in the future I can use nullable properties.

I have files that header names are not consistent. Sometimes an extra '_' or year is added anywhere. PrepareHeaderForMatch = args => args.Header.Replace("_", " "), but it doesn't work. even if I just set the header value to lowercase and then when I read csv headers it still shows me the original column names of the file. Any idea what am doing wrong here ?

Great video. What if comma embedded in the one of the column.

Hi Roberts, I'm with a problem. I have a csv file with simple information, 1 column with a Name, 1 column with a Adress and 1 column with 1 ModbusFuction Name. I did like your tutorial, indeed I added the csv file to the directory of my visual studio project. I need to use this information forward in the project, so it's important to read correctly all the data so I can compare the names and adresses so I can do something, adding the information to a list is simple and effective, the problem is that one exception is launched when I run the program: "header with name 'Name'[0] was not found." .. I imagine that is because csv files begin in index 1 right ? Is there any command or solution so I can discard the reading of the index 0 ? Or some command that will start the reading at index 1 ? I was reading the documentation of the CsvHelper and I did not find any concrete solution. I thought that the Mapping solved this problem.

Hi Robert, This content is owesome. Thanks for your help. I have one query: Currently my import code using MemoryStream and this CsvReader, to import CSV file. It is fine for small size file but when it reaches 40 MB the application crashes. I m using blazor tech. Someone said that import it in small batches one by one. But I don't know how. Can u please help me.

Great tutorial! If I need some help with this, can I request your assistance?

Great video! Very direct to the point and easy to follow. Only one question: Is there a place where I can download this CSV file you're using? I cheked the description of the video and couldn't find it.

Hi my register is ;...;"name "mr" robot"; ...; double quote is erros. How do I adjust to not give an error with this double quote?

I love you

its showing error" You must call read on the reader before accessing its data." like this ,and which data type should i use i want to read the data that is in japanese language

This video helped me. I am learning C#. So as a project I have taken on to help me do this, I am trying to make an app that can take any datalog type CSV file, and plot the data on a livechart cartesian chart. But one thing i am trying to figure out, I want to be able to load any csv file with any number of columns. how can I create a dynamic class that can accommodate this?

I'm rather new to the .Net scene, so my question is a bit easy to resolve. - I was wondering if we can rely on a console app and insert it into an API to run the code while receiving requests from an online interface (or webpage). would that be possible?

Hi Robert, your video is informative. Can you please tell me which version of visual code you are using and what other dlls you installed and can I try with CSOM to update the records to sharepoint list. Your information is appreciated 😊

Great video, quick question, where can I find the CSV used for this example?, Rocket launches I think is called, sorry for the trouble, and keep up the good work!👍🏼

Great tutorial, thanks! Can you tell, please, how convert "$2.34" to "2.34"( cut currency sign)?

I've used powershell for years and im just now starting to try and learn other languages. It honestly baffles me how difficult it is to do such simple things like writing to a file or importing a csv. Powershell has cmdlets for everything and all the real complexities are abstracted away. I'm finding learning another language to be really difficult. Especially since i have no teacher and im just learning little bits and pieces from youtube and stackoverflow.

Robert, is there a way to work with positional data in text files instead of comma separators?

how do you do this with blazor 5.0 with file upload?

Peng music 👍🏻

HI! Great talk, BUT do you have the software someplace so I can download it? Trying to copy it while you talk is very hard. Thanks! JIM

How can you read csv with duplicate headers using dynamic class in

Hi, any idea how to handle this error when trying to add the CsvHelper package? error: There are no versions available for the package 'CsvHelper'. Using Visual Studio Code and SDK net5.0

what if you dont have column names . how will you determine headernames can u tell us little solution please. I believe it has something to do with CsvConfiguration but I am not sure

I cant make it work with a MemoryStream =( using (var MemoryStreamReader = new StreamReader(memoryStream, System.Text.Encoding.UTF8, true)) { var wholeText = MemoryStreamReader.ReadToEnd(); using (var csvReader = new CsvReader(MemoryStreamReader, CultureInfo.InvariantCulture)) { var records = csvReader.GetRecords().ToList(); _logger.LogInformation($"Finished downloading file [rom [{remoteFilePath}]"); } }

Hello Roberts Dev Talk, What if all of our fields of the CSV are separated by ";" how can we get rid of it to create the database? I mean something like id;contract;phoneNumber; ... and the data is 2;332321;7541233; ... P.S I really like the video.

Hey..can you suggest what will be the changes in code if my csv file have no header

Does anyone know how to skip headers? I have two headers that's causing issues with the CsVReader..

How to convert a CSV file into TXT file using c#.. Pls help

awesome video. Could you please try to convert csv files that have double quotes inside. Thanks