Extract File Name from a Full Path in a Cell

[jgarza0422]

I need to see how to extract on the file name from a columns that contains the full path using Power Query.

C:\Users\Desktop\Test\PMOD-0001.doc

Thanks,

 

[theBardd]

It's pretty simple, split the filepath into a list delimited by \, and get the last item in the list

let
    Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
    #"Added Custom1" = Table.AddColumn(Source, "Custom", each List.Last(Text.Split([Filepath],"\")))
in
    #"Added Custom1"

 

[theBardd]

If you wanted to replace in the original column, you can yse

let
    Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
    ExtractFilename = Table.TransformColumns(Source, {{"Filepath", each List.Last(Text.Split(_, "\")), type text}})
in
    ExtractFilename

 

[jgarza0422]

Thanks, That worked!