How to convert csv to json in C# while csv column have multiple comma seperator?

Question

1.00/5 (1 vote)

See more:

I have one csv file and I need to convert that data into json format in json. I tried to read file and get data and split by comma (,) seperator. And then convert that data into json format. But the result is not expected result. Because come column values have multiple (,) seperator.

Any one can help me to solve this issue ?

Coming Result was : [["JOB ID","JOB NAME","ROLE DESCRIPTION/EXPECTATION","RESPONSIBILITIES","PREFERRED SKILLS PROFILE","JOB LOCATION","JOB START DATE","JOB STATUS","JOB OPEN DATE","ENGAGEMENT TYPE","FIXED PRICE (Y/N)","MILESTONE (Y/N)","HOURLY PAY (Y/N)","BUDGET CURRENCY (CURRENCY CODE)","BUDGET AMOUNT (NUMBER ONLY)","BILL CURRENCY (CURRENCY CODE)","BILL AMOUNT (NUMBERS ONLY)","TARGET SALARY CURRENCY (CURRENCY CODE)","TARGET SALARY AMOUNT (NUMBERS ONLY)","EDUCATION NAME","CERTIFICATION/LICENSURE","HIRING MANAGER","TALENT ADVISER","JOB CLUSTER KEYWORDS","CONTRACT TIME"],["","Operations Support Administrator","\"The Human Resources Operations Support Administrator is a critical member of the Human Resources team that serves approximately 62 schools and 5 administrative organizational units. The Operations Support Administrator will provide specialized"," technical support in one or more operational areas. The Operations Support Administrator will likely provide payroll and procurement support"," but will also provide support in one or more of the following operational areas: budgeting"," grants management"," contracts"," human resources"," technology"," school food"," transportation"," and/or health. The Operations Support Administrator�s specialty may vary from team to team and will depend on their prior experience.\"","\"Support a network of schools to continuously improve operations"," school support"," and customer service. Provide technical support and assistance related to assigned operational area(s). Manage systems associated with assigned operational area(s) and provide technical support to school-based staff as necessary. Collect and interpret test scores and other school performance data to help schools drive student achievement. Facilitate the preparation of statistical and narrative reports and/or visual presentations such as charts or graphs"," as appropriate. "],["Provide transactional oversight and support related to assigned operational area(s). Advocate/liaise with the district team"," the Human Resources team and central entities when necessary to ensure operational transactions are executed to meet compliance mandates and schools� satisfaction."],["Identify areas in which schools are in need of administrative and/or operational training and ensure that training opportunities are provided to each school."],["Provide guidance and resources to school-based personnel to increase the operational/administrative capacity and autonomy of each school. This includes frequent school visits to trouble-shoot and provide one-on-one support as necessary."],["Support Human Resources� service-oriented culture"," which is designed to attain high levels of principal satisfaction with the services and support the district provides."],["Provide critical"," technical operational information as available from Human Resources"," including central policy and process updates and changes."],["\"","\"Communcation Skills"," Attention to Detail"," DOE Systems"," Planning skills\"","\"New York"," New York"," USA\"","11-01-2017","OPEN","10-01-2017","CONTRACT","","","","USD","45000","USD","45000","USD","","Bachelor Degree","NYC Civil Service Status","John Jones","Carolina Smith","","6 months"]]

