People, I hope you understand that this is a special situation. This is a question that doesn't follow the rules, but right now the world is a mess and I really need someone to be able to help me. Fill me with negatives if you want, but don't close the question.
I work at the Ministry of Security of the Province of Buenos Aires and we handle any complaints regarding COVID-19 by hand. The problem is that this virus is growing exponentially, which is why our work is also growing, and we are behind with the statistics, partly because of this, the known number on cases is less than this that it really is. Without further ado, I will show you what I have:
We received a .doc file (ask in the chat before asking the question here, and they asked me for the version of Word. In fact, we are working with different versions, I have the latest version at home because I'm a student and MS always gives it and updates it), but at work I have 2010, I think the version can be indifferent since I want to work with text, I could even copy it and take it in a notepad for example)
This .doc file contains about 100 texts which have more or less this form
Illicit Investigation – Illicit Point (COVID-19 Coronavirus) – Senior Female
03/19 – PU.81027 – Student 07:06hs – CP Campana; 05: 00hs. he
received a call to XXXX (Dda. XXXX 1000), realizing that his neighbor
XXX, eve of return Brasil, not respecting
isolation protocol. Staff continued to provide
corresponding telephone numbers for these cases, informing
Each of these texts must be transmitted to a table in a database, which includes about 20 fields. I would at least be able to get the 3 data that I put in bold, which is, the urgent part number, which is always after
PU., the hour, which is always the one after the word
alta, and in case there is a country or continent name, extract it (only the first appearance, as it could mean that the person came from Brazil and was previously in Germany)
If you don't know how to do it but you know the tools that can do it, it would also be of great help
The point is, we run them by hand, and this virus grows by leaps and bounds with it, and we can't load it.
The idea is that each new text (could be identified by the appearance of the string
PU.) create a new row (it can be in an Excel or Access table, whatever) and put these 3 fields.
I hope you understand an exceptional question at an exceptional time. Be careful, don't leave your homes. This is not a joke.