<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content=text/html;charset=windows-1257> <META content="MSHTML 6.00.2900.6129" name=GENERATOR> <STYLE></STYLE> </HEAD> <BODY id=MailContainerBody style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-TOP: 15px" bgColor=#ffffff leftMargin=0 topMargin=0 name="Compose message area" CanvasTabStop="true"> <DIV><FONT face=Arial size=2>Dekui, puikiai veikia</FONT></DIV> <BLOCKQUOTE dir=ltr style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"> <DIV>"Mudyla" <<A href="mailto:steevas@hotmail.com">steevas@hotmail.com</A>> wrote in message <A href="news:j5ib6o$iat$1@trimpas.omnitel.net">news:j5ib6o$iat$1@trimpas.omnitel.net</A>...</DIV> <DIV><FONT face=Arial size=2>Manau paprasciausias budas, t.y. be jokiu formuliu ar macros'u butu naudoti "Text to columns" mygtuka. Isskaidysi A stulpeli i laika ir data, o po to susidesi i kuriuos nori stulpelius. Manau, jei vienu metu naudosi ir kableli, ir tarpa kaip delimeterius, tai normaliai atskirs.</FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <BLOCKQUOTE dir=ltr style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"> <DIV>"erniux" <<A title="mailto:erniux@gmail.com CTRL + Click to follow link" href="mailto:erniux@gmail.com">erniux@gmail.com</A>> wrote in message <A title="news:j5i94p$g5u$1@trimpas.omnitel.net CTRL + Click to follow link" href="news:j5i94p$g5u$1@trimpas.omnitel.net">news:j5i94p$g5u$1@trimpas.omnitel.net</A>...</DIV> <DIV> <TABLE style="WIDTH: 806pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=1074 border=0> <COLGROUP><FONT face=Arial> <COL style="WIDTH: 806pt; mso-width-source: userset; mso-width-alt: 39277" width=1074><FONT size=2></FONT></FONT> <TBODY> <TR style="HEIGHT: 15pt" height=20> <TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 806pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=1074 height=20> <DIV><FONT face=Arial size=2>Sveiki, energijos matuoklis duoda valandines elektros snaudas csv formate pvz:</FONT></DIV> <DIV><FONT face=Arial size=2>'12:00 2011/09/23,0.7524,0,,,</FONT></DIV></TD></TR></TBODY></TABLE></DIV> <DIV><FONT face=Arial size=2>Kaip padaryti, kad celje B bt atrenkamos valandos t.y 12:00, C celje atsirast 2011/09/23 ir D atsirast 0.7524</FONT></DIV> <DIV><FONT face=Arial size=2>Ai</FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>