输入文件是成千行记录的文本文件,下面是截取的两行记录:- 592 NM_001142467 chr1 - 934343 935552 934438 935353 3 934343,934905,935071, 934812,934993,935552, 0 HES4 cmpl cmpl 1,0,0,
- 592 NM_021170 chr1 - 934341 935552 934438 935353 4 934341,934905,935071,935245, 934812,934993,935167,935552, 0 HES4 cmpl cmpl 1,0,0,0,
复制代码 希望获得的结果是将,每一行的第10,11列,按照“,”进行拆分后,分别相互配对,每一列包含的由“,”拆分区间个数不定,数目为第9列数值
输出结果中,第1~3,7列为输入文件的2~4,13列,没有做修改,只是第4,5列是原输入文件第10,11列按顺序依次拆分后的结果- NM_001142467 chr1 - 1 934343 934812 HES4
- NM_001142467 chr1 - 2 934905 934993 HES4
- NM_001142467 chr1 - 3 935071 935552 HES4
- NM_021170 chr1 - 1 934341 934812 HES4
- NM_021170 chr1 - 2 934905 934993 HES4
- NM_021170 chr1 - 3 935071 935167 HES4
- NM_021170 chr1 - 4 935245 935552 HES4
复制代码 |