when you say 8 characters is that a default? It doesn't need to be longer. A=a for this data set. here is the data set again from a notepad: A,M,13.4,39,4100,14,25,17 B,f,14.6,46,5000,15,30,20 a,F,13.5,42,4500,19,21,18 A,M,15,46,4600,23,16,18 b,m,14.6,44,5100,17,,19 B,m,14,44,4900,20,24,19 b,f,16.4,49,4300,21,17,18 A,f,14.8,44,4400,16,26,29 a,F,15.2,46,4100,27,13,27 B,M,15.5,48,8400,34,42,36 A,M,15.2,47,,26,27,22 B,F,16.9,50,5100,28,17,23 a,F,14.8,44,4700,24,20,23 A,M,16.2,45,5600,26,25,19 b,M,14.7,43,4000,23,13,17 A,F,14.7,42,3400,9,22,13 B,m,16.5,45,5400,18,32,17 B,f,15.4,45,6900,28,36,24 B,M,15.1,45,4600,,29,17 a,M,14.2,46,4200,14,25,28 b,F,15.9,46,5200,8,34,16 B,f,16,47,4700,25,14,18 A,F,17.4,50,8600,37,,17 A,M,14.3,43,5500,20,31,19 B,F,14.8,44,4200,15,24,19 a,f,15.5,,4900,17,27,16 a,m,26.5,,5200,19,32,21 I see what you now mean with the double commas, but I'm not sure how to handle that when it comes to importing the data.
... View more