Convert mmm-yyyy to yyyymm

shaminmin26 · Post by **shaminmin26** » Wed Dec 09, 2009 8:18 pm

Hi All,

How can i convert mmm-yyyy to yyyymm without using basic transformer? With parallel transformer, there is no oconv and iconv functions.

Thanks in Advance.

ray.wurlod · Post by **ray.wurlod** » Wed Dec 09, 2009 8:41 pm

Create a "lookup table" of month names (Char(36) stage variable) and use Index() function to find the month name therein. Perform simple arithmetic to get the month number. Use string manipulation to re-format.