Hello, I have a lookup file with data in following format
name _time srv-a.xyz.com 2017.07.23 srv-b.wxyz.com 2017.07.23
I want to replace .xyz.com with wxyz.com
My replace query does this c...
Hello world, I'm trying to use rex to rename the part of the strings below where it says "g0" to "GRN". So the output would read 01-GRN1-0, 01-GRN2-0etc. I have been unable to get it to work and any...
Hello, I need to remove the values found (string) from another field. Ex. FIELD1 - abcmailingxyz LIST - mailing, ... Using | eval foundIt=if(match(FIELD1,$LIST$),"X",".") I am able to...
Hi
Has anyone seen this before, I'm using DB connect to pull data in from a MySQL db, and this is the results shown in the data lab
but the raw events have the training zero's replaced w...
...ields using rex command command and not able to move further on how to replace the value in the query . Any help would be appreciated. Thanks in advance. Harris
...3d6e06734ae
}
I want to replace the ids into https://mywebsite/v1/organization/{id}/buildings
I tried {base search string} | eval endpoint=replace(properties.url, "\d+", "{id}") | stats by endpoint&n...
Hi all, I have an alert that looks for a specific message that includes the record ID. I would like to be able to create a numeric value for that ID that could be used to create a unique ID when ra...
Hi guys, I'm trying to replace values in an irregular multivalue field. I don't want to use mvexpand because I need the field remains multivalue. Here some examples of my multivalues fields #1 1...
I have a query to display following 3 fields | table pp_user_action_name,Today_Calls,Avg_today i want to replace 'Avg_today' column header with today's date like '11/1/2023' is it p...
...d}
wapi/v3/gat/{Id}/cust/api
Basically in the fields , it should only take alphapets (including that v3) and we should replace digits to {Id} whereever it exist .
Can someone h...