Numeric to Date Conversion

ray.wurlod · Post by **ray.wurlod** » Thu Aug 03, 2006 1:01 am

You would have helped yourself by creating a written specification. Your input data is of the form "CD(m+n) yyyy" and what you want out of this is the month name corresponding to m. Is this correct?

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)

kksr · Post by **kksr** » Thu Aug 03, 2006 1:36 am

Yes your correct Ray.

ray.wurlod · Post by **ray.wurlod** » Thu Aug 03, 2006 1:59 am

It has since occurred to me that step 1 (extraction of the month number) could readily be achieved with a MatchField() function.

Code: Select all

MatchField(InLink.TheValue, "0X'('0N'+'0X", 3)