Expected Result is : [ { "JOB ID": "", "JOB NAME": "Operations Support Administrator", "ROLE DESCRIPTION/EXPECTATION": "The Human Resources Operations Support Administrator is a critical member of the Human Resources team that serves approximately 62 schools and 5 administrative organizational units. The Operations Support Administrator will provide specialized, technical support in one or more operational areas. The Operations Support Administrator will likely provide payroll and procurement support, but will also provide support in one or more of the following operational areas: budgeting, grants management, contracts, human resources, technology, school food, transportation, and/or health. The Operations Support Administrator�s specialty may vary from team to team and will depend on their prior experience.", "RESPONSIBILITIES": "Support a network of schools to continuously improve operations, school support, and customer service. Provide technical support and assistance related to assigned operational area(s). Manage systems associated with assigned operational area(s) and provide technical support to school-based staff as necessary. Collect and interpret test scores and other school performance data to help schools drive student achievement. Facilitate the preparation of statistical and narrative reports and/or visual presentations such as charts or graphs, as appropriate. \nProvide transactional oversight and support related to assigned operational area(s). Advocate/liaise with the district team, the Human Resources team and central entities when necessary to ensure operational transactions are executed to meet compliance mandates and schools� satisfaction.\nIdentify areas in which schools are in need of administrative and/or operational training and ensure that training opportunities are provided to each school.\nProvide guidance and resources to school-based personnel to increase the operational/administrative capacity and autonomy of each school. This includes frequent school visits to trouble-shoot and provide one-on-one support as necessary.\nSupport Human Resources� service-oriented culture, which is designed to attain high levels of principal satisfaction with the services and support the district provides.\nProvide critical, technical operational information as available from Human Resources, including central policy and process updates and changes.", "PREFERRED SKILLS PROFILE": "Communcation Skills, Attention to Detail, DOE Systems, Planning skills", "JOB LOCATION": "New York, New York, USA", "JOB START DATE": "11-01-2017", "JOB STATUS": "OPEN", "JOB OPEN DATE": "10-01-2017", "ENGAGEMENT TYPE": "CONTRACT", "FIXED PRICE (Y/N)": "", "MILESTONE (Y/N)": "", "HOURLY PAY (Y/N)": "", "BUDGET CURRENCY (CURRENCY CODE)": "USD", "BUDGET AMOUNT (NUMBER ONLY)": 45000, "BILL CURRENCY (CURRENCY CODE)": "USD", "BILL AMOUNT (NUMBERS ONLY)": 45000, "TARGET SALARY CURRENCY (CURRENCY CODE)": "USD", "TARGET SALARY AMOUNT (NUMBERS ONLY)": "", "EDUCATION NAME": "Bachelor Degree", "CERTIFICATION/LICENSURE": "NYC Civil Service Status", "HIRING MANAGER": "John Jones", "TALENT ADVISER": "Carolina Smith", "JOB CLUSTER KEYWORDS": "", "CONTRACT TIME": "6 months" } ]

c#

What I have tried:

My code is below:

`string targetFile = @"C:\Users\grajaji\Desktop\target.csv";
var csv = new List(); var lines = System.IO.File.ReadAllLines(targetFile);enter code here

foreach (string line in lines) csv.Add(line.Split(','));

var json = JsonConvert.SerializeObject(csv);

return Request.CreateResponse(HttpStatusCode.OK, json);`

Posted 9-Nov-17 0:50am

Member 12045869

Updated 6-Feb-19 0:49am

CHill60

Add a Solution

Comments

Richard MacCutchan 9-Nov-17 7:22am

Please edit your question and remove all that unformatted text dump. Just show enough information (properly formatted within <pre> tags) and explain what the problem is in converting.

Mehdi Gholam 9-Nov-17 7:31am

Your data is in JSON format not csv, so just read it with a json reader.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

pvsvprasad · Answer 1 · 2017-11-09T02:02:00

C#

public void Convert2Json() 
{ 
    try 
    { 
        if (FileUpload1.PostedFile.FileName != string.Empty) 
        { 
            string[] FileExt = FileUpload1.FileName.Split('.'); 
            string FileEx = FileExt[FileExt.Length - 1]; 
            if (FileEx.ToLower() == "csv") 
            { 
                string SourcePath = Server.MapPath("Resources//"
                                                   + FileUpload1.FileName); 
                FileUpload1.SaveAs(SourcePath); 
                string Destpath = (Server.MapPath("Resources//" + FileExt[0]
                                                  + ".json")); 

                StreamWriter sw = new StreamWriter(Destpath); 
                var csv = new List<string[]>(); 
                var lines = System.IO.File.ReadAllLines(SourcePath); 
                foreach (string line in lines) 
                    csv.Add(line.Split(',')); 
                string json = new System.Web.Script.Serialization
                                       .JavaScriptSerializer().Serialize(csv); 
                sw.Write(json); 
                sw.Close(); 
                TextBox1.Text = Destpath; 
                MessageBox.Show("File is converted to json."); 
            } 
            else 
            { 
                MessageBox.Show("Invalid File"); 
            } 

        } 
        else 
        { 
            MessageBox.Show("File Not Found."); 
        } 
    } 
    catch (Exception ex) 
    { 
        MessageBox.Show(ex.Message); 
    } 
}