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,
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,
