<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1250"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Ako zmazať riadky pre splay-shots:<div class=""><br class=""></div><div class=""><div class="post-text" itemprop="text" style="margin: 0px 0px 5px; padding: 0px; border: 0px; font-size: 15px; width: 660px; word-wrap: break-word; line-height: 1.3; color: rgb(34, 36, 38); font-family: Arial, 'Helvetica Neue', Helvetica, sans-serif;"><ol style="margin: 0px 0px 1em 30px; padding: 0px; border: 0px; list-style-position: initial; list-style-image: initial;" class=""><li style="margin: 0px 0px 0.5em; padding: 0px; border: 0px; word-wrap: break-word;" class="">Select a cell in Column C - kde sú čísla bodov alebo -.</li><li style="margin: 0px 0px 0.5em; padding: 0px; border: 0px; word-wrap: break-word;" class="">Select all cells in the spreadsheet with Ctrl-A.</li><li style="margin: 0px 0px 0.5em; padding: 0px; border: 0px; word-wrap: break-word;" class="">Open the <strong style="margin: 0px; padding: 0px; border: 0px;" class="">Data->Filter->Standard Filter</strong> menu.</li><li style="margin: 0px 0px 0.5em; padding: 0px; border: 0px; word-wrap: break-word;" class="">Set the first row of the filter so that <strong style="margin: 0px; padding: 0px; border: 0px;" class="">Field Name</strong> is "Column C", <strong style="margin: 0px; padding: 0px; border: 0px;" class="">Condition</strong> is "Equals" and <strong style="margin: 0px; padding: 0px; border: 0px;" class="">Value</strong> is ¨-¨.</li><li style="margin: 0px 0px 0.5em; padding: 0px; border: 0px; word-wrap: break-word;" class="">Click OK to apply the filter to the spreadsheet.</li><li style="margin: 0px 0px 0.5em; padding: 0px; border: 0px; word-wrap: break-word;" class="">Select all rows in the spreadsheet with Ctrl-A. To unselect any column header cells, hold Ctrl and click the appropriate row.</li><li style="margin: 0px 0px 0.5em; padding: 0px; border: 0px; word-wrap: break-word;" class="">Right-click on any of the row numbers and select <strong style="margin: 0px; padding: 0px; border: 0px;" class="">Delete Rows</strong>.</li><li style="margin: 0px 0px 0.5em; padding: 0px; border: 0px; word-wrap: break-word;" class="">Select one of the column header cells, or any non-blank cell.</li><li style="margin: 0px; padding: 0px; border: 0px; word-wrap: break-word;" class="">Use the <strong style="margin: 0px; padding: 0px; border: 0px;" class="">Data->Filter->Remove Filter</strong> menu item to restore the remaining rows.</li><li class=""></li></ol></div></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""><div><blockquote type="cite" class=""><div class="">5. 1. 2016 v 13:01, Martin Sluka <<a href="mailto:martinsluka@mac.com" class="">martinsluka@mac.com</a>>:</div><br class="Apple-interchange-newline"><div class=""><meta http-equiv="Content-Type" content="text/html charset=windows-1250" class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><br class=""><div class=""><blockquote type="cite" class=""><div class=""><div class=""><div data-html-editor-font-wrapper="true" style="font-family: arial, sans-serif; font-size: 13px;" class=""><blockquote class=""><div class=""><div style="word-wrap: break-word;-webkit-nbsp-mode: space;-webkit-line-break: after-white-space" class=""><div class=""><blockquote type="cite" class=""><div class=""><div style="font-style: normal;font-variant: normal;font-weight: normal;letter-spacing: normal;line-height: normal;orphans: auto;text-align: initial;text-indent: 0px;text-transform: none;white-space: normal;widows: auto;word-spacing: 0px;-webkit-text-stroke-width: 0px;background-color: rgb(255, 255, 255);width: 844px;font-size: initial;font-family: Calibri, 'Slate Pro', sans-serif, sans-serif;color: rgb(31, 73, 125)" class="">To by ale vůbec nevadilo. Stačilo by vyexportovat tabulku:</div><div style="font-style: normal;font-variant: normal;font-weight: normal;letter-spacing: normal;line-height: normal;orphans: auto;text-align: initial;text-indent: 0px;text-transform: none;white-space: normal;widows: auto;word-spacing: 0px;-webkit-text-stroke-width: 0px;background-color: rgb(255, 255, 255);width: 844px;font-size: initial;font-family: Calibri, 'Slate Pro', sans-serif, sans-serif;color: rgb(31, 73, 125)" class=""></div><div style="font-style: normal;font-variant: normal;font-weight: normal;letter-spacing: normal;line-height: normal;orphans: auto;text-align: initial;text-indent: 0px;text-transform: none;white-space: normal;widows: auto;word-spacing: 0px;-webkit-text-stroke-width: 0px;background-color: rgb(255, 255, 255);width: 844px;font-size: initial;font-family: Calibri, 'Slate Pro', sans-serif, sans-serif;color: rgb(31, 73, 125)" class="">Název bodu;survey;length;clino;asimut;note</div></div></blockquote></div> <div class="">Přesně tohle je v tom sql exportu. Akorát kuchařku, jak se na ta data dostat. Oni všichni tvůrci Survexu a Therionu si s SQL tykají.</div><div class=""></div></div></div></blockquote></div></div></div></blockquote></div>Tak je to jednoduché jak facka:<div class=""><br class=""></div><div class="">1. otevři .sql soubor v textovém editoru</div><div class="">2. najdi sekci, která vypadá takhle:</div><div class=""><br class=""></div><div class=""><div class="">insert into STATION values (859, '40.5', 3275, 443203.59, 4731741.06, 543.77);</div><div class="">insert into STATION values (860, '-', 3275, 443201.66, 4731742.97, 543.19);</div><div class="">insert into STATION values (861, '-', 3275, 443202.60, 4731742.99, 543.35);</div><div class="">insert into STATION values (862, '-', 3275, 443203.15, 4731742.09, 543.32);</div><div class="">insert into STATION values (863, '-', 3275, 443204.17, 4731742.66, 543.36);</div><div class="">insert into STATION values (864, '-', 3275, 443204.11, 4731743.42, 543.32);</div><div class="">insert into STATION values (865, '-', 3275, 443202.93, 4731739.39, 541.24);</div></div><div class=""><br class=""></div><div class="">Všechno tam je, stačí nakopírovat do tabulky a vyházet přebytečné sloupce a řádky. Jo a ještě pro češtinu zaměnit „.“ za „,“ ale až v tabulce.</div><div class=""><br class=""></div><div class="">:)</div><div class=""><br class=""></div><div class="">m.</div></div>_______________________________________________<br class="">Therion-cs mailing list<br class=""><a href="mailto:Therion-cs@speleo.sk" class="">Therion-cs@speleo.sk</a><br class="">http://mailman.speleo.sk/mailman/listinfo/therion-cs<br class=""></div></blockquote></div><br class=""></div></body></html>