Create New Field w/ Field Calculator (Regular Expression) between :
Heather,
That is great news! For the "Coords", assuming that is exactly how that field is being ingested:
Pattern: (?<=,)[^,]*(?=,)
You can definitely parse through the more complicated field that has speed, altitude, etc.
Can you post a sample xml with the more complicated field included?
~Alex
Heather,
Fantastic! I am very glad you figured it out. In general, I like writing all my outputs to a TCP socket (see my suggestion above https://community.esri.com/external-link.jspa?url=https%3A%2F%2Fwww.arcgis.com%2Fhome%2Fitem.html%3F... ) is a good way to troubleshoot your outputs.
For parsing out your additional fields from this string (if matches exactly):
<![CDATA[20 / 07 / 2017 10: 37: 01 < br / > Lat / Lng: 46.174067,-65.886867 < br / > Speed: 0.6 kph < br / > Altitude: 11.0 m < br / > Heading: 314 & deg; < br / >]] >- Speed
- Pattern: (?<=Speed: )[^*]*(?= kph)
- Altitude
- Pattern: (?<=Altitude: )[^*]*(?= m)
- Pattern: (?<=Altitude: )[^*]*(?= m)
- Heading
- Pattern: (?<=Heading: )[^*]*(?= &)
- Pattern: (?<=Heading: )[^*]*(?= &)
Here is my TCP socket output, you can see Speed (0.9), Altitude (11) and Heading (314) written at the end of my output GeoEvent Definition:
These regular expressions parse through that string okay. You might need to investigate the data coming in to ensure the trailing end of those expressions are general enough to catch all specific permutations. Either way, that should put you down the path of figuring out what exactly you need (if the string changes).
~Alex
