Getting Data In

SEDCMD trouble- How to delete vfwew from field account?

bosseres
Contributor

Hello everyone!

I'm trying to make props file which will trim all not cyrillic symbols from field "account"

My log example is 

18:10:24 Object="some object" Source="some source1323" Account="Аккаунтvfweцw"

i want to delete vfwew from field Account, but note that symbols can go in any order and with cyrillic symbols too, i need to catch them all and delete, only from one field

SEDCMD-notcyr - Account="....

 

Labels (3)
0 Karma

PickleRick
SplunkTrust
SplunkTrust

There is no way to do it with just a SEDCMD. The y command would match character class anywhere in the event and with s command you can't either restrict matching to a specific field (there is no notion of fields at this point at all) or match (for substitution) a string with holes in it.

Gr0und_Z3r0
Contributor

hi @bosseres 

Try something like this...

Gr0und_Z3r0_0-1680419020003.png

 

| makeresults 
| eval Account="Аккаунтvfweцw"
| rex field=Account mode=sed "s/[^А-Яа-я]+//g"
| table Account


~ If the reply helps, a Karma upvote would be appreciated

Get Updates on the Splunk Community!

Observability Release Update: AI Assistant, AppD + Observability Cloud Integrations & ...

This month’s releases across the Splunk Observability portfolio deliver earlier detection and faster ...

Stay Connected: Your Guide to February Tech Talks, Office Hours, and Webinars!

💌Keep the new year’s momentum going with our February lineup of Community Office Hours, Tech Talks, ...

Preparing your Splunk Environment for OpenSSL3

The Splunk platform will transition to OpenSSL version 3 in a future release. Actions are required to prepare ...