Hi Carlos,
pls find the script for my suggestion:
Input:
LOAD * Inline [
MyDate
Miércoles 22 de Mayo del 2013
];
Tmp:
LOAD
SubField(MyDate, ' ', 2) AS Day,
SubField(MyDate,' ', 4) AS Month,
Right(MyDate,4) AS Year
Resident Input;
// now use mapping table to perform Month-Number:
MonthMap:
Mapping
LOAD * Inline [
From, To,
Mayo, 5
];
// Create the DateColumn:
LOAD
MakeDate(Year, ApplyMap('MonthMap', Month), Day) AS ThisIsTheDate
Resident Tmp;
DROP Table Input, Tmp;
HtH
Roland
P.S.:
Of course is it possible to bring some steps into one to shorten the script.
