631239_en-US

liliconcom

remove different pattern of strings from log in one formula

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)?

Re: remove different pattern of strings from log in one formula

If you have working solution, you can combine all of those into single formula by chaining those expressions. 

Substitute(Regex(Substitute(str, "!", "")," ", "", GLOBALREPLACE), "123", "");

or using variables 

str1 = Substitute(str, "!", "");
str1 = Regex(str1, " ", "", GLOBALREPLACE);
Substitute(str1, "123", "");

I also attached data table with the formulas