String.txt into a DATE

[#1]

Good Day,

     I have TXT.FILES naming

     TESTJUNE2012.TXT

     TESTAUGUST.TXT

     TESTJULY 2012.TXT

    anyone can give me a example how do i convert it into a DATE?

THANKS.

[prieper]

You may work with kind of mapping table:

[code]map_Dates: MAPPING LOAD * INLINE [FileName, Date

JANUARY, 1/1/2012

FEBRUARY,1/2/2012

MARCH, 1/3/2012

...];

LOAD

     *,

     APPLYMAP('mapDates', TRIM(REPLACE(REPLACE(REPLACE(FILENAME(), 'TEST', ''), '.TXT', ''), '2012', ''))     AS Date

FROM

     ...;

[/code]

HTH
Peter