SMARTPARSE
gts strings
Since v1.2.13
Available on all platforms
The SMARTPARSE function parses STRING values, either from a single STRING parameter or from STRING Geo Time Series™, and produces a number of GTS from the parsed data.
The parsing is done according to a regular expression which contains named capturing groups with the Java/.NET syntax, i.e. (?<name>...).
The captured group is interpreted differently based on the syntax of the name.
| Syntax | Interpretation |
|---|---|
| Lxxx | Captured content is used as the value of label xxx |
| TU | Captured group is interpreted as a timestamp in unit U from the UNIX Epoch origin. Valid values for U are s, ms, us, ns |
| lat | Captured group is interpreted as the latitude if another group named lon is also present |
| lon | Captured group is interpreted as the longitude if another group named lat is also present |
| elevU | Captured group is interpreted as the elevation in unit U, where U can be m, cm, mm, ft, km, mi, nm (Nautical Mile). The value is parsed as a DOUBLE and converted to a LONG in mm |
| VTxxx | Captured group is interpreted as a value for a GTS with class xxx. The type of the value is determined by the value of T which can be B(oolean) S(tring) L(ong) or D(ouble) |
This function is ideally suited for parsing log messages and producing Geo Time Series™ from their content.