بدست آوردن شماره سطر ماتریس با مقدار رشته ای

سلام و عرض احترام،
بنده یه table دارم به شکل زیر با n رکورد که رکوردهاش به شکل زیر است(البته این رکوردهارو از یه تکس خوندم و توی یه متغییر ریختم با نامTest).


tcp,ftp_data,SF,35195,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,10,10,0.00,0.00,0.00,0.00,1.00,0.00,0.00,92, 44,0.43,0.07,0.43,0.05,0.00,0.00,0.00,0.00,normal.
tcp,ftp_data,SF,8325,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,20,20,0.00,0.00,0.00,0.00,1.00,0.00,0.00,103, 54,0.49,0.06,0.49,0.04,0.00,0.00,0.00,0.00,normal.
icmp,ecr_i,SF,1032,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,511,511,0.00,0.00,0.00,0.00,1.00,0.00,0.00,255, 255,1.00,0.00,1.00,0.00,0.00,0.00,0.00,0.00,smurf.
icmp,ecr_i,SF,1032,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,511,511,0.00,0.00,0.00,0.00,1.00,0.00,0.00,255, 255,1.00,0.00,1.00,0.00,0.00,0.00,0.00,0.00,smurf.
icmp,ecr_i,SF,1032,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,511,511,0.00,0.00,0.00,0.00,1.00,0.00,0.00,255, 255,1.00,0.00,1.00,0.00,0.00,0.00,0.00,0.00,smurf.
udp,private,SF,105,146,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,2,2,0.00,0.00,0.00,0.00,1.00,0.00,0.00,255,25 4,1.00,0.01,0.00,0.00,0.00,0.00,0.00,0.00,normal.


من میخوام شماره سطرهایی که ستون آخرشون برابر 'normal' هستش رو در بیارم یا اینکه رکوردهایی که ستون آخرشون برابر'normal' هستند رو بریزم توی یه متغییر دیگه،
لطفا راهنماییم کنید.
بسیار سپاس.