Join the Conversation
- Find Answers
- :
- Using Splunk
- :
- Splunk Search
- :
- Re: Extract a string
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark Topic
- Subscribe to Topic
- Mute Topic
- Printer Friendly Page
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi we log the data in splunk as below
2013-01-07 09:37:35.556935 client="rmf-rm3d"|jobRunId="1504312"|salesforceId="null"|JobDurationSecs="183.561"|description="null"|processid="bzghn-3i8-4hg7"|schedulerId="id.20130107_093409.rmf-rm3d.rm3d.1375765"|numberOfCompletedSteps="9"|positionsProxied="27"|client="rmf-rm3d"|reportsCount="0"|portfoliosSplit="1"|parts="Import"|reportsSize="0"|positionsAttempted="520"|jobName="rm3d"|autoSysID="1375765"|............
we have a field called controlFiles="m_ifs_swr_d_1.20130103.cntl.txt"
I have the query to extract the control file as its a variable but what I want is just the 1st part
m_ifs_swr_d_1 and not 20130103.cntl.txt.
now the 1st and the 2nd part are not of fixed length but can be maximum 3
what I mean is the format for the control file is
now filename can be part1 or part2 or part3 usually its two parts. but the only constant in the format is
how can I achieve this.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you only want the text up to, but not including the first dot (.) - which seems to be the pattern here - you can do it inline through a rex statement.
your search | rex field = controlFiles "(?<ctrlfile>[^.]+)\." | the rest of your search
That gives you a new field called ctrlfile that only contains the first part.
If you want the field to contain everything (including dots) but date.cntl.txt, you could try:
your search | rex field = controlFiles "(?<ctrlfile>.*)\.\d{10}\.cntl\.txt" | the rest of your search
You probably understand how to take if from here if these patterns are not correct. If not, ask for a clarification.
Hope this helps,
Kristian
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello
Here you have another option:
Regular Expression:
controlFiles="(?
Splunk Command:
... | rex field = controlFiles "controlFiles="(?
I tried it with RegExRX and it works for me
Try it and let me know if it doesn´t work for you
Regards
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you only want the text up to, but not including the first dot (.) - which seems to be the pattern here - you can do it inline through a rex statement.
your search | rex field = controlFiles "(?<ctrlfile>[^.]+)\." | the rest of your search
That gives you a new field called ctrlfile that only contains the first part.
If you want the field to contain everything (including dots) but date.cntl.txt, you could try:
your search | rex field = controlFiles "(?<ctrlfile>.*)\.\d{10}\.cntl\.txt" | the rest of your search
You probably understand how to take if from here if these patterns are not correct. If not, ask for a clarification.
Hope this helps,
Kristian
Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!
Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.
Automating Threat Operations and Threat Hunting with Recorded Future
Keep the Learning Going with the New Best of .conf Hub
Splunk Community Badges!
