@nrgiser, perhaps this will illustrate how to use RegEx to lookup a keyword and return the data you have set for it.
Please let us know if this works for you.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Example Output
MACRO: Replace Text with Numbers (or, Lookup Data Using RegEx) [Example)
**Requires: KM 8.2.4+ macOS 10.11 (El Capitan)+**
(Macro was written & tested using KM 9.0+ on macOS 10.14.5 (Mojave))
#### DOWNLOAD Macro File:
<a class="attachment" href="/uploads/default/original/3X/7/4/746cee3ef25c0d6226bbe3454f028aee4bb29785.kmmacros">Replace Text with Numbers (or- Lookup Data Using RegEx) [Example).kmmacros</a>
**Note: This Macro was uploaded in a DISABLED state. You must enable before it can be triggered.**
---
### ReleaseNotes
Author.@JMichaelTX
**PURPOSE:**
* **Lookup Keyword and Return Data**
**HOW TO USE**
1. First, make sure you have followed instructions in the _Macro Setup_ below.
2. Trigger this macro.
**MACRO SETUP**
* **Carefully review the Release Notes and the Macro Actions**
* Make sure you understand what the Macro will do.
* You are responsible for running the Macro, not me. ??
.
**Make These Changes to this Macro**
1. Assign a Trigger to this macro.
2. Move this macro to a Macro Group that is only Active when you need this Macro.
3. ENABLE this Macro, and the Macro Group it is in.
.
* **REVIEW/CHANGE THE FOLLOWING MACRO ACTIONS:**
(all shown in the magenta color)
* SET Source String
* Enter you data as: `KeyWord<tab>Data`
* where "`<tab>`" is the TAB key
**REQUIRES:**
1. **KM 8.2.4+**
2. **macOS 10.11.6 (El Capitan)+**
TAGS: @RegEx @Lookup @Example
USER SETTINGS:
* Any Action in _magenta color_ is designed to be changed by end-user
ACTION COLOR CODES
* To facilitate the reading, customizing, and maintenance of this macro,
key Actions are colored as follows:
* GREEN -- Key Comments designed to highlight main sections of macro
* MAGENTA -- Actions designed to be customized by user
* YELLOW -- Primary Actions (usually the main purpose of the macro)
* ORANGE -- Actions that permanently destroy Variables or Clipboards,
OR IF/THEN and PAUSE Actions
**==USE AT YOUR OWN RISK==**
* While I have given this a modest amount of testing, and to the best of my knowledge will do no harm, I cannot guarantee it.
* If you have any doubts or questions:
* **Ask first**
* Turn on the KM Debugger from the KM Status Menu, and step through the macro, making sure you understand what it is doing with each Action.
<img src="/uploads/default/original/3X/5/2/5239a763c83dce1d9ab750e884c7bf10d6c64f23.png" width="638" height="1123">