<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic How to Extract the files - each line has different formats in Splunk Dev</title>
    <link>https://community.splunk.com/t5/Splunk-Dev/How-to-Extract-the-files-each-line-has-different-formats/m-p/298805#M3801</link>
    <description>&lt;P&gt;I want to Extract the below ,&lt;/P&gt;

&lt;P&gt;2018-01-08T04:43:00,700|[http-nio-9094-exec-10]|INFO|VM1|com.alb.bps.retrieval.service.DocumentRetrievalServiceImpl|DA4885B49C8376878C57DB952FD84E39|99aee0b4-f912-4526-a9af-6fb9c27c5fe0|USER1|Normal|IBD1|com.alb.bps.retrieval.service.DocumentRetrievalServiceImpl| DocId = 1470| Execution Time : 6097milliseconds&lt;/P&gt;

&lt;P&gt;2018-01-08T05:01:03,183|[http-nio-9094-exec-7]|INFO|VM2|com.alb.bps.retrieval.service.DocumentRetrievalServiceImpl|01D362DD96D7E608E83023B02D5B9508|67a81da1-3810-4c66-9ce7-eb9c9732f8ea|null%40null|USER2|Normal|IBD2|com.alb.bps.retrieval.service.DocumentRetrievalServiceImpl| DocId = 1473| Execution Time : 715milliseconds&lt;/P&gt;

&lt;P&gt;i m using the below syntax for extration, but it is not working as properly.&lt;/P&gt;

&lt;P&gt;and also i want to extract the Execution time only for numbers i dont want to include the word milliseconds.&lt;/P&gt;

&lt;P&gt;Can you please advice.&lt;BR /&gt;
^(?P[^:]+)(?:[^|\n]&lt;EM&gt;|){3}(?P\w+)(?:[^|\n]&lt;/EM&gt;|){4}(?P[^|]+)|\w+|(?P[^|]+)[^ \n]* (?P[^|]+)[^:\n]*:(?P\s+\d+[a-z]+) &lt;/P&gt;</description>
    <pubDate>Tue, 09 Jan 2018 08:34:01 GMT</pubDate>
    <dc:creator>rajeswariramar</dc:creator>
    <dc:date>2018-01-09T08:34:01Z</dc:date>
    <item>
      <title>How to Extract the files - each line has different formats</title>
      <link>https://community.splunk.com/t5/Splunk-Dev/How-to-Extract-the-files-each-line-has-different-formats/m-p/298805#M3801</link>
      <description>&lt;P&gt;I want to Extract the below ,&lt;/P&gt;

&lt;P&gt;2018-01-08T04:43:00,700|[http-nio-9094-exec-10]|INFO|VM1|com.alb.bps.retrieval.service.DocumentRetrievalServiceImpl|DA4885B49C8376878C57DB952FD84E39|99aee0b4-f912-4526-a9af-6fb9c27c5fe0|USER1|Normal|IBD1|com.alb.bps.retrieval.service.DocumentRetrievalServiceImpl| DocId = 1470| Execution Time : 6097milliseconds&lt;/P&gt;

&lt;P&gt;2018-01-08T05:01:03,183|[http-nio-9094-exec-7]|INFO|VM2|com.alb.bps.retrieval.service.DocumentRetrievalServiceImpl|01D362DD96D7E608E83023B02D5B9508|67a81da1-3810-4c66-9ce7-eb9c9732f8ea|null%40null|USER2|Normal|IBD2|com.alb.bps.retrieval.service.DocumentRetrievalServiceImpl| DocId = 1473| Execution Time : 715milliseconds&lt;/P&gt;

&lt;P&gt;i m using the below syntax for extration, but it is not working as properly.&lt;/P&gt;

&lt;P&gt;and also i want to extract the Execution time only for numbers i dont want to include the word milliseconds.&lt;/P&gt;

&lt;P&gt;Can you please advice.&lt;BR /&gt;
^(?P[^:]+)(?:[^|\n]&lt;EM&gt;|){3}(?P\w+)(?:[^|\n]&lt;/EM&gt;|){4}(?P[^|]+)|\w+|(?P[^|]+)[^ \n]* (?P[^|]+)[^:\n]*:(?P\s+\d+[a-z]+) &lt;/P&gt;</description>
      <pubDate>Tue, 09 Jan 2018 08:34:01 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Dev/How-to-Extract-the-files-each-line-has-different-formats/m-p/298805#M3801</guid>
      <dc:creator>rajeswariramar</dc:creator>
      <dc:date>2018-01-09T08:34:01Z</dc:date>
    </item>
    <item>
      <title>Re: How to Extract the files - each line has different formats</title>
      <link>https://community.splunk.com/t5/Splunk-Dev/How-to-Extract-the-files-each-line-has-different-formats/m-p/298806#M3802</link>
      <description>&lt;P&gt;Hi rajeswariramar, &lt;/P&gt;

&lt;P&gt;please give this a look.&lt;/P&gt;

&lt;P&gt;&lt;A href="https://regex101.com/r/Z10lQg/3/"&gt;https://regex101.com/r/Z10lQg/3/&lt;/A&gt;&lt;/P&gt;

&lt;P&gt;You can easily ajust this to your requirements. If you need more help, tell me.&lt;/P&gt;</description>
      <pubDate>Tue, 09 Jan 2018 12:58:54 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Dev/How-to-Extract-the-files-each-line-has-different-formats/m-p/298806#M3802</guid>
      <dc:creator>horsefez</dc:creator>
      <dc:date>2018-01-09T12:58:54Z</dc:date>
    </item>
  </channel>
</rss>

