Forum Discussion
Solved
Excel Power Query - Add custom column with shortened Folder Path
Hi ALL, I have an excel file with a folder query that maintains list of the files in a directory. It has columns: Folder Path, Name, Extension, Size, etc.. I want the Folder Path column to start ...
alex_n Why not just select the Folder Path column and with the Transform tab active, extract text after the 7th back-slash. Thus, use the back-slash as the delimiter and skip the first 6. No extra column needed. But perhaps I misunderstood your intentions.
alex_n Why not just select the Folder Path column and with the Transform tab active, extract text after the 7th back-slash. Thus, use the back-slash as the delimiter and skip the first 6. No extra column needed. But perhaps I misunderstood your intentions.
Riny_van_EekelenIt worked! Thank you!
- SergeiBaklan good point, thank you sir!
