Forum Discussion
PowerQuery Split column on first space after an integer
Hi I am wanting to split a string of text based on an integer and using the first space following an integer. This is a sample of the data.
B F 3 Exceed And Excel B G 5 Valixir(IRE) B OR BR F 3 Teofilo(IRE) BR OR BLK G 6 Fomalhaut(USA)
My desired result is
Exceed And Excel Valixir(IRE) Teofilo(IRE) Fomalhaut(USA)
I tried splitting on {"0".."9"} to represent any of an array of integers but that doesn't work. A little unsure of other tricks I could use.
Ideas?
- Anonymous8 years ago
Wow as soon as I posted I solved it. I used custom column from examples. Selected my current column and then supplied the example data and it was like flash fill in Excel it figured it out.
2 Replies
- AnonymousNot applicable
Wow as soon as I posted I solved it. I used custom column from examples. Selected my current column and then supplied the example data and it was like flash fill in Excel it figured it out.
- v-chuncz-msftCommunity Support
Anonymous,
Glad to hear that. You may share more complete solution here and accept it. Your contribution is highly appreciated.