Hello. Is there a way to remove the excel file name from Path?
Example… if I have an excel file with multiple row referencing different Paths
(ie. C:\doc1\doc2\file1.xlsx), how do extract the folder/directory portion only (C:\doc1\doc2)?
I’ve try searching and trying for the past 2 hours… no luck
if your path is in path format (not in string!) you can use a column expression node and a getParent() formula.
Have a look at this part of the column expressions node (functions under “Path” section) and at the workflow below.
Hello @amateur
Besides @lelloba solution based in Column Expression node; you can achieve the disclosing of the Path with KNIME base nodes by concatenating ‘Path to String’ and ‘URL to File Path’ nodes.
BR
P.S. Just for the records; this option can be valid as well: