Hey guys, i took data from internet which i am using in my processing project. I took it from the homepage's source, and then i only took out the part i intended to use, after that i removed all the <td> between my data like this.
void setupData(String data) {
String tempString = "";
boolean remove = false;
for (int i = 0; i < data.length(); i++){
char letter = data.charAt(i);
if (letter == '<'){
remove = true;
}else if (letter == '>'){
remove = false;
letter = ' ';
}
if(remove){
letter = ' ';
}
tempString = tempString + letter;
}
println(tempString);
}
So my data now pretty much looks like this :
Country 2008 f 2008 m 2007 f 2007 m 2006 f 2006 m 2000 f 2000 m 1990 f 1990 m 1980 f 1980 m United States 28.33 28.46 28.25 28.38 28.16 28.29 27.53 27.72 26.32 26.61 25.0 25.46 Afghanistan 21.1 20.63 20.98 20.61 20.9 20.59 20.62 20.68 20.73 21.21 20.48 21.42
This is first the year, then countries, counting at which average BMI that country was that specifik year.
Here the thing, this list of countries goes on and on, but i only intend to use 6 countries, im finding it very hard to only use those and use them with the proper variables. any ideas ?
Which pretty much goes on like this forever and ever. What i would like to do is read the information, so i only get the numbers, which are the BMI over a period of time in different countries. So id like to read the year, country and the numbers seperatly and without <td> etc etc. Do anyone know how thid could be done ?