identify month name from field value

[ericdelaqua]

Hello,

I have a field(filename) that holds values which contain the month information (Posted in march ). I would like to derive a new month field by identifying the month value in the filename field. sample filename field values are below.

filename

posted in march

May posting

was sen in august

posted in April

Expected result

Month

March

May

August

April

Thanks

Eric

[tresesco · Accepted solution]

Many ways could be there. One is like:

Load *,
              Month(MakeDate(1,WildMatch(Upper(filename),                   '*JAN*','*FEB*','*MAR*','*APR*','*MAY*','*JUN*','*JUL*','*AUG*','*SEP*','*OCT*','*NOV*', '*DEC*'))) as Month
Inline [
filename
posted in march
May posting
was sen in august
posted in April]