topic Re: Convert text to date in QlikView

Convert text to date

Anonymous — Mon, 14 Jul 2014 18:20:41 GMT

Miércoles 22 de Mayo del 2013

Jueves 23 de Mayo del 2013

Viernes 24 de Mayo del 2013

Sábado 25 de Mayo del 2013

Domingo 26 de Mayo del 2013

Lunes 27 de Mayo del 2013

Martes 28 de Mayo del 2013

Miércoles 29 de Mayo del 2013

I don´t know how to Covert: TEXT ----> (Miércoles 22 de Mayo del 2013) to this format -----> ('DD/MM/YYYY')=(22/05/2013)

in qlikview.

Can somebody help me please !!!

Thanks!!!

Re: Convert text to date

pgrenier — Mon, 14 Jul 2014 18:35:48 GMT

Hello Carlos,

Please refer to Convert text to date

Regards,

Philippe

Re: Convert text to date

Mon, 14 Jul 2014 18:43:11 GMT

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.

Re: Convert text to date

Anonymous — Mon, 14 Jul 2014 19:12:29 GMT

Thanks for you support Roland