Forum Discussion
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 looks as follows:
DetailColumns = Table.ExpandRecordColumn(RecordsOfPage, "PageData", {"FullName", "Field1","Field2","Field3"}
[FullName] returns Last, First name (i.e. "Smith, Joe"). I need to transform this to "Joe Smith".
I suspect it has something to do with the function: Text.BeforeDelimiter([FullName], ",", 0), type text) and Text.AfterDelimiter([FullName], ",", 0), type text) <--NOTE: SYNTAX MAY/MAY NOT BE CORRECT
However, I'm not familiar enough with the M language to how exactly embed this within the ExpandRecordColumn line of code. I tried to do it afterwards by pulling [FullName] twice, but I can't pull the same field twice. Advice going either direction would be much appreciated.
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
6 Replies
camargos88Community Champion
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- HotChilli
Try using 'Add Column from examples' to see what powerbi comes up with. Give it some good examples .
- HotChilli
Start a new thread and please provide a data sample in text format
