First I have a question about the data format.
Tim Guth wrote:
name, age/year born, body fat%, height, weight
James Smith 43 year old 18%, 180, 86
Thomas Miller 1980, 11.2%, 191, 82
Dean Thomas, 43 year old 13.1%, 174, 71
It seems that "," is the delimiter, however it's missing in here and there.
So what's your data format?
A long string field?
name, age/year born, body fat%, height, weight James Smith 43 year old 18%, 180, 86 Thomas Miller 1980, 11.2%, 191, 82 Dean Thomas, 43 year old 13.1%, 174, 71
Or 5 fields?
name age/year born body fat% height weight James Smith 43 year old 18% 180 86 Thomas Miller 1980 11.20% 191 82 Dean Thomas 43 year old 13.10% 174 71
sorry for not clarifying this: yes, it is a long string field and you are right, the delimiter is not consistent. I need to find a way to deal with this.
Perfect, thanks a lot!
that works very nice. How would I edit the regex when I only want it to extract the number when there is a "19" in the beginning? I just found the following case:
Ronaldo Pereira 2, 21.2%, 169, 83
--> this entry has no age (the "2" stands for being called like his dad) and your command extracts the 2 as age. In fact, nothing should be extracted.
Thanks for your help!
That's amazing, thanks a lot