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 Teof...
Need Help
  • 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.

Anonymous's avatar
Anonymous
Not applicable
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.

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    8 years ago

    Anonymous,

     

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