How to split Excel table into CSV files in .doc by Bold text?

Question

You have 777 .doc files where each .doc file contains a big Excel table, like one here and in Fig. 1. Here, only consider one .doc file. I want to divide the Excel table of .doc file into CSV files by any Unix programming language and/or scripting. I cannot find a way to handle Microsoft fileformats into CSV files. Pseudocode:

1. Extract Excel table from .doc file, which is expanded in the thread How to extract many .doc text + tabular elements into CSV by any Unix tool?

2. Split Excel table (maybe convert here already to CSV) into separate .CSV files by Rule:

   new bolding indicates a new table i.e. a new CSV file.

3. Apply implicit columns Location (bottom/top) and Date (dd.mm.yyyy) in the first two lines of the .doc file on the each separate CSV file. Use Time column (morning/evening/night).

Target files with their columns by Rule

1. Assisstants.csv - Name, Date, Location, Time
2. Other.Assistants.csv - Name, Date, Location, Time
3. General.csv - Event, Date, Location, Time

Fig. 1 Example of Excel Table in .doc file

OS: Linux Debian Stretch 9 and others
Data: .odt file here

Answer 1

OK...

---

Begin Mini Tutorial

---

So, here are some hints on generating a postgresql database to import your daily reports.

First, install postgresql if you haven't yet:

$sudo apt-get install postgresql

Second, if you are not familiar with postgresql, the default installation of postgresql in Debian is setup to allow each user to login through peer authentication with no password. However, you've got to create a database that is owned by the user.

Here is how to do that:

• Drop into a privileged shell

  $ sudo -s

• Become the postgres superuser

  # su postgres

• Create a database for the user to play in

  postgres$ createdb dbname -O user

• Then exit twice to get back to userland.

  postgres$ exit

  # exit

  $

• You should be ready to begin using postgresql

I've generated an SQL file that can be imported to make the tables. You can copy and paste the following into something like tables.sql

CREATE TYPE shifts AS ENUM ('morning','evening','night');
CREATE TYPE titles AS ENUM ('assistant','other_assistant');

CREATE TABLE assistants (id integer, name char(20), title titles);
CREATE TABLE disposition (id integer, name char(20), shift shifts, day date, comments text);
CREATE TABLE schedule (id integer, name1 char(2), name2 char(20), name3 char(20), name4 char(20), name5 char(20), shift shifts, day date);

And then import the tables:

psql
user=>\i tables.sql

If you parse your daily report into three separate CSV files, each file can be imported directly into each individual table using the \copy command.

Something like this:

\copy assistants FROM '~/assistants.csv' WITH (FORMAT csv);
\copy dispositions FROM '~/dispositions.csv' WITH (FORMAT csv);
\copy schedule FROM '~/schedule.csv' WITH (FORMAT csv);

This would fill in your tables with data and allow you to perform queries like finding out who made comments today and what those were...

Something like this:

 select * from disposition where day = 'TODAY';

Might produce the following output:

 id |         name         |  shift  |    day     | comments 
----+----------------------+---------+------------+----------
    | Vir                  | morning | 2017-10-23 | Peaceful

---

End Mini Tutorial

---

Is any of this helpful? Or am I thinking too deeply or just confusing you?