Forum Discussion
Solved
Parsed Filename and Extension as Column
Hi all, I have a .csv file that contains a path and filenames in it and I need to extract the file extensions in a different column. The thing here is that some of those paths contains data with ...
Hi,
If you use on Power Query the split Column button (tab Home),
you have an option to select to use the most left or most right delimiter.
If you use the most right, it should work.
Check that your column, is of Text type, to have all options available.
Let us know if it works,
Another way I found is to duplicate the filename column into a new extension column, then use extract before (file) and after (ext) the delimiter, on the filename and extension columns. Specify the period as the delimiter in the extract screen, and under Advanced, select from the end of the input for both left and right filename parts.