Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
Sorry if this is simple but how do I remove text from a field to leave numbers. I have the below times as text but want to remove the h and m and just want to be left with the time, thanks for any help
Offered | Time |
35 h 30 m | 35.30 |
17 h 00 m | 17.00 |
36 h 35 m | 36.35 |
Solved! Go to Solution.
Best to do this in the Query Editor. Right click your column and choose Replace Values...
Best to do this in the Query Editor. Right click your column and choose Replace Values...
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |