Break down the specification into algorithmic steps.
1. Extract m from input value. This is the value to the left of the "+" and to the right of the "(".
2. Decode m to month name.
You can do each of these in stage variables (for example svMonthNum for the first piece), or construct a complex expression.
Code: Select all
svMonthNum <== Field(Field(InLink.TheValue, "(", 2, 1), "+", 1, 1)
Field("Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec", "|", svMonthNum, 1)