<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div>Not quite sure what you’re doing but works fine here.</div><div><br></div><div><img height="138" width="400" apple-width="yes" apple-height="yes" apple-inline="yes" id="AA6BB273-D3F7-4671-B126-F267DF38BDFB" src="cid:ACF2E9AD-2AEB-497F-A300-B35F73C319E6"></div><div><br></div><div>Stuart</div><br><div><div>On 6 Sep 2014, at 11:27, Bo Herrmannsen <<a href="mailto:bo.herrmannsen@gmail.com">bo.herrmannsen@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;"><div dir="ltr">seems it does not simply split but also adds the delimiter to the result<div><br></div><div><span style="font-family: arial, sans, sans-serif; font-size: 13px; white-space: pre-wrap;">102:47:00.000</span><br></div><div><span style="font-family: arial, sans, sans-serif; font-size: 13px; white-space: pre-wrap;"><br></span></div><div><span style="font-family: arial, sans, sans-serif; font-size: 13px; white-space: pre-wrap;">my initial thought is simple rude: WTF.... cant you just do as told.... )(/&%¤#¤</span></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2014-09-06 11:54 GMT+02:00 Bo Herrmannsen<span class="Apple-converted-space"> </span><span dir="ltr"><<a href="mailto:bo.herrmannsen@gmail.com" target="_blank">bo.herrmannsen@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-color: rgb(204, 204, 204); border-left-style: solid; padding-left: 1ex;"><div dir="ltr">So i got the serial output in to a spreadsheet...<div><br></div><div>want to split it up right so its more usefull</div><div><br></div><div>raw data: <span style="font-family: arial, sans, sans-serif; font-size: 13px; white-space: pre-wrap;">Energy: 102.47 </span></div><div><font face="arial, sans, sans-serif"><span style="white-space: pre-wrap;"><br></span></font></div><div><font face="arial, sans, sans-serif"><span style="white-space: pre-wrap;"><br></span></font></div><div><font face="arial, sans, sans-serif"><span style="white-space: pre-wrap;">formula: </span></font><span dir="auto" style="font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 13px; white-space: pre-wrap;">=</span><span dir="auto" style="font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 13px; white-space: pre-wrap;">split</span><span dir="auto" style="font-weight: bold; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 13px; white-space: pre-wrap; background-color: rgb(229, 229, 229);">(</span><span dir="auto" style="font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 13px; white-space: pre-wrap; color: rgb(247, 152, 29);">A1</span><span dir="auto" style="font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 13px; white-space: pre-wrap;">;</span><span dir="auto" style="font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 13px; white-space: pre-wrap;"> </span><span dir="auto" style="color: green; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 13px; white-space: pre-wrap;">":"</span><span dir="auto" style="font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 13px; white-space: pre-wrap;">;</span><span dir="auto" style="font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 13px; white-space: pre-wrap;"> </span><span dir="auto" style="color: rgb(17, 85, 204); font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 13px; white-space: pre-wrap;">False</span><span dir="auto" style="font-weight: bold; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 13px; white-space: pre-wrap; background-color: rgb(229, 229, 229);">)</span></div><div><font><span style="white-space: pre-wrap;"><font face="Inconsolata, monospace, arial, sans, sans-serif"><b><br></b></font></span></font></div><div><font><span style="white-space: pre-wrap;"><font face="Inconsolata, monospace, arial, sans, sans-serif"><b>result: </b></font></span></font><span style="color: rgb(119, 119, 119); font-family: arial, sans, sans-serif; font-size: 12px; text-align: right;">102.47.00</span></div><div><font><span style="white-space: pre-wrap;"><span style="font-family: Inconsolata, monospace, arial, sans, sans-serif;"><font face="arial, sans, sans-serif"><br></font></span></span></font></div><div><font><span style="white-space: pre-wrap;"><span style="font-family: Inconsolata, monospace, arial, sans, sans-serif;"><font face="arial, sans, sans-serif">have tried to set the format of the result cell to automatic, text, numbers....</font></span></span></font></div><div><font><span style="white-space: pre-wrap;"><span style="font-family: Inconsolata, monospace, arial, sans, sans-serif;"><font face="arial, sans, sans-serif"><br></font></span></span></font></div><div><font><span style="white-space: pre-wrap;"><span style="font-family: Inconsolata, monospace, arial, sans, sans-serif;"><font face="arial, sans, sans-serif">no matter what it added .00 </font></span></span></font></div><div><font><span style="white-space: pre-wrap;"><span style="font-family: Inconsolata, monospace, arial, sans, sans-serif;"><font face="arial, sans, sans-serif"><br></font></span></span></font></div><div><font><span style="white-space: pre-wrap;"><span style="font-family: Inconsolata, monospace, arial, sans, sans-serif;"><font face="arial, sans, sans-serif">what am i doing wrong?<br clear="all"></font></span></span></font><div><br></div>--<span class="Apple-converted-space"> </span><br><div dir="ltr"><pre><pre><span style="white-space: pre-wrap;"> |||||
@(~Ô^Ô~)@
-------------oOo---U---oOo-------------
| |
| Bo Herrmannsen |
| |
| |
| "blessed are the "cracked", |
| for its they who let in the light" |
| Ooo |
|_________________ooO____( )________|
( ) ) /
\ ( (_/
\_)
</span></pre></pre><pre style="white-space: pre-wrap;"><br></pre></div></div></div></blockquote></div><br><br clear="all"><div><br></div>--<span class="Apple-converted-space"> </span><br><div dir="ltr"><pre><pre><span style="white-space: pre-wrap;"> |||||
@(~Ô^Ô~)@
-------------oOo---U---oOo-------------
| |
| Bo Herrmannsen |
| |
| |
| "blessed are the "cracked", |
| for its they who let in the light" |
| Ooo |
|_________________ooO____( )________|
( ) ) /
\ ( (_/
\_)
</span></pre></pre><pre style="white-space: pre-wrap;"><br></pre></div></div>_______________________________________________<br>OpenTRV-dev mailing list<br><a href="mailto:OpenTRV-dev@lists.opentrv.org.uk">OpenTRV-dev@lists.opentrv.org.uk</a><br><a href="http://lists.opentrv.org.uk/listinfo/opentrv-dev">http://lists.opentrv.org.uk/listinfo/opentrv-dev</a></div></blockquote></div><br></body></html>