Forum Discussion

jamesperry's avatar
jamesperry
Frequent Visitor
7 years ago
Solved

Keep decimal numbers from a text field

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

2 Replies

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion

    Hi jamesperry 

     

    Maybe try

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