Getting Data In

Splitting a fields values into a seperate field by a third field

vanceinc
New Member

I want to be able to split the TID field into two new fields (Ingress_TID and Egress_TID) by correlating against the OMS_ID which is the same ID number for both.  

Example data:

 

TID                                      PORTAID                  OMSID

BLTNMNFSWP0011/7oms-100483
MNNTMNICWP0013/13oms-100483

 

in the end want it to transform to 

Ingress_TID                               Egress_TID                         PORTAID             OMSID
BLTNMNFSWP001                                                                      1/7                     oms-100483

                                                      MNNTMNICWP001               3/13                  oms-100483

Any help would be great.  Thank you!!

Labels (1)
0 Karma

isoutamo
SplunkTrust
SplunkTrust
How you are knowing which event is ingress an$ which egress?
0 Karma

vanceinc
New Member

Nothing distinctive to pin point which is which.  We could add the Ampid field and go by the lowest number as the ingress and then the highest number as egress.  

TID                                 PORTAID   AMPID      OMSID

COLNNYEJWP0011/133160113oms-100486
TROYNYDWWP0011/63380106oms-100486
Tags (1)
0 Karma
Get Updates on the Splunk Community!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

(view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...