Keep decimal numbers from a text field

[jamesperry]

Hi,

I have a dataset with a text column with data formatted as below - the text within the brackets and the numeric values change with each row

[QResponse]

A (Database analysis) = 5;B (Database analysis) = 5.5;C (Database analysis) = 2;D (Database analysis) = 0

I want to ouput four columns as follows

5; 5.5; 2;0

The problem I have is that Text.Select([QResponse], {"0".."9", ";"}) kept characters turns the 5.5 into 55.  Any help gratefully appreciated.

Cheers

[AlB · Accepted solution]

Hi @jamesperry 

Maybe try

Text.Select([QResponse], {"0".."9", ";", "." })

[jamesperry]

Thanks - should have thought of that!