topic Re: How to pick only date from text field in QlikView

How to pick only date from text field

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

We have a weird scenario where in one field they have entered the date as well as some text alone with date. Example:-

Current Date

8/8/2016

9/8/2016

Request on 10/08/2016

Request on 11/08/2016

appreciate your ideas and tricks on the give scenario.

Re: How to pick only date from text field

saimahasan — Tue, 09 Aug 2016 11:52:40 GMT

You can use

KeepChar(Current Date,'0123456789/')

Re: How to pick only date from text field

Chanty4u — Tue, 09 Aug 2016 11:54:54 GMT

try this

purge:

LOAD * INLINE [

Current Date

8/8/2016

9/8/2016

Request on 10/08/2016

Request on 11/08/201

];

LOAD KeepChar ([Current Date],'1234567890/') as new

Resident purge;

try same

purge:

LOAD * INLINE [

Current Date

8/8/2016

9/8/2016

Request on 10/08/2016

Request on 11/08/201

];

LOAD PurgeChar ([Current Date],'abcdefghijklmnopqRstuvwxyz') as new

Resident purge;

Re: How to pick only date from text field

its_anandrjs — Tue, 09 Aug 2016 12:02:57 GMT

You can do this way also

Data:
LOAD * Inline
[
Current Date
8/8/2016
9/8/2016
Request on 10/08/2016
Request on 11/08/2016
];

New:
LOAD
*,Right([Current Date],10) as NewDate
Resident Data;

Regards,

Anand

Re: How to pick only date from text field

its_anandrjs — Tue, 09 Aug 2016 12:06:51 GMT

Also you can create the correct date format for the fieldNewDate

Date#( Right([Current Date],10),'MM/DD/YYYY') as NewDate

Regards

Anand

Re: How to pick only date from text field

Anonymous — Tue, 09 Aug 2016 13:47:38 GMT

Thank you all for your prompt reply. It seems the keep char is most preferred than purge char but both is good workaround.Thanks for quick reply.

Re: How to pick only date from text field

Chanty4u — Wed, 10 Aug 2016 04:28:38 GMT

nice please close this thread by making helpful/correct answers