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!

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

🍂 Fall into November with a fresh lineup of Community Office Hours, Tech Talks, and Webinars we’ve ...

Transform your security operations with Splunk Enterprise Security

Hi Splunk Community, Splunk Platform has set a great foundation for your security operations. With the ...

Splunk Admins and App Developers | Earn a $35 gift card!

Splunk, in collaboration with ESG (Enterprise Strategy Group) by TechTarget, is excited to announce a ...