Basically for the last two columns I replace all spaces, open brackets, and close brackets with an empty String and then I split the value by a comma and get the first item from the split.
Edit - I also convert the values returned from the process described to an Integer which will round all values down and remove the decimal place.
thank you for your input dday, but unfortunetly i get a an error ; Too many arguments to 'Public Overloads Sub Replace(value As JToken)'.
Last edited by hyperbell; Mar 25th, 2016 at 12:54 PM.