ETransL Technical: Update MetaData

ETransL Technical: Update MetaData

Quick overview

This module is invoked by all Operations except?SK?(which does nothing). The invocation takes place before the actual operation is evaluated.

It evaluates the?MetaData?string, and replaces any reference to a Title within the Template with its data. The RegEx pattern the solution looks for is '<;<(.+)>;>'. There can be multiple Titles.

The module looks up Titles that precede the one being processed. If a Title is not found, the string is treated literally and a warning is written to the log file.


Example

No alt text provided for this image
<;<Fare_1912>;> x <;<Inflation>;>        

Before Operation?CO?is evaluated, this module will replace?<;<Fare_1912>;>?and?<;;>?with the results obtained in those Titles.

If the result of Title?Fare_1912?was 7.63 and the result for?Inflation?was 29.98, the MetaData string would be updated as shown below before the module related to Operation?CO?is called.

7.63 x 29.98        


Flow Diagram

No alt text provided for this image


Solution walk through

  • For each RegEx pattern '<;<(.+)>;>' match
  • Extract the Title from the MetaData pattern
  • Search the Title in the list of previously computed entries
  • If a match is found, substitute that pattern with the value associated with that Title
  • If no match is found, write to the log file that the pattern will be treated literally

Return to the calling module the adjusted MetaData string.


Join the effort ,;, Use the tool ,;, Spread the word
??Project Source and more @:?https://www.github.com/chribonn/ETransL


要查看或添加评论,请登录

Alan Bonnici的更多文章

  • GTL: Three Digital Sanctuaries for your Wellness Journey

    GTL: Three Digital Sanctuaries for your Wellness Journey

    The lengthening days mirror our expanding possibilities, particularly in areas of personal growth that may have taken a…

  • We all make mistakes

    We all make mistakes

    The incident taught me several lessons, but most importantly: check your statements regularly. Had I not caught this…

  • The Golden Days of Long Gone By

    The Golden Days of Long Gone By

    His life was deeply rooted in his family, animals, and land. His workday began at dawn with the rising sun and ended…

  • YokaTV KB2 Pro Upgrade

    YokaTV KB2 Pro Upgrade

    Introduction I received a functioning YokaTV KB2 Pro, an Android TV box released in 2016. This device is powered by an…

    1 条评论
  • The Halloween Wish

    The Halloween Wish

    In a quaint garden nestled amidst an array of vibrant vegetables, a small courgette seed lay in the earth next to its…

    1 条评论
  • Complacency

    Complacency

    We've all experienced adolescence. For some, it may have been relatively recent, while for others, teenage years are a…

  • bnkSEPA : Excel to SEPA Credit Transfers (SCTE) Electronic Payment Engine

    bnkSEPA : Excel to SEPA Credit Transfers (SCTE) Electronic Payment Engine

    Last update: 202205 Version - 1.37.

  • ETransL Technical: Process Transactions

    ETransL Technical: Process Transactions

    Quick overview The module performs the transformation. Each row in the transactions file will correspond to an appended…

  • ETransL Technical: Load and Validate the Template Workbook March 27, 2022

    ETransL Technical: Load and Validate the Template Workbook March 27, 2022

    Quick overview The template workbook is the document that drives the ETransL engine. It is possible to have different…

  • Technical: ETransL High Level Technical Overview

    Technical: ETransL High Level Technical Overview

    ETransL execution is as follows: Initialises the environment, reads from the Inputs Worksheet the inputs and logs…

社区洞察

其他会员也浏览了