#10894
Stefan
Participant

.

Please try to find better subject lines for your threads
and use different threads for different kind of topics.

.

To do most of this, best learn Regular Expressions.

For example on:
– delete everything included in brackets (xxx) including the (brackets) themselves

Find: (.+?)
Replace:
[X] Use Regular Expressions

will match first
(xxx)
and then
(brackets)

due to the ‘?’ regex parameter.

Whereas

Find: (.+)
Replace:
[X] Use Regular Expressions

will match whole
(xxx) including the (brackets)

– – –

For [ and ]
use

Find: [.+]
Replace:
[X] Use Regular Expressions

– – –

– delete everything after the first ( in everyline, including the bracket itself

Try
Find: (.+$
Replace:
[X] Use Regular Expressions

– – –

– delete double or more spaces (not tabs) and replace them with one space

Try
Find: ~~+
Replace: ~
[X] Use Regular Expressions

(instead of ‘~’ enter an blank each)

– – –

To create a macro try to utilize
– “Macro > Start”
– do the work, here the find and replace job
– “Macro > Stop”
– “Macro > Edit” –> you will see the macro code to reuse
(you may want to read the help about e.g. “eeFindSaveHistory” and remove this from the macro)

– – –

For the other questions *I* suggest you to open different threads
for each topic to not mix up all the answers and queries and for an back.

_