Liza
Liza

Reputation: 43

How to parse CSV into JSON while 'Amount' column containing commas

        //Convert CSV file to JSON
        var csv = new List<string[]>();
        var lines = csvResponseData.Split('\n');

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

        var properties = lines[0].Split(',');

        var listObjResult = new List<Dictionary<string, string>>();

        for (int i = 1; i < lines.Length; i++)
        {
            if (lines[i].Length > 5)
            {
                var objResult = new Dictionary<string, string>();
                for (int j = 0; j < properties.Length; j++)
                {
                    if (properties.Length > j && csv.Count > i && csv[i].Length > j)
                    {
                        objResult.Add(properties[j], csv[i][j].Trim('\\'));
                    }
                }
                listObjResult.Add(objResult);
            }
            else
            {
                break;
            }
        }
        return JsonConvert.SerializeObject(listObjResult);

textbox78,CompanyName,CompanyDiscretionaryData,CustomerName,NachaID,EEDOriginalTransaction,textbox46,EEDofReturn,textbox49,textbox21,textbox33,textbox67,textbox68,textbox69,textbox70,textbox71 Processing Date - 7/6/2022,AgencyInsTEST, ,AgencyIns ,1234 ,PPD,Credit,7/7/2022,Checking Account,$250.99,4,$600.99,4,"$2,651.98",8,"$3,252.97"

Upvotes: 0

Views: 90

Answers (0)

Related Questions