How to filter on date column and only extract dates and not text in Qlik Sense Script editor using where condition

[vish123]

Hi Team,

I am loading data from excel and one of the column is Date. But it also contains some text values. so just want to load only dates and ignore text values.

Is there any function or logic to filter only dates?

[vchuprina]

Hi,

Maybe you can use KeepChar function in the example below it loads only numerical symbols 

KeepChar ( YourField, '1234567890' ) 

Regards,

Vitalii

[vish123]

Hi Vchprina,

I have tried above formula and but it did not work for me. Is there any other way?

[vchuprina]

Could you please share an example of your data?

[vish123]

Hi Vchuprina,

Sorry, I cannot share the data as it is confidential.

[vchuprina]

Can you send the structure of your field, for instance:

some text yyyy/mm/dd,  some text

yyyy/mm/dd,  some text, numeric values (but not date)

I try to understand how it looks

[anat]

If( Len(Num(Field))=5 , 'Date', 'String')