splitting string 1

[DrHabi]

I wasn't able to search and see if this has been asked before so sorry if it has. I need to split a string and get only two numbers out if. The field string looks like this:

ZMC CREW HD TSU-YYZ/YVR/YUL:Qty from 106 to 80
the text before the ':' will change in length but the rest stays the same except for the numbers which I need to grab both and use in calcs
thanks

 

[lbass]

For the first number use this formula:

val(extractstring({table.string},"from ", " to"))

For the second number use:

stringvar array x := split(trim({table.string})," ");
val(x[ubound(x)])

-LB

 

[DrHabi]

great! Thanks for the help and have a good one!