generalizeDate
Return "$date$" if a string is a date format; otherwise return the input string. Useful for log obfuscation.
Usage Details
LQL Command
select generalizeDate(column) as resultCol from table
Example
Input
table
date |
---|
2017-04-11T04:32:51Z |
2017 |
LQL command
select *, generalizeDate(date) as a resultCol from table
Output
date | resultCol |
---|---|
2017-04-11T04:32:51Z | $date$ |
2017 | 2017 |