I want to copy a text that is located within a specific rang

[aslofke]

Hi everyone
I would appreciate it if you could assist me with the situation that I need to solve, as I have described below.

User: name surname (sometimes this field can be long) - 123456 (member number with same number of digits) -

Machine: product name model (sometimes this field can be long and have many words) - 123456 (product number with same number of digits) -



I want to copy the name, surname, and member number from the two lines above and paste them into the designated fields below as name and product number. To do this, I need to copy the text between the ':' and '-' symbols and the text between the '-' symbols separately and paste them into my clipboard. I haven't been able to figure out how to do this, so can you help me?

[philranger]

Hello,

Mini Mouse Macro doesn’t have powerful text search features (to say the least)

My workaround would be to copy the texts first in excel if you want to do a batch job, or first paste them in a notepad, use the search feature of the notepad.

From your example, I would
-paste in a notepad
- ctrl-f (find) for « : »
- escape
- ctrl-shift-home (select til beginning of line)
- delete (you may need to do twice to remove the « : » as well
- search for -
- ctrl-shift-end (select til end of line)
- delete
- ctrl-a (select all)
- copy

Or something roughly similar

Easier: copy and paste everything in excel and use excel functions to isolate what you need

Hoping this helps!