본삭금 걸어뒀어요! <div><br></div> <div>게임상 공대 관리를 하면서 공대원 관리를 구글 스프레드 시트로 하고있었습니다.</div> <div><br></div> <div>공대원 스펙을 항상 일일히 손으로 바꿔뒀는데</div> <div><br></div> <div>어느순간 아! 웹 파싱을 할수있을것같은데...?</div> <div><br></div> <div>라는 생각이 들어 웹 파싱 검색을 해봤어요.</div> <div><br></div> <div>방법이 간단하더군요</div> <div><br></div> <div><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;"><br></span></div> <div><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">=</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">importhtml</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">(</span><span class="string" style="color:#008000;font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">"<a target="_blank" href="http://bns.plaync.com/bs/character/profile/%EB%A6%B0%EA%B2%80%EC%82%AC+%EC%9D%84%EC%9D%B4?s=7">http://bns.plaync.com/bs/character/profile/%EB%A6%B0%EA%B2%80%EC%82%AC+%EC%9D%84%EC%9D%B4?s=7</a>"</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">,</span><span class="string" style="color:#008000;font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">"table"</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">,</span><span class="number" style="color:#1155cc;font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">1</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">)</span></div> <div><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;"><br></span></div> <div>이렇게 넣으면</div> <div><br></div> <div><div style="text-align:left;"> <div style="text-align:left;"><img src="http://thimg.todayhumor.co.kr/upfile/201612/14822799425f3ddc1b65a24e23b3413df2812ebd4e__mn409910__w170__h325__f16207__Ym201612.jpg" width="170" height="325" alt="1.jpg" style="border:none;" filesize="16207"></div><br></div></div> <div style="text-align:left;">잘나옵니다!!! 잘나와요!</div> <div style="text-align:left;"><br></div> <div style="text-align:left;">근데 여기서 문제가 생겼습니다.</div> <div style="text-align:left;"><br></div> <div style="text-align:left;">저기중에서 맨 아래 4줄 호운~얼굴장식은 필요가 없거든요.</div> <div style="text-align:left;"><br></div> <div style="text-align:left;">그래서 고민해봅니다</div> <div style="text-align:left;"><br></div> <div style="text-align:left;"><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">=</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">importhtml</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">(</span><span class="string" style="color:#008000;font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">"<a target="_blank" href="http://bns.plaync.com/bs/character/profile/%EB%A6%B0%EA%B2%80%EC%82%AC+%EC%9D%84%EC%9D%B4?s=7">http://bns.plaync.com/bs/character/profile/%EB%A6%B0%EA%B2%80%EC%82%AC+%EC%9D%84%EC%9D%B4?s=7</a>"</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">,</span><span class="string" style="color:#008000;font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">"table"</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">,</span><span class="number" style="color:#1155cc;font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">1</span><font color="#ff0000"><b><span class="argument-error" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;"><span class="default-formula-text-color">, </span></span><span class="argument-error" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;"><span class="number">1</span></span></b></font><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">)</span></div> <div style="text-align:left;"><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;"><br></span></div> <div style="text-align:left;"><font face="Inconsolata, monospace, arial, sans, sans-serif"><span style="font-size:14px;white-space:pre-wrap;">빨갛고 굵게 된 부분을 추가했습니다</span></font></div> <div style="text-align:left;"><font face="Inconsolata, monospace, arial, sans, sans-serif"><span style="font-size:14px;white-space:pre-wrap;"><br></span></font></div> <div style="text-align:left;"><font face="Inconsolata, monospace, arial, sans, sans-serif"><span style="font-size:14px;white-space:pre-wrap;"></span></font><div style="text-align:left;"><img src="http://thimg.todayhumor.co.kr/upfile/201612/1482280114c34808b3cb7b4eb7973343a3e3861606__mn409910__w346__h179__f11633__Ym201612.jpg" width="346" height="179" alt="2.jpg" style="border:none;" filesize="11633"></div></div> <div style="text-align:left;"><font face="Inconsolata, monospace, arial, sans, sans-serif"><span style="font-size:14px;white-space:pre-wrap;"><br></span></font></div> <div style="text-align:left;">안되자나 ㅜㅜㅜㅜㅜ</div> <div style="text-align:left;"><br></div> <div style="text-align:left;"><br></div> <div style="text-align:left;"><br></div> <div style="text-align:left;">앗... 글쓰면서 검색중에 알아냈어요</div> <div style="text-align:left;">array_constrain함수를 쓰면...</div> <div style="text-align:left;"><br></div> <div style="text-align:left;"><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">=</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">ARRAY_CONSTRAIN</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">(</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">IMPORTHTML</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">(</span><span class="string" style="color:#008000;font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">"<a target="_blank" href="http://bns.plaync.com/bs/character/profile/%EB%A7%88%EC%8E%BC%EC%98%A4%EB%A6%AC%EC%A7%80%EB%84%90?s=20">http://bns.plaync.com/bs/character/profile/%EB%A7%88%EC%8E%BC%EC%98%A4%EB%A6%AC%EC%A7%80%EB%84%90?s=20</a>"</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">,</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;"> </span><span class="string" style="color:#008000;font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">"table"</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">,</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;"> </span><span class="number" style="color:#1155cc;font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">1</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">)</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">,</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;"> </span><span class="number" style="color:#1155cc;font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">11</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">,</span><span class="number" style="color:#1155cc;font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">2</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">)</span></div> <div style="text-align:left;"><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;"><br></span></div> <div style="text-align:left;"><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;"></span><div style="text-align:left;"><img src="http://thimg.todayhumor.co.kr/upfile/201612/1482281224ab60968b64e84099a36f1538e18b0187__mn409910__w315__h249__f16163__Ym201612.jpg" width="315" height="249" alt="3.jpg" style="border:none;" filesize="16163"></div><br></div> <div style="text-align:left;">좋아요</div> <div style="text-align:left;">이제 저기서 외형변경이란 글자를 빼고 싶어요...</div> <div style="text-align:left;"><br></div> <div style="text-align:left;">웹 파싱한 결과가 2*11인데 1*11로 만들고싶어요...</div> <div style="text-align:left;"><br></div> <div style="text-align:left;"><br></div> <div style="text-align:left;"><br></div> <div style="text-align:left;">덤으로 저걸 행열 바꾸기로 아래로가 아니라 옆으로 넓게 퍼뜨리고싶어요</div> <div style="text-align:left;"><br></div> <div style="text-align:left;">행열바꾸는 명령어는 찾을수가...</div> <div style="text-align:left;"><br></div> <div style="text-align:left;"><br></div> <div style="text-align:left;"><br></div> <div style="text-align:left;">도와주세욧!!!</div> <div style="text-align:left;"><br></div>
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.