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...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi jamesperry 

     

    Maybe try

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

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

Hi jamesperry 

 

Maybe try

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

  • jamesperry's avatar
    jamesperry
    Frequent Visitor
    7 years ago

    Thanks - should have thought of that!