excel delimiter spltting [英] excel delimiter spltting
问题描述
嗨朋友们,
我有一个excel文件,我根据特殊的charectors拆分单元格内容,如下所示:
dt = new DataTable();
dt.Columns.Add(Name);
dt.Columns.Add(年龄);
dt.Columns.Add(技能);
dt.Columns.Add(count);
string name = rdr [0] .ToString();
string age = rdr [1] .ToString();
char [] s = new char [1] {';'};
char [] k = new char [1] {'@'};
string [] skills = rdr [2] .ToString().Split(s);
string [] counts = rdr [ 3] .ToString()。分裂(k);
(即)如果我有下表
姓名kk
年龄31
技能.net; sqlserver; oracle
算1 @ 2 @ 3 @
输出将是:
kk 31 .net 1
sql 2
oracle 3
我成功实现了以上产量。
必需输出1:
如果你有1个@#2 @#3 @#在计数列而不是1 @ 2 @ 3 @,我如何拆分下面的表达式?
char [] k = new char [1] {'@'};
必需输出2:
如何拆分表达式(char [] k = new char [1] {'@'} ; --->如果我同时拥有@#和@(即):1'#2 @ 3 @ in'count'列。
这里我也想要输出as:
1
2
3
希望我很清楚。请帮我分类这个问题。
谢谢,
Kranthi
Hi Friends,
I have an excel file and I am splitting cell content based on special charectors as shown below:
dt =new DataTable();
dt.Columns.Add("Name");
dt.Columns.Add("Age");
dt.Columns.Add("Skills");
dt.Columns.Add("counts");
string name = rdr[0].ToString();
string age = rdr[1].ToString();
char[] s = new char[1] { ';' };
char[] k=new char[1] {'@'};
string[] skills = rdr[2].ToString().Split(s);
string[] counts = rdr[3].ToString().Split(k);
(ie) If i have below table
Name kk
Age 31
Skills .net;sqlserver;oracle
counts 1@2@3@
output will be :
kk 31 .net 1
sql 2
oracle 3
I am successfull in achieveing above output.
Required Output1:
if you have 1@# 2@# 3@# in counts column instead of 1@2@3@,the how do i split below expression?
char[] k=new char[1] {'@'};
Required Output2:
how to split expression (char[] k=new char[1] {'@'};---> if i have both @# and @ (ie) like: 1@# 2@ 3@ in 'counts' column.
here also i want output as :
1
2
3
Hope I am clear.Please help me in sorting this issue.
Thanks,
Kranthi
推荐答案
不太清楚,但如果你添加选项System.StringSplitOptions.RemoveEmptyEntries,你可能会解决你的问题
:
http://msdn.microsoft.com/ en-us / library / ms131448.aspx [ ^ ],
http://msdn.microsoft.com/en-us/library/system.stringsplitoptions %28v = vs.110%29.aspx [ ^ ]。
-SA
Not quite clear, but perhaps you'll solve your problem if you add the optionSystem.StringSplitOptions.RemoveEmptyEntries
:
http://msdn.microsoft.com/en-us/library/ms131448.aspx[^],
http://msdn.microsoft.com/en-us/library/system.stringsplitoptions%28v=vs.110%29.aspx[^].
—SA
这篇关于excel delimiter spltting的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!