I want to generate pattern like this as an array or text file thanks if you check the data below you will find that
1- ST will be repeated when column (Type) equal to "ST" as column (This_ID) the last two numbers 10, 30, 50, 70,90
2- BL will be repeated when column (Type) equal to "BL" as column (This_ID) the last two numbers 15, 35, 55, 75,95
3- RS will be repeated when column (Type) equal to "RS" as column (This_ID) the last two numbers 20, 40, 60, 80 4- else Type will be "AS"
pect,H_ID,From,To,This_ID,Type
Kur,K022,0,1,6401,As
Kur,K022,1,2,6402,As
Kur,K022,2,3,6403,As
Kur,K022,3,4,6404,As
Kur,K022,4,5,6405,As
Kur,K022,5,6,6406,As
Kur,K022,6,7,6407,As
Kur,K022,7,8,6408,As
Kur,K022,8,9,6409,As
Kur,K022,,,6410,ST
Kur,K022,9,10,6411,As
Kur,K022,10,11,6412,As
Kur,K022,11,12,6413,As
Kur,K022,12,13,6414,As
Kur,K022,,,6415,BL
Kur,K022,13,14,6416,As
Kur,K022,14,15,6417,As
Kur,K022,15,16,6418,As
Kur,K022,16,17,6419,As
Kur,K022,,,6420,RS
Kur,K022,17,18,6421,As
Kur,K022,18,19,6422,As
Kur,K022,19,20,6423,As
Kur,K022,20,21,6424,As
Kur,K022,21,22,6425,As
Kur,K022,22,23,6426,As
Kur,K022,23,24,6427,As
Kur,K022,24,25,6428,As
Kur,K022,25,26,6429,As
Kur,K022,,,6430,ST
Kur,K022,26,27,6431,As
Kur,K022,27,28,6432,As
Kur,K022,28,29,6433,As
Kur,K022,29,30,6434,As
Kur,K022,,,6435,BL
Kur,K022,30,31,6436,As
Kur,K022,31,32,6437,As
Kur,K022,32,33,6438,As
Kur,K022,33,34,6439,As
Kur,K022,,,6440,RS
Kur,K022,34,35,6441,As
Kur,K022,35,36,6442,As
Kur,K022,36,37,6443,As
Kur,K022,37,38,6444,As
Kur,K022,38,39,6445,As
Kur,K022,39,40,6446,As
Kur,K022,40,41,6447,As
Kur,K022,41,42,6448,As
Kur,K022,42,43,6449,As
Kur,K022,,,6450,ST
Kur,K022,43,44,6451,As
Kur,K022,44,45,6452,As
Kur,K022,45,46,6453,As
Kur,K022,46,47,6454,As
Kur,K022,,,6455,BL
Kur,K022,47,48,6456,As
Kur,K022,48,49,6457,As
Kur,K022,49,50,6458,As
Kur,K022,50,51,6459,As
Kur,K022,,,6460,RS
Kur,K022,51,52,6461,As
Kur,K022,52,53,6462,As
Kur,K022,53,54,6463,As
Kur,K022,54,55,6464,As
Kur,K022,55,56,6465,As
Kur,K022,56,57,6466,As
Kur,K022,57,58,6467,As
Kur,K022,58,59,6468,As
Kur,K022,59,60,6469,As
Kur,K022,,,6470,ST
Kur,K022,60,61,6471,As
Kur,K022,61,61.4,6472,As