3 Replies Latest reply on Oct 12, 2018 3:59 AM by Dipankar Roy

    How to create date pattern filter?

    Patrick Weber

      Hi folks,

      here is my issue:

      I have a column with more than 500k date entries in string format like "yyyy/MM/dd HH:mm:ss" but there are also some entries which aren't dates.

       

      How I can create a function where I can say: Don't show me entries which don't fit into the pattern "yyyy/MM/dd HH:mm:ss"

       

       

      In this small example the function should show me only the dates

       

      ID   Log

      60    2017/02/15 16:22:17

      70    2017/02/15 16:19:11

      80    another test

      100   test

      101   abcdef

      102   2017/02/15 16:23:53

       

      Do you have any advice or tip for me?

      Thanks in advance.