Forum Discussion
Harvey85
Helper I
Helper IExtract Value from Field
Hi, I have a question. I have a field called Season where I need to keep the text before the numbers at the end (2123, 2223, etc., in the future new numbers of these characteristics may appear, always with 4 numbers at the end).
And the expected output is in the second column. How can I get it? Thank you!!
| Season | Expected Output |
| Abc 2123 | Abc |
| Def 2123 | Def |
| Abc 2223 | Abc |
| Def 2223 | Def |
| Abc 2 2123 | Abc 2 |
| Def 2 2223 | Def 2 |
| Ghi 1 2324 | Ghi 1 |
| Ghi 2 2425 | Ghi 2 |
There are lots of ways in power query to do this.
Example-> Split Column by delimiter (using 'space' as far right as possible)
1 Reply
- HotChilli
Community Champion
There are lots of ways in power query to do this.
Example-> Split Column by delimiter (using 'space' as far right as possible)