Forum Discussion

pruehoyer's avatar
pruehoyer
New Member
2 years ago
Solved

First and Last Name Order

I have a column containing first and last names but the order is not consistant, sometimes the order is Last Name First Name and sometimes the order is Fist Name Last Name (eg. Hoyer Prue and Prue Ho...
  • ThxAlot's avatar
    ThxAlot
    2 years ago

    Easy enough

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUfLIr0wtUggoKk0FcgwNlGJ1opWMgEyQiAJYEsgxgogbA5kh+bkKiXkpCl6pRUWVQL4xRMoEyAQLgSWBioB8E4iUKbotphBxM7gWR7gWM6BULAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Sales SN" = _t, Name = _t, Qty = _t]),

    #"Cleansed Names" = Table.AddColumn(Source, "Cleansed Name", each Text.Combine(List.Sort(Text.Split(Text.Proper([Name]), " ")), " "))
in
    #"Cleansed Names"

ThxAlot's avatar
ThxAlot
Super User
2 years ago

Easy enough

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUfLIr0wtUggoKk0FcgwNlGJ1opWMgEyQiAJYEsgxgogbA5kh+bkKiXkpCl6pRUWVQL4xRMoEyAQLgSWBioB8E4iUKbotphBxM7gWR7gWM6BULAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Sales SN" = _t, Name = _t, Qty = _t]),

    #"Cleansed Names" = Table.AddColumn(Source, "Cleansed Name", each Text.Combine(List.Sort(Text.Split(Text.Proper([Name]), " ")), " "))
in
    #"Cleansed Names"