[文本处理] 【已解决】求助从CSV中读取内容后重新整理成一行行的

zhengwei007

我有一个rec.csv文件，里面内容如下：

3	corpse_make_list={{[charcoal];1;1;5.6617};{[magic_ring];1;1;34.3131};{[rp_broad_sword];1;1;4.5293}}	additional_make_multi_list={{{{[adena];30;42;100}};70};{{{[apprentice's_earing];1;1;30.9859};{[necklace_of_magic];1;1;23.0047};{[magic_ring];1;1;46.0094}};25.7009};{{{[stem];1;1;29.1262};{[varnish];1;1;14.5631};{[suede];1;1;9.7087};{[silver_nugget];1;1;5.8252};{[thread];1;1;29.1262};{[rp_bow];1;1;11.6506}};6.6988}}
4	corpse_make_list={{[suede];1;1;5.1827};{[willow_staff_head];1;1;0.5553};{[broad_sword_blade];1;1;0.5553}}	additional_make_multi_list={{{{[adena];41;58;100}};70};{{{[cotton_shoes];1;1;33.3333};{[crude_leather_shoes];1;1;33.3333};{[short_leather_gloves];1;1;33.3334}};1.5132};{{{[charcoal];1;1;50};{[suede];1;1;33.3333};{[rp_wooden_arrow];1;1;16.6667}};3.0618}}
5	corpse_make_list={{[lesser_healing_potion];1;1;21.6259};{[suede];1;1;6.4878};{[rp_wooden_arrow];1;1;3.2439}}	additional_make_multi_list={{{{[adena];51;72;100}};70};{{{[small_shield];1;1;58.8121};{[leather_cap];1;1;41.1879}};1.5322};{{{[coal];1;1;13.9182};{[varnish];1;1;13.9182};{[rp_cedar_staff];1;1;2.5727};{[wooden_arrow];10;30;69.5909}};10.3267}}
复制代码

上面代码是以制表符分隔的一共3行3列。
如果英文名称后面是4组数字，则将数字直接写在后面，然后另起一行。
如果英文名称后面是3组数字，则将将后面出现4组数字的最后一组，写到前面的最后一组给补齐即可。
通过整理希望达到如下效果：

3	corpse_make_list	charcoal	1	1	5.6617	
3	corpse_make_list	magic_ring	1	1	34.3131	
3	corpse_make_list	rp_broad_sword	1	1	4.5293	
3	additional_make_multi_list	adena	30	42	100	70
3	additional_make_multi_list	apprentice's_earing	1	1	30.9859	25.7009
3	additional_make_multi_list	necklace_of_magic	1	1	23.0047	25.7009
3	additional_make_multi_list	magic_ring	1	1	46.0094	25.7009
3	additional_make_multi_list	stem	1	1	29.1262	6.6988
3	additional_make_multi_list	varnish	1	1	14.5631	6.6988
3	additional_make_multi_list	suede	1	1	9.7087	6.6988
3	additional_make_multi_list	silver_nugget	1	1	5.8252	6.6988
3	additional_make_multi_list	thread	1	1	29.1262	6.6988
3	additional_make_multi_list	rp_bow	1	1	11.6506	6.6988
4	corpse_make_list	suede	1	1	5.1827	
4	corpse_make_list	willow_staff_head	1	1	0.5553	
4	corpse_make_list	broad_sword_blade	1	1	0.5553	
4	additional_make_multi_list	adena	41	58	100	70
4	additional_make_multi_list	cotton_shoes	1	1	33.3333	1.5132
4	additional_make_multi_list	crude_leather_shoes	1	1	33.3333	1.5132
4	additional_make_multi_list	short_leather_gloves	1	1	33.3334	1.5132
4	additional_make_multi_list	charcoal	1	1	50	3.0618
4	additional_make_multi_list	suede	1	1	33.3333	3.0618
4	additional_make_multi_list	rp_wooden_arrow	1	1	16.6667	3.0618
5	corpse_make_list	lesser_healing_potion	1	1	21.6259	
5	corpse_make_list	suede	1	1	6.4878	
5	corpse_make_list	rp_wooden_arrow	1	1	3.2439	
5	additional_make_multi_list	adena	51	72	100	70
5	additional_make_multi_list	small_shield	1	1	58.8121	1.5322
5	additional_make_multi_list	leather_cap	1	1	41.1879	1.5322
5	additional_make_multi_list	coal	1	1	13.9182	10.3267
5	additional_make_multi_list	varnish	1	1	13.9182	10.3267
5	additional_make_multi_list	rp_cedar_staff	1	1	2.5727	10.3267
5	additional_make_multi_list	wooden_arrow	10	30	69.5909	10.3267
复制代码

我希望通过批处理，执行后自动l输出到sour.csv中即可。

zhengwei007

为什么前三行是三组数字？
czjt1234 发表于 2024-3-14 06:57

自身的格式就是这样，所以根据前面的英文，corpse_make_list这个类型就是3组数字，整理出来后，这个一行是5个字段，而additional这个开头的，是6个字段。

zhengwei007

谢谢楼上几位，搞定啦