string str = "输入的字符串"; var array = Regex.Replace(str, @".{30}","$0@").Split('@');
int num = 6; string content = "陕西省省长赵正永当天实地察看事故现场时强调,死伤这么多同胞,令人十分痛心,作为事故发生地,一定要本着对人民群众高度负责的精神,全力配合国务院调查组查清事故原因"; string pattern = string.Format(@"(?<=\G[\s\S]{{{0}}})",num); List<string> result = Regex.Split(content,pattern).ToList();
sql语句怎么截取字符串,求解。
insert into table values(substring('Content',0,3)) SQL也有 substring 函数,, 第一个参数内容,第二个起始位置,第三个长度
declare @i int declare @count int declare @length int set @i=0 set @length=LEN('Content') if @length/30>0 begin set @count=@length/30+1 end else begin set @count=@length/30 endwhile @i<=@count begin if @i=@count begin insert into table values(SUBSTRING('Content',@i*30,@length-@i*30)) end else begin insert into table values(SUBSTRING('Content',@i*30,30)) end set @i+=1 end
'Content' 这个参数可以用SQL语句吗?
if @length/30>0 这个 改成 if @lengt%30>0
declare @i int declare @count int declare @length int set @i=0 set @length=LEN('Content') if @length%30>0 begin set @count=@length/30+1 end else begin set @count=@length/30 endwhile @i<@count begin if @i=@count-1 begin insert into table values(SUBSTRING('Content',@i*30,@length-@i*30)) end else begin insert into table values(SUBSTRING('Content',@i*30,30)) end set @i+=1 end
string 后=substring(29,txt.length);
var array = Regex.Replace(str, @".{30}","$0@").Split('@');
string content = "陕西省省长赵正永当天实地察看事故现场时强调,死伤这么多同胞,令人十分痛心,作为事故发生地,一定要本着对人民群众高度负责的精神,全力配合国务院调查组查清事故原因";
string pattern = string.Format(@"(?<=\G[\s\S]{{{0}}})",num);
List<string> result = Regex.Split(content,pattern).ToList();
declare @i int
declare @count int
declare @length int
set @i=0
set @length=LEN('Content')
if @length/30>0
begin
set @count=@length/30+1
end
else
begin
set @count=@length/30
endwhile @i<=@count
begin
if @i=@count
begin
insert into table values(SUBSTRING('Content',@i*30,@length-@i*30))
end
else
begin
insert into table values(SUBSTRING('Content',@i*30,30))
end
set @i+=1
end
'Content' 这个参数可以用SQL语句吗?
declare @count int
declare @length int
set @i=0
set @length=LEN('Content')
if @length%30>0
begin
set @count=@length/30+1
end
else
begin
set @count=@length/30
endwhile @i<@count
begin
if @i=@count-1
begin
insert into table values(SUBSTRING('Content',@i*30,@length-@i*30))
end
else
begin
insert into table values(SUBSTRING('Content',@i*30,30))
end
set @i+=1
end