Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Within M Language change "Last, First" Name to "First Last"?

Hi all,   Thank you to everyone for this continued support on this community.  It has been incredibly helpful with getting through this project.  So continuing that path...   I have code that loo...
Need Help
Tutorial Requests
  • camargos88's avatar
    camargos88
    6 years ago

    Hi Anonymous ,

     

    Try this code on add a new column for Power Query:

     

    Text.Combine(List.Reverse(Text.Split([Column1],",")), " ")

     

     

    Did I answer your question? Mark my post as a solution!
    Ricardo

camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous ,

 

Try this code on add a new column for Power Query:

 

Text.Combine(List.Reverse(Text.Split([Column1],",")), " ")

 

 

Did I answer your question? Mark my post as a solution!
Ricardo

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    camargos88  Brilliant!!!  Thank you!

     

    And thank you to everyone here for suggestions and feedback.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello! I know this is old but this is what I'm looking for. However I keep getting errors because some of my values are null. How could you edit this query to account for nulls?