stefanoste78
Member
Good morning.
I would like to ask you a question based on your experiences. I will list a series of points in such a way that you can tell me which of these can be done.
Starting situation: In a folder I have files of different types (Excel, PDF etc. - if it is not possible with different files I could transform pdf files into Excel files, just as I could divide the different files into different folders by type).
Could you tell me which of these points you can do:
1) analyze each file to understand which of these contains a table (we could analyze the structure of the file invading the existence of different columns within them) by deleting files that do not have tables;
2) count how many times a string is repeated within each file containing tables;
3) Combine the different files containing tables. Merge should be done by adding, to the file to be created, the different headers contained in each file (if already exists there is no need to insert the header in the file to be created) and move the table contents in the new table according to the header.
Example:
Table "1" has the following column headers: "a, b, d"
the table "2" the headings: a, c (the heading "a" is the same for both tables)
from the union of these two tables a new file will be created with only one table inside that has the column headers equal to the two tables: "a, b, c, d" and the contents of each table.
Thank you
I would like to ask you a question based on your experiences. I will list a series of points in such a way that you can tell me which of these can be done.
Starting situation: In a folder I have files of different types (Excel, PDF etc. - if it is not possible with different files I could transform pdf files into Excel files, just as I could divide the different files into different folders by type).
Could you tell me which of these points you can do:
1) analyze each file to understand which of these contains a table (we could analyze the structure of the file invading the existence of different columns within them) by deleting files that do not have tables;
2) count how many times a string is repeated within each file containing tables;
3) Combine the different files containing tables. Merge should be done by adding, to the file to be created, the different headers contained in each file (if already exists there is no need to insert the header in the file to be created) and move the table contents in the new table according to the header.
Example:
Table "1" has the following column headers: "a, b, d"
the table "2" the headings: a, c (the heading "a" is the same for both tables)
from the union of these two tables a new file will be created with only one table inside that has the column headers equal to the two tables: "a, b, c, d" and the contents of each table.
Thank you