<html>
<head>
</head>
<body style="margin-right: 4px; margin-top: 4px; margin-left: 4px; margin-bottom: 1px; line-height: normal; font-variant: normal">
<p style="margin-bottom: 0; margin-top: 0">
<font face="Comic Sans MS" size="3">Ha, success!!!</font> </p>
<br>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Comic Sans MS" size="3">Coll, Thanks Simon (A LOT !!)</font> </p>
<br>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier" size="3">select rxtime,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier" size="3"> ltrim(split_part(part1, ':', 1), '>') as cmd_type,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier" size="3"> split_part(part1, ':', 2) as esn,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier" size="3"> part2 as time_idx,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier" size="3"> part3 as lat,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier" size="3"> part4 as lon,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier" size="3"> ST_SetSRID(ST_MakePoint(part3::numeric, part4::numeric),4326) as geom,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier" size="3"> part5 as speed,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier" size="3"> part6 as event,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier" size="3"> rtrim(part7, ';') as good</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier" size="3"> from</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier" size="3"> (select rxtime,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier" size="3"> split_part(cmd, ',', 1) as part1, </font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier" size="3"> split_part(cmd, ',', 2) as part2,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier" size="3"> split_part(cmd, ',', 3) as part3,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier" size="3"> split_part(cmd, ',', 4) as part4,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier" size="3"> split_part(cmd, ',', 5) as part5,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier" size="3"> split_part(cmd, ',', 6) as part6,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier" size="3"> split_part(cmd, ',', 7) as part7</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier" size="3"> from </font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier" size="3"> cmdstpinfo</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier" size="3"> where cmd </font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier" size="3"> like '>Plot:%') AS first_pass;</font>
</p>
</body>
</html>