Column1 Result Gi1/0/1 Gi1/0/01 GI1/0/11 GI1/0/11 abcdef5/8/5 abcdef5/8/05 abcdef5/8/56 abcdef5/8/56 ZXCV/bb/rtu/999/75 ZXCV/bb/rtu/999/75 abc/879/134/444444 abc/879/134/444444 ab/11/22/rem/3 ab/11/22/rem/03 ab/11/22/rem/44 ab/11/22/rem/44
Code:let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content] in Table.SelectColumns(Table.AddColumn(Source, "Result", each Text.Format("#{0}/#{1}",{Text.BeforeDelimiter([Column1], "/", {0, RelativePosition.FromEnd}),Text.PadStart(Text.AfterDelimiter([Column1], "/", {0, RelativePosition.FromEnd}),2,"0")})),{"Result"})






Bookmarks