Hi
I want to remove few patterns of string from log.
example of log:
[01/19/23 04:06:37 PM] [INFO ] [text.text:__text__:():280]: [ 25.053966] text: text text text:
[ 19.620450] text_text 0000:42: text 2 [text text text 0x2045ffff] 0x0aa00100f
Patterns I want to remove or replace with "":
1) all special characters
2) date and time
3) any hex or strange address number like x2045ffff or 0x0aa00100f
the way I'm doing now is using substitute or regex to remove one type by one type (1-3), so I have 3 columns created. is it possible to combine all in one formula (one column)?