Filter datetime and int variables in a column

Hi, in a column I have int and datetimes variables. How can I differentiate them?

@sangasangasanga Use IsNumeric function, It will return true(if it is number) or false(if it is date)

Ex: IsNumeric(urvariable)

Hi, it works. One more question if you don’t mind.
My column actually have integers, words and datetime.
I split integers. Then I tried to split the words and datetime with below code:

dateu.Any(function(x) NOT char.IsLetter(x))

but it is not splitting.
Pls help

@sangasangasanga can u give some input of words and dates and their expected outputs.

Hi @Manjuts90, thank you for your kind help.

I figured it out though.
System.Text.RegularExpressions.Regex.IsMatch(dateu,β€œ[a-zA-Z]”)

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.