Forum Discussion
jamesperry
7 years agoFrequent Visitor
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
Community Champion
- jamesperryFrequent Visitor
Thanks - should have thought of that!