REMOVE section is responsible for situations when we want to see with our own eyes those elements that we found, unlike FIND tools, where the result is not the object found but binary (TRUE / FALSE).
The section contains 4 menus:
With !SEMTools you can extract either specific characters:
Or a sequence of characters:
Extract first N characters
Extract the last N characters
Extract characters to the first occurrence of the pattern
Extract characters after the last occurrence of the pattern
Maximum attention was paid to these tools while creating the addin.
You can extract words from cells based on multiple criteria:
Full words – exact single words and own words lists and in
Words containing pattern or one of a list of patterns –
– in the beginning of the words
– in the ending of the words
– anywhere in the words
You can also match words with LIKE and REGEX pattern syntax.
You can extract words based on their order in the cell –
– extract first, first 2 or any N words from start of cell;
– same 1, 2, 3 or N words from end of cell
Sometimes you need to extract words with capital letters – there’s a tool for that, too.
This group of tools if for situations when cell contains stay the same, but only cells matching specific criteria stay, all others become blank. Macros mostly do the same as those for word manipulation, but operate with full cell contens.
This menu helps with obtaining statistical data:
– Counting pixel length of strings, including bold chars
– Counting symbols in cells
– Counting words in every cell