Skip to content

Instantly share code, notes, and snippets.

@Taifunov

Taifunov/StringCSVToJSON.cs

Created May 5, 2021 08:55
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Taifunov/9438bfb78819e61e48d21428ba604178 to your computer and use it in GitHub Desktop.
Save Taifunov/9438bfb78819e61e48d21428ba604178 to your computer and use it in GitHub Desktop.
Download ZIP
Serialization issues
Raw
StringCSVToJSON.cs
public static string StringCsvToJson()
{
var text = "\"ExecuteStatus\",\"ExecuteTime\",\"ExecuteMessege\",\"ExecuteEntityID\",\"Comment\",\"Disabled\",\"Hello\",\"ExecuteDetails\"\r\n\"0\",\"\",\"\",\"\",\"qwerty\",\"zxcvbn\",\"parameter\",\"\"\r\n\"0\",\"\",\"\",\"\",\"qwerty\",\"zxcvbn\",\"parameter\",\"\"\r\n\"0\",\"\",\"\",\"\",\"yuiop\",\"cvbnm\",\"parameter\",\"\"\r\n\"0\",\"\",\"\",\"\",\"qwerty\",\"zxcvbn\",\"parameter\",\"\"\r\n\"0\",\"\",\"\",\"\",\"yuiop\",\"cvbnm\",\"parameter\",\"\"\r\n\"0\",\"\",\"\",\"\",\"qwerty\",\"zxcvbn\",\"parameter\",\"\"\r\n\"0\",\"\",\"\",\"\",\"yuiop\",\"cvbnm\",\"parameter\",\"\"\r\n\"0\",\"\",\"\",\"\",\"qwerty\",\"zxcvbn\",\"parameter\",\"\"\r\n\"0\",\"\",\"\",\"\",\"yuiop\",\"cvbnm\",\"parameter\",\"\"\r\n\"0\",\"\",\"\",\"\",\"qwerty\",\"zxcvbn\",\"parameter\",\"\"\r\n\"0\",\"\",\"\",\"\",\"yuiop\",\"cvbnm\",\"parameter\",\"\"\r\n\"0\",\"\",\"\",\"\",\"summ test\",\"summ test\",\"parameter\",\"\"\r\n";
using var sr = new StringReader(text);
using var csv = new CsvReader(sr, CultureInfo.InvariantCulture);
csv.Configuration.BadDataFound = null;
csv.Configuration.Delimiter = ",";
csv.Configuration.IgnoreBlankLines = false;
csv.Configuration.IgnoreQuotes = false;
var records = csv.GetRecords<dynamic>();
var jsonText = JsonConvert.SerializeObject(records, Newtonsoft.Json.Formatting.None);
return jsonText;
}
Result:
[{"\"ExecuteStatus\"":"0","ExecuteTime":"","ExecuteMessege":"","ExecuteEntityID":"","Comment":"qwerty","Disabled":"zxcvbn","Hello":"parameter","ExecuteDetails":""},{"\"ExecuteStatus\"":"0","ExecuteTime":"","ExecuteMessege":"","ExecuteEntityID":"","Comment":"qwerty","Disabled":"zxcvbn","Hello":"parameter","ExecuteDetails":""},{"\"ExecuteStatus\"":"0","ExecuteTime":"","ExecuteMessege":"","ExecuteEntityID":"","Comment":"yuiop","Disabled":"cvbnm","Hello":"parameter","ExecuteDetails":""},{"\"ExecuteStatus\"":"0","ExecuteTime":"","ExecuteMessege":"","ExecuteEntityID":"","Comment":"qwerty","Disabled":"zxcvbn","Hello":"parameter","ExecuteDetails":""},{"\"ExecuteStatus\"":"0","ExecuteTime":"","ExecuteMessege":"","ExecuteEntityID":"","Comment":"yuiop","Disabled":"cvbnm","Hello":"parameter","ExecuteDetails":""},{"\"ExecuteStatus\"":"0","ExecuteTime":"","ExecuteMessege":"","ExecuteEntityID":"","Comment":"qwerty","Disabled":"zxcvbn","Hello":"parameter","ExecuteDetails":""},{"\"ExecuteStatus\"":"0","ExecuteTime":"","ExecuteMessege":"","ExecuteEntityID":"","Comment":"yuiop","Disabled":"cvbnm","Hello":"parameter","ExecuteDetails":""},{"\"ExecuteStatus\"":"0","ExecuteTime":"","ExecuteMessege":"","ExecuteEntityID":"","Comment":"qwerty","Disabled":"zxcvbn","Hello":"parameter","ExecuteDetails":""},{"\"ExecuteStatus\"":"0","ExecuteTime":"","ExecuteMessege":"","ExecuteEntityID":"","Comment":"yuiop","Disabled":"cvbnm","Hello":"parameter","ExecuteDetails":""},{"\"ExecuteStatus\"":"0","ExecuteTime":"","ExecuteMessege":"","ExecuteEntityID":"","Comment":"qwerty","Disabled":"zxcvbn","Hello":"parameter","ExecuteDetails":""},{"\"ExecuteStatus\"":"0","ExecuteTime":"","ExecuteMessege":"","ExecuteEntityID":"","Comment":"yuiop","Disabled":"cvbnm","Hello":"parameter","ExecuteDetails":""},{"\"ExecuteStatus\"":"0","ExecuteTime":"","ExecuteMessege":"","ExecuteEntityID":"","Comment":"summ test","Disabled":"summ test","Hello":"parameter","ExecuteDetails":""}]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment