Get title from each file and renaming each file

[Selster]

I have word files in a folder. (If it would be better, I can convert them to excel or html.) To clarify:

2. The files are uneven. While they have columns, they have different numbers of them, so these are not excel files that can be “merged.”

3. The files are named in a way that does not show their content. This is the problem: 1 misc.xlsx …

4. Sometimes the 1st or 2nd rows contain a word or two that is irrelevant.

5. 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

6. 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

[mlauber71]

@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.

how to import tables from .docx documents via R snippet

Based on your code I put together a rough solution with KNIME. You might further adapt that to your needs. If the structure of the tables from the docx would be the same it would be possible to use one R Snippet and bind the results together by rbind. I collect all the tables in a tibble in R, store that as a .RDS file and read it back to KNIME and then extract all the tables and collect them. The varying structures are caputed by and Loop End node. You might have to process the data further. …

Read tables from Word documents (.docx) and import them into KNIME. – mlauber71

[ipazin]

Hello @Selster,

to start from end. No. To access Excel data you have to read it inside KNIME (at least without using Python or R) so you have to read all files you would like to rename with info from it into KNIME.

To make that work smoothly there are couple of things to do:

• read files one by one into KNIME using loop
• In Excel Reader (XLS) node specify which row contains header (row 3)
• use Extract Column Header to have header in row 1
• follow that with Table Row to Variable node to have headers as flow variables
• use String Manipulation (Variable) to create flow variable with path for file with new name
• use this flow variable to control Excel Writer (XLS) node

You can check this workflow on reading Excel Files to help you started:

Read an XLS file – scottF

Give it a try and if any questions feel free to ask Welcome to Community!

Br,
Ivan

[Selster]

Hello ipazin, I have downloaded your workflow. Using the bottom of your three flows, I get as far as the Excel Reader which refuses to execute, even though I have put in the path my local folder? Thank you very much, Steve

[ipazin]

Hello @Selster,

what is the error you are seeing? If you are reading only one sheet from each Excel file you can modify bottom flow in a way to remove outer loop and Read Excel Sheet Names (XLS) node.

Br,
Ivan