txt file with comma dimmiter to database

Question

Hi

I am new to c# asp.net

I have a txt file with data

"first","second","third","fourth"

"first","second","third,hai","fourth"

"first","second","third","fourth"

which is a csv file i need to fetch the string from this file and store in database.

You can notice that there is double qoutes and comma and another thing is in 2nd row third column there is a comma in between the whole string .

please help with this.

thanks in advance

Hemant Srivastava · Answer

Could you try the following code it's grabbing words as below: private List ParseCSVFile(string fileNameWithPath) { List listOfWords = new List (); try { string line; char[] splitByCharSet = new char[1] { '\' }; using (StreamReader reader = new StreamReader(fileNameWithPath)) { while ((line = reader.ReadLine()) != null) { string[] items; //Parsing by firstly double quote character items = line.Trim().Split(splitByCharSet StringSplitOptions.RemoveEmptyEntries); if (items.Length != 0) { foreach (string s in items) { // Then filtering out standalone comma character and pushing all valid words into a List if (s != ) { listOfWords.Add(s); } } } } } } catch (Exception exc) { throw exc; } return listOfWords; } ____________________ OUTPUT: ____________________ first second third fourth first second thirdhai fourth first second third fourth first second third fourth

Vulpes · Answer

The following code gets rid of the double quotes and replaces the comma separator with a vertical bar '|': using System; using System.IO; class Program { static void Main() { string[] lines = File.ReadAllLines(kk.csv); for(int i = 0; i { string[] items = lines[i].Split(new string[]{\} StringSplitOptions.None); for(int j = 0; j { items[j] = items[j].Trim('\'); } lines[i] = String.Join(| items); Console.WriteLine(lines[i]); } Console.ReadKey(); } } The output is: first|second|third|fourth first|second|thirdhai|fourth first|second|third|fourth first|second|third|fourth

krishnakumar kuna · Answer

well no actually i need coding to load file path and from the path i need the string values which need to be inserted in to database.My doubt is how the string will be stored in array line by line or whole lines and insert those array vaues in to database. thanks in advance

Hemant Srivastava · Answer

If your problem is solved could you mark the answer as accepted answer?

krishnakumar kuna · Answer

thanks for the answer

krishnakumar kuna · Answer

thanks for the answer