How to automate?

Question

Yii

Hello! There is such a table with 3 thousand streets:

They are written in the following format: Yubileinaya st
. Need to get: st. Anniversary
Is it possible to somehow automate this process so as not to manually rewrite all 3,000?

Answer 1

You can create a table and manually drive in there, for example, popular vacancies, then do logging of user requests, and enter the most frequently repeated ones into this table, either automatically or manually.

Answer 2

The algorithm is simple:
1. The user's search string
2. We memorize the word tree of the search string: we write each word and its connections with others in a separate table. If there are already such, we add weights: both to the word itself and to the links.
3. When they start typing, we make a selection with weight sorting and display a hint. If the difference in the weights of the next word, relative to all the others, is quite small, then it is displayed in a regular font. Otherwise, bold.
4. A hint of the next word with input repetitions of less than 20% relative to the largest number of repetitions of any one word (from the list of all words) - DO NOT OUTPUT!

Answer 3

1. In any free column to the right of the "Name" column, in the second line, write
2. Stretch the formula over the entire height of the data (the easiest way is to put the cursor in column D on the bottom line with data, go to the column where the formula was entered in the second line, hold down shift, hold down ctrl, press the up arrow, release everything, press Ctrl + D ), but you can also use the mouse, although you are tormented, or copy-paste.
It will look something like this (in the example, the cell addresses are different, but the essence is the same):
As a result, we get to the right of the "something st" column the "st something" column.
3. We copy the entire resulting column, paste it in place of the original one through "paste special \ paste values" (so that not formulas are inserted, but resulting values)
4. We erase the column that has become unnecessary to the right of "Name".