I have word files in a folder. (If it would be better, I can convert them to excel or html.) To clarify: The files are uneven. While they have columns, they have different numbers of them, so these are not excel files that can be “merged.” The files are named in a way that does not show their content. This is the problem: 1 misc.xlsx … Sometimes the 1st or 2nd rows contain a word or two that is irrelevant. By the 3rd row, there is a heading, in bold. I would like to be able to grab this and rename the file with that heading. So 1 misc.xlsx becomes 1 MyHeading.xlsx Is is possible to spool through the files and rename or copy each file to new one,but now with a more informative name? Steve

Get title from each file and renaming each file

mlauber71 September 10, 2020, 7:32pm 2

@Selster welcome to the KNIME forum.

There was a debate about a similar scenario and I create a sample workflow using an R package. Maybe you could try and reuse that.

1 Like