Forum Discussion
Can't subtract
I just want the characters to the right of the word Breaker in one column (variable number to the left). If there is an easier way, let me know. I got close, but I want to subtract 7 from the numbe...
Oh, yeah. Way easier in Power Query. Just split column by delimiter, custom delimiter, " breaker "
I hace a column that looks like this. I want just the stuff after "breaker " in a different column.
xyz breaker 12a b34
wxzd breaker 3 24cd skl
jfdkla breaker q u o 24
Output
12a b34
3 24cd skl
q u o 24
CoreyP
Solution Sage
Solution SageOh, yeah. Way easier in Power Query. Just split column by delimiter, custom delimiter, " breaker "