AnsweredAssumed Answered

Help with Regex/Field Calculator to extract values from feed

Question asked by sjacksonesriaustralia-com-au-esridist Employee on Sep 7, 2014
Latest reply on Sep 8, 2014 by sjacksonesriaustralia-com-au-esridist

I have a GEP service pulling in bushfire incidents from a RSS feed:  NSW Rural Fire Service Current Incidents


An example of an incoming incident:

<title>Armidale Rd, Tyringham</title>
<category>Not Applicable</category>
<guid isPermaLink="false">,2014-09-08:170672</guid>
<pubDate>Mon, 08 Sep 2014 05:11:00 GMT</pubDate>
ALERT LEVEL: Not Applicable<br />LOCATION: Armidale Rd, Tyringham, NSW 2453<br />COUNCIL AREA: Clarence Valley<br />STATUS: under control<br />TYPE: MVA/Transport<br />FIRE: No<br />SIZE: 0 ha<br />RESPONSIBLE AGENCY: NSW Police<br />UPDATED: 8 Sep 2014 15:11
<georss:point>-30.2425 152.487</georss:point>


This is updating my fetaure service just fine.

What I really need to do, is extract the 'STATUS: under control' to a new field in my feature service so I can symbolise upon it.

Ideally I just want all the values following STATUS:, but not the subsequent values within the description.


I have been playing with various regex patterns but still nowhere close.

Can anyone with some regex knowledge give me some pointers here?