Macro: Extract Event Data from Text; Calc Days Diff, Reformat Results [Example]

Continuing the discussion from Altering Date Formatting:

Example Results

image

MACRO:   Extract Event Data from Text; Calc Days Diff, Reformat Results [Example]

~~~ VER: 1.1    2019-02-18 ~~~

DOWNLOAD:

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.


ReleaseNotes

Author.@JMichaelTX

PURPOSE:

  • Extract Event Data from Text; Calc Days Diff, Reformat Results

REQUIRES:

  1. KM 8.2+
  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

  1. Trigger this macro to run using example data

OR

  1. Change Setup to Copy Selection (see below)
  2. Select Event Data
  3. 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. ??
      .
  1. Assign a Trigger to this maro..
  2. Move this macro to a Macro Group that is only Active when you need this Macro.
  3. 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)
    • OR
    • Enable GRP to Copy selection
    • Disable Set Local__SourceStr Action

TAGS: @RegEx @JavaScript @JXA @DateMath

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 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.

image