提取文本字符串问题? 格式如:a1|aa1|aaa1 a2|aa2|aaa2 a3|aa3|aaa3怎样才能把数据全部读出 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 stirng a = "a1|aa1|aaa1 a2|aa2|aaa2 a3|aa3|aaa3"string[] b = a.split("|") 用split(分隔符)分割字符串 提取如:a1 aa1 aaa1a2 aa2 aaa2 a3 aa3 aaa3存入数据库 看看这个帖 http://topic.csdn.net/u/20100929/10/08ebd68c-60a4-462d-b0c5-01b5726818fc.html?65542 你这样得 分割两次…… 一次 用空格分 一次用“|”分。分别存进DataTable或者数组 都行 string str = "a1|aa1|aaa1 a2|aa2|aaa2 a3|aa3|aaa3";StringBuilder sql = new StringBuilder();sql.Append("insert into tbA(col1, col2, col3) ");foreach(string s in str.Split(' ')){sql.AppendFormat("select '{0}', '{1}', '{2}' union ", s.Split('|'));}sql.Remove(sql.Length - 6, 6); string s = "a1|aa1|aaa1 a2|aa2|aaa2 a3|aa3|aaa3";var result = Regex.Matches(s, @"(\w+)(\d+)").Cast<Match>().OrderBy(m => m.Groups[2].Value).GroupBy(m => m.Groups[1].Value).ToList();foreach (var g in result){ foreach (var item in g) { Console.Write(item.Value + "\t"); } Console.WriteLine();}输出a1 a2 a3aa1 aa2 aa3aaa1 aaa2 aaa3 string str = "a1|aa1|aaa1 a2|aa2|aaa2 a3|aa3|aaa3"; string sql = string.Empty; string[] result = null; string[] aa = str.Split(' '); for( int i = 0; i < aa.Length; i++ ) { result= aa[i].Split('|'); sql = string.Format("insert into 表名 values('{0}','{1}','{2}')",result[0],result[1],result[2]); } foreach(string s in File.ReadAllLines("")){ foreach(string a in s.Split(' ')) {string[] arr=a.Split('|');}} string str = "a1|aa1|aaa1 a2|aa2|aaa2 a3|aa3|aaa3"; var item = str.Split(new char[] { ' ' }); foreach (var t in item) { foreach (var s in t.Split(new char[] { '|' })) { Console.Write(s+" "); } Console.WriteLine(); } string str = "a1|aa1|aaa1 a2|aa2|aaa2 a3|aa3|aaa3"; string [] strsplit=str.split(' ');foreach (string item g in strsplit){ Console.WriteLine(item.replace("|"," "));} HTMLDocument 读网页数据 radio的问题 windows2003下发布iis遇到人品级问题 !!!!!!!!!!!!!!!! 关于实现vs2008工具箱显示隐藏功能的实现 UTF-8写文件 DEV treelist实现更新 大虾来 关于C# 编写dll,vb6调用的问题 超难问题,如何解决DrawString字间距的问题? 取余数? 如何把公共的东西做成一个模块或者是文本形式的文件,然后在别的WinForm窗体中包涵他呢,比如... C#是如何读写注册表的? 增加记录出问题了,能写入数据库,但是报个委将对象引用到实例,求解答 窗口名称
string[] b = a.split("|")
a1 aa1 aaa1
a2 aa2 aaa2
a3 aa3 aaa3
存入数据库
你这样得 分割两次…… 一次 用空格分 一次用“|”分。分别存进DataTable或者数组 都行
StringBuilder sql = new StringBuilder();
sql.Append("insert into tbA(col1, col2, col3) ");
foreach(string s in str.Split(' ')){
sql.AppendFormat("select '{0}', '{1}', '{2}' union ", s.Split('|'));
}
sql.Remove(sql.Length - 6, 6);
var result = Regex.Matches(s, @"(\w+)(\d+)").Cast<Match>().OrderBy(m => m.Groups[2].Value).GroupBy(m => m.Groups[1].Value).ToList();
foreach (var g in result)
{
foreach (var item in g)
{
Console.Write(item.Value + "\t");
}
Console.WriteLine();
}输出
a1 a2 a3
aa1 aa2 aa3
aaa1 aaa2 aaa3
string sql = string.Empty;
string[] result = null;
string[] aa = str.Split(' ');
for( int i = 0; i < aa.Length; i++ )
{
result= aa[i].Split('|');
sql = string.Format("insert into 表名 values('{0}','{1}','{2}')",result[0],result[1],result[2]);
}
{
foreach(string a in s.Split(' '))
{string[] arr=a.Split('|');}
}
var item = str.Split(new char[] { ' ' });
foreach (var t in item)
{
foreach (var s in t.Split(new char[] { '|' }))
{
Console.Write(s+" ");
}
Console.WriteLine();
}
string [] strsplit=str.split(' ');
foreach (string item g in strsplit)
{
Console.WriteLine(item.replace("|"," "));
}