topic Extracting Field using Regexes in Splunk Search

Extracting Field using Regexes

sbnoobbb — Thu, 04 Jul 2013 06:12:13 GMT

I have extracted the latitude using this (?i).Double">(?P[^<]+ , but i could not extract the longitude as both shares the double. Anyway that I can extract longitude ?

<updated>2013-07-04T06:03:39Z</updated>
<author>
  <name />
</author>
<link rel="edit" title="Nowcast" href="NowcastSet(1310755)" />
<category term="NEAModel.Nowcast" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<content type="application/xml">
  <m:properties>
    <d:NowcastID m:type="Edm.Int32">1310755</d:NowcastID>
    <d:Area>Yishun</d:Area>
    <d:Condition>Rain</d:Condition>
    <d:Latitude m:type="Edm.Double">1.42738834</d:Latitude>
    <d:Longitude m:type="Edm.Double">103.8290405</d:Longitude>
    <d:Summary>Rain</d:Summary>
    <d:Distance m:type="Edm.Double">0</d:Distance>

Re: Extracting Field using Regexes

gfuente — Thu, 04 Jul 2013 06:43:02 GMT

Hello

You can use those Regexes:

< d:Latitude m:type="Edm.Double">(?<Latitude>\d+\.\d+)< /d:Latitude>
< d:Longitude m:type="Edm.Double">(?<Latitude>\d+\.\d+)< /d:Longitude>

*Remove the blanks after the angle bracket
Regards

Re: Extracting Field using Regexes

sbnoobbb — Thu, 04 Jul 2013 07:17:02 GMT

I have used this and it works 😃 Thanks anyway !

(?[^<]+)</d:Longitude