12-01-2016, 12:02 PM
Macro Macro632
or
Macro Macro964
str s="{37.5K 134K 21.37K 2.351K 0.542K 0.017K}"
s.replacerx("\.(\d)K\b" "${1}00")
s.replacerx("\.(\d\d)K\b" "${1}0")
s.replacerx("\.(\d\d\d)K\b" "${1}")
s.replacerx("(\d)K\b" "${1}000")
s.replacerx("\b0+([1-9])" "$1")
out s ;;{37500 134000 21370 2351 542 17}or
Macro Macro964
