Continuing the discussion from Altering Date Formatting:
MACRO: Extract Event Data from Text; Calc Days Diff, Reformat Results [Example]
~~~ VER: 1.1 2019-02-18 ~~~
Extract Event Data from Text- Calc Days Diff- Reformat Results [Example].kmmacros (17 KB)
Note: This Macro was uploaded in a DISABLED state. You must enable before it can be triggered.
- Extract Event Data from Text; Calc Days Diff, Reformat Results
- KM 8.2+
- macOS 10.11.6 (El Capitan)
NOTICE: This macro/script is just an Example
- It has had very limited testing.
- You need to test further before using in a production environment.
- It does not have extensive error checking/handling.
- It may not be complete. It is provided as an example to show you one approach to solving a problem.
How To Use
- Trigger this macro to run using example data
- Change Setup to Copy Selection (see below)
- Select Event Data
- Trigger this macro
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. ??
- Assign a Trigger to this maro..
- Move this macro to a Macro Group that is only Active when you need this Macro.
- ENABLE this Macro.
REVIEW/CHANGE THE FOLLOWING MACRO ACTIONS:
(all shown in the magenta color)
- Set Below to Your Source Event Data (DISABLE to Use Selection)
- Enable GRP to Copy selection
- Disable Set Local__SourceStr Action
- 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 limited 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.