How to create a numeric variable by taking numeric portion of a character variable

[knveraraju91]

Dear,

I have a variable 'TPT' containing numbers and text. I need to create a numeric variable (TPTNUM) from numeric portion of TPT. Please help

TPT

0.5 hours

1 hour

1.5 hours

2 hours

2.5 hours

output needed;

0.5

1

1.5

2

2.5

Thank you

[PGStats]

If the number is the first part of the field:

TPTNUM = input(scan(TPT, 1, " "), best.);