You can try extracting a number with either a regex, like in this example - https://www.elastic.co/blog/using-painless-kibana-scripted-fields
or split your string and extract the second array cell, like in this example - Using painless script split(string) don't work
Thanks!