Forum Discussion
Custom Column extracting file type
I know how to create a custom column, but i would need a formula that extracts the file type (extensions). I know of the LEFT command, but some file types are .PDF, 3 characters, while others are .DO...
If you are in Power Query use the split column by delimiter option or extract option
Anonymous ,
extension = right( [Column], len([column]) -search(".",[column],,0) )
file= left( [Column],search(".",[column],,0)-1 )
Thanks for the response, however, i am seeing this when i try to copy it over.
If you are in Power Query use the split column by delimiter option or extract option