B
B
blankstudio2021-02-24 09:51:01
Regular Expressions
blankstudio, 2021-02-24 09:51:01

How to replace regular expressions?

I have an excel file with a huge (~10.000) number of cells, each with a line of text. Each line specifies a day and a title. This line has a certain format:

"Financial analytics" - means that financial analytics will be held every week

"1,3,5 n Monitoring" - means that Monitoring will be only on 1,3 and 5 weeks of the current month

"cr 2 n Finance " - means that the Finance will be held every week this month, except for the 2nd week.

And a number of such designations and their combinations.

The task is to extract useful data from such lines:

Array of weeks, if specified
Whether the designation "Except" is specified
Name
And so on

The problem is that sometimes it's all edited by a person, hence the constant typos, departure from the structure, and so on.
Now a regular expression is used, but its length has become too long and it has become difficult to maintain. There is a feeling that neural networks can handle this, since a person calmly determines the meaning of a line and it is always interpreted unambiguously, but I have a rather poor idea about this, so I ask you if this is so. I would also be grateful for a hint that you can read and look at this topic, since everything that I found, unfortunately, has so far turned out to be useless. Thanks in advance for any replies!

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question