如何替换json字符串中的caharacters [英] How to replace caharacters in json string
本文介绍了如何替换json字符串中的caharacters的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我输出的字符串为:
[{Skey:5689245,Name:test19MAY90,PhoneNo:458652864 , 电子邮件: test@gmail.com, ProfilePic: , 地址: VASHI, 城市: 妈妈, 国家: 马哈拉施特拉邦, UserArea:空,AreaId:null,Landmark:near station,Latitude:0.000000000,Longitude:0.000000000,Addressid:23}]
i想要以下格式输出
{Skey:5689245,名称: test19MAY90, PHONENO: 458652864, 电子邮件: test@gmail.com, ProfilePic: , 地址: VASHI, 城市: 妈妈, 国家 :Maharashtra,UserArea:null,AreaId:null,Landmark:near station,Latitude:0.000000000,Longitude:0.000000000,Addressid:23}
我的尝试:
if (ds.Tables [ 0 ]!= null && ds.Tables [ 0 ]。Rows.Count > 0 )
{
DataTable dt = ds.Tables [ 0 跨度>];
// jSonString = ConvertDataTableTojSonString(dt);
// jSonString.Replace([,);
List< dictionary>< string,> ;> tableRows = new List< dictionary>< string,>>();
字典<字符串,> 行;
foreach (DataRow dr in dt.Rows)
{
row = new 字典<字符串,> ();
foreach (DataColumn col in dt.Columns)
{
row.Add(col.ColumnName,dr [col]);
}
tableRows.Add(row);
}
str = serializer.Serialize(tableRows);
// str = str.Replace([,string.Empty);
str = Regex.Replace(str, [[]], );
// return serializer.Serialize(str);
解决方案
您不需要正则表达式来从字符串
中删除标题和尾随字符,只需使用 String.Substring Method(System) [ ^ ]。
string json = [{\Skey \:\5689245 \,\Name \:\test19MAY90 \ \ PhoneNo\:\ 458652864\,\ Email\:\ test@gmail.com\,\ ProfilePic\:\ \\ \\ \ Address\:\ VASHI \\ \ City\:\ mum\,\ State\:\ Maharashtra\,\ UserArea\:空,\ AreaId\\ \\:null,\Landmark \:\near station \,\Latitude \:0.000000000,\Longitude \:0.000000000,\Addressid \: 23}]跨度>;
json = json.TrimStart( new char [] {' ['})。TrimEnd( new char [] {' ]'});
I get output of string as:
[{"Skey":"5689245","Name":"test19MAY90","PhoneNo":"458652864","Email":"test@gmail.com","ProfilePic":"","Address":"VASHI","City":"mum","State":"Maharashtra","UserArea":null,"AreaId":null,"Landmark":"near station","Latitude":0.000000000,"Longitude":0.000000000,"Addressid":23}]
i want output in following format
{"Skey":"5689245","Name":"test19MAY90","PhoneNo":"458652864","Email":"test@gmail.com","ProfilePic":"","Address":"VASHI","City":"mum","State":"Maharashtra","UserArea":null,"AreaId":null,"Landmark":"near station","Latitude":0.000000000,"Longitude":0.000000000,"Addressid":23}
What I have tried:
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0];
//jSonString = ConvertDataTableTojSonString(dt);
//jSonString.Replace("[", "");
List<dictionary><string,>> tableRows = new List<dictionary><string,>>();
Dictionary<string,> row;
foreach (DataRow dr in dt.Rows)
{
row = new Dictionary<string,>();
foreach (DataColumn col in dt.Columns)
{
row.Add(col.ColumnName, dr[col]);
}
tableRows.Add(row);
}
str = serializer.Serialize(tableRows);
//str = str.Replace("[", string.Empty);
str = Regex.Replace(str, "[[]]", " ");
//return serializer.Serialize(str);
解决方案
You don't need a regular expression in order to remove the heading and trailing characters from a string
, just use the String.Substring Method (System)[^].
string json = "[{\"Skey\":\"5689245\",\"Name\":\"test19MAY90\",\"PhoneNo\":\"458652864\",\"Email\":\"test@gmail.com\",\"ProfilePic\":\"\",\"Address\":\"VASHI\",\"City\":\"mum\",\"State\":\"Maharashtra\",\"UserArea\":null,\"AreaId\":null,\"Landmark\":\"near station\",\"Latitude\":0.000000000,\"Longitude\":0.000000000,\"Addressid\":23}]"; json = json.TrimStart(new char[] { '[' }).TrimEnd(new char[] { ']' });
这篇关于如何替换json字符串中的caharacters的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文