topic Re: help with regex for masking? in Getting Data In

help with regex for masking?

abi2023 — Thu, 15 Jan 2026 00:10:02 GMT

I need to mask data before it being index. my sample his log structure.

"2023-11-02 06:53:00 xx.xxx.xxx.xx GET /Security/Security/Logon 123 - xx.xxx.x.xxx Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64)+AppleWebKit/537.36+(KHTML,+like+Gecko)+Chrome/86.0.4240.198+Safari/537.36=RDPword=jsndksjs834u935=PDUserId=jsndksjs834u935=PDPword=jsndksjs834u935=RFuser=&securityToken=xxxxxxxx 200 0 0 14"

I need to match highlights in green "RDPword=jsndksjs834u935", and "PDPword=jsndksjs834u935"

I am using regex this matching the following which I don't want it match "PDUserId=jsndksjs834u935="

RDPWord=([^=]+)=PDUUserId=([^=]+)=PDPWord=([^=]+)

Can someone help me

Thanks

Re: help with regex for masking?

richgalloway — Mon, 26 Feb 2024 18:50:42 GMT

Regex is very case-sensitive. This matches the sample event.

RDPword=([^=]+)=PDUserId=([^=]+)=PDPword=([^=]+)

Re: help with regex for masking?

abi2023 — Mon, 26 Feb 2024 19:33:21 GMT

my following regex is matching "RDPword=jsndksjs834u935=PDUserId=jsndksjs834u935=PDPword=jsndksjs834u935"

I want to exclude follwing "=PDUserId=jsndksjs834u935=" how do I modify the this rex to not match =PDUserId=jsndksjs834u935=
RDPword=([^=]+)=PDUserId=([^=]+)=PDPword=([^=]+)

RDPword=([^=]+)=PDUserId=([^=]+)=PDPword=([^=]+)

Re: help with regex for masking?

PickleRick — Mon, 26 Feb 2024 22:28:46 GMT

If you just want a regex which you can use with SEDCMD, just match each part separately and substitute with nothing. And you can use the same match several times to match and substitute all matching strings.

s/[RP]DPword=[^=]+//g