first match in ... of ... calculated per-episode

This function is the same as first match in … of … except that the regular expression is calculated for each episode. For example, suppose that we have a Knowledge Base in which there are attributes Measurement, TrialName and Units. Then we could define a calculated value Amount with expression:

first match in Measurement of (TrialName append ” ([0-9]+)” append units) calculated per-episode

For a case such as this:

                    01 Jun 03         20 Jun 03         02 Nov 03
Measurement            gluc100 10g       gluc200 12g       ethanol50 5ml
TrialName              gluc100           gluc200           ethanol50
Units                  g                 g                 ml

the values for Amount would be:

                    01 Jun 03         20 Jun 03         02 Nov 03
Amount                 10                12                5

The search for the matching text is case sensitive.

Note: this function makes advanced use of regular expressions. For more help, please contact PKS.