Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
Maybe you can use KeepChar function in the example below it loads only numerical symbols
KeepChar ( YourField, '1234567890' )
Regards,
Vitalii
Hi Vchprina,
I have tried above formula and but it did not work for me. Is there any other way?
Could you please share an example of your data?
Hi Vchuprina,
Sorry, I cannot share the data as it is confidential.
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
If( Len(Num(Field))=5 , 'Date', 'String')