请问如何在存在间隔的编码中批量插入行呢？

追星星

从左图变成右图，由于种种原因，不能使用VBA，是否有其他方法可以做到这样的结果呢？

zpy2

drop table if exists temp;

create table temp as with recursive cn(i,v) as (values(1,'v')

union


select i+1 i,'v' v from cn  where i<21 ),b as (select group_concat(v) 数据 from cn),a as (select regexp2('(.*)-(\d+)',编码,1) 编码2,regexp2('(.*)-(\d+)',编码,2) 编码3,* from 批量插入行原明细表),c as (select 编码2,max(编码3) maxnum from a group by 编码2),d as (select maxnum,编码2,substr(b.数据,1,c.maxnum*2-1) 数据 from b,c) select * from d;select split_data('temp');with x as (select *,(select count(1) from tempsplit where rowid<=aa.rowid and 编码2=aa.编码2) 编码3 from tempsplit aa),y as (select 编码2||'-'||printf('%03d',编码3) 编码 from x) select y.编码 编码,性别 from y left join 批量插入行原明细表 using(编码)