Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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?

 

  • Anonymous's avatar
    Anonymous
    8 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

  • Anonymous's avatar
    Anonymous
    Not 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-msft's avatar
      v-chuncz-msft
      Community Support

      Anonymous,

       

      Glad to hear that. You may share more complete solution here and accept it. Your contribution is highly appreciated.