HSP¥Ý¡¼¥¿¥ë
¥µ¥¤¥È¥Þ¥Ã¥× ¤ªÌ䤤¹ç¤ï¤»


HSPTV!·Ç¼¨ÈÄ


̤²ò·è ²ò·è Ää»ß ºï½üÍ×ÀÁ

2020
0616
¤Ö¤Ã¤­¡¼ÆþÎϥܥ寥¹¤Î°ú¿ô¤òÍøÍѤ·¤¿¥³¥Þ¥ó¥É¥×¥í¥ó¥×¥È¾å¤Î¸¡º÷¥³¥Þ¥ó¥É¼Â¹Ô2²ò·è


¤Ö¤Ã¤­¡¼

¥ê¥ó¥¯

2020/6/16(Tue) 23:27:33|NO.90788

¤Ï¤¸¤á¤Þ¤·¤Æ¡£
HTTP¤äVBA¤Î·Ð¸³¤·¤«¤Ê¤¤HSP¥³¡¼¥Ç¥£¥ó¥°¤Î½é¿´¼Ô¤ÇÂçÊѶ²½Ì¤Ç¤¹¤¬¡¢
³§Íͤ˶µ¤¨¤Æ¤¤¤¿¤À¤­¤¿¤¤¤³¤È¤¬¤¢¤ê¡¢¤ªÎÏź¤¨¤Î¤Û¤É¤ª´ê¤¤¤¤¤¿¤·¤Þ¤¹¡£

¢£¤ä¤ê¤¿¤¤»ö
HSP¤Ë¤Æ¥Æ¥­¥¹¥È¥Ü¥Ã¥¯¥¹¤È¸¡º÷¥Ü¥¿¥ó¤òÀߤ±¡¢¥Ü¥¿¥ó¤ò²¡²¼¤·¤¿ºÝ¤Ë¡¢
¥Æ¥­¥¹¥È¥Ü¥Ã¥¯¥¹¤ËÆþÎϤ·¤¿Ê¸»úÎó(°Ê²¼"AAA")¤Ë¹çÃפ¹¤ë¥í¡¼¥«¥ë¥Õ¥©¥ë¥ÀÆâ(°Ê²¼"BBB")¤Îcsv¤Î³ºÅö¹Ô¤òLog¥Õ¥¡¥¤¥ë¤Ë½ÐÎϤ¹¤ë¡¢
¤È¤¤¤¦»ÅÍͤò¼Â¸½¤·¤¿¤¤¤È¹Í¤¨¤Æ¤¤¤Þ¤¹¡£

¢£¼ÂÁõÊý¿Ë
¥Æ¥­¥¹¥È¥Ü¥Ã¥¯¥¹¤È¸¡º÷¥Ü¥¿¥ó¤Î¤ßHSP¤ÇºîÀ®¤·¡¢
¾¤Ï´û¤Ë¥³¥Þ¥ó¥ÉñÂΤÇCMD¾å¸¡¾Ú¤¬´°Î»¤·¤Æ¤¤¤ë°Ê²¼Ê¸¤òÍøÍѤ·¤è¤¦¤È»×¤¤¤Þ¤¹¡£
+++++++++++++
findstr "AAA" C:\BBB\*.csv" >C:\Users\BBB\Log.csv"

+++++++++++++ ¤½¤Î¤¿¤á¡¢HSP¾å¤Ç¤Ï¤³¤Î¤è¤¦¤Ë¤Ê¤ê¡¢AAAÉôʬ¤¬°ú¿ô¤Ë¤Ê¤ë¤«¤È¹Í¤¨¤Æ¤¤¤Þ¤·¤¿¡£ +++++++++++++
exec "cmd.exe /c findstr "AAA" C:\BBB\*.csv" >C:\Users\BBB\Log.csv"
+++++++++++++


¢£²ÝÂê
¤½¤â¤½¤â¾åµ­¹½Ê¸¤¬HSP¾å¤ÇÀµ¾ï¤ËÆ°ºî¤·¤Æ¤ª¤é¤º¡¢Â¾¤Ë¤â°Ê²¼²ÝÂ꤬¤¢¤ê¡¢
ÊÙ¶¯ÉÔ­¤â¤¢¤ê¶²½Ì¤Ç¤¹¤¬¡¢²óÈòºö¤ò¶µ¤¨¤Æ¤¤¤¿¤À¤­¤¿¤¤¼¡Âè¤Ç¤¹¡£
+++++++++++++
­¡¸¡º÷¥Ü¥Ã¥¯¥¹¤ËÅêÆþ¤·¤¿Ê¸»úÎó(AAA)¤òÍøÍѤ·¤¿¥³¥Þ¥ó¥É¥é¥¤¥óʸ¤òºîÀ®¤Ç¤­¤Ê¤¤¡£
¡¡¢ª°ú¿ô¤Ç¤Ï¤Ê¤¯Ê¸»úÎó¤È¤·¤Æ°·¤ï¤ì¤Æ¤·¤Þ¤¤¡¢²óÈòºö¤òÃΤꤿ¤¤¤Ç¤¹¡£

­¢exec¹½Ê¸¾å¡¢¸Æ¤Ó½Ð¤¹CMDÍÑ¥³¥Þ¥ó¥ÉÆâ¤Ë¥À¥Ö¥ë¥³¡¼¥Æ¡¼¥·¥ç¥ó¤¬Æþ¤Ã¤Æ¤·¤Þ¤¤¡¢HSP¾å¹½Ê¸¥¨¥é¡¼¤È¤Ê¤ë¡£
¡¡¢ª¤³¤Á¤é¤â­¡Æ±Íͤ˲óÈòºö¤òÃΤꤿ¤¤¤Ç¤¹¡£

­£exec¹½Ê¸¤Ë¤Æ¡¢Â¾¤Ë¤â¸Æ¤Ó½Ð¤·¤¿¤¤¥³¥Þ¥ó¥Éʸ½ñ¤¬¤¢¤ë¤Î¤Ç¤¹¡£
¡¡¢ª&&¹½Ê¸¤Ç¥³¥Þ¥ó¥É¥é¥¤¥ó¤òÊ£¿ô¤Ä¤Ê¤²¤ëÊýË¡°Ê³°¤Ë²óÈòºö¤¬¤¢¤ì¤Ð¤¦¤ì¤·¤¤¤Ç¤¹¡£
¡¡¡¡¢¨ËÜÍè¤ÏÂоÝCSV¤¬¥Ñ¥¹¥ï¡¼¥ÉÉÕ¤­ZIP²½¤µ¤ì¤Æ¤¤¤ë¤¿¤á¡¢
¡¡¡¡¡¡¡Ö²òÅࢪ¸¡º÷¢ª·ë²Ì¥í¥°½ÐÎÏ¢ªºÆ°µ½Ì¡×¤È¤¤¤¦½èÍý¤ò»Ü¤·¤¿¤¤¤Î¤Ç¤¹¡£
+++++++++++++

²¿Â´¤è¤í¤·¤¯¤ª´ê¤¤¤¤¤¿¤·¤Þ¤¹¡£



¤³¤Îµ­»ö¤ËÊÖ¿®¤¹¤ë


¤¢¤é¤ä

¥ê¥ó¥¯

2020/6/17(Wed) 01:13:36|NO.90790

ʸ»úÎó¤ÎÃæ¤Ç¥À¥Ö¥ë¥¯¥©¡¼¥Æ¡¼¥·¥ç¥ó¤ò»È¤¤¤¿¤¤¾ì¹ç¤Ï¡Ø\"¡Ù¤Èµ­½Ò¤·¤Þ¤¹¡£
ƱÍͤ˥ѥ¹¡Ê\¡Ë¤ò»È¤¦¾ì¹ç¤Ï¡Ø\\¡Ù¤ÈÆó½Å¤Ëµ­½Ò¤·¤Ê¤±¤ì¤Ð¤¤¤±¤Þ¤»¤ó¡£

ʸ»úÎó¤ÈÊÑ¿ô¤ÎÁȤ߹ç¤ï¤»¤Ê¤É¤Ï²¼µ­¤Î¥½¡¼¥¹¤ò»²¹Í¤Ë¤·¤Æ¤¯¤À¤µ¤¤¡£


cmd = "¸¡º÷¥­¡¼¥ï¡¼¥É"; // ¸¡º÷ʸ»úÎó file01 = "C:\\¾Êά\\Search.csv"; // ¸¡º÷¤¹¤ë¥Õ¥¡¥¤¥ë¤ÎÀäÂХѥ¹¡Ê\¤Ï2½Å¤Ë¤¹¤ë¡Ë file02 = "C:\\¾Êά\\Log.csv"; // Êݸ¤¹¤ë¥Õ¥¡¥¤¥ë¤ÎÀäÂХѥ¹¡Ê\¤Ë´Ø¤·¤Æ¤ÏƱ¤¸¡Ë exec "cmd.exe /c findstr \""+cmd+"\" "+file01+" > "+file02+""; // ¥³¥Þ¥ó¥É¥×¥í¥ó¥×¥È¤Ç¼Â¹Ô¡Êʸ»úÎó¤ÎÃæ¤Ë"¤ò»È¤¤¤¿¤¤¾ì¹ç¤Ï\"¤Èµ­½Ò¤¹¤ë¡Ë /* Äɵ­ ʸ»úÎó¤ÈÊÑ¿ô¤òÁȤ߹ç¤ï¤»¤ë¾ì¹ç¤Ï "ŬÅö¤Êʸ»úÎó"+hensuu+"³¤­¤Îʸ»úÎó" ¤³¤Î¤è¤¦¤Ë¥À¥Ö¥ë¥¯¥©¡¼¥Æ¡¼¥·¥ç¥ó¤ò°ìöÊĤ¸¤Æ¡¢¥×¥é¥¹µ­¹æ¤Ë³¤­ÊÑ¿ô¡¢ ¹¹¤Ëʸ»úÎó¤ò³¤±¤ë¾ì¹ç¤ÏÊÑ¿ô¤Î¸å¤Ë¥×¥é¥¹µ­¹æ¤È¥À¥Ö¥ë¥¯¥©¡¼¥Æ¡¼¥·¥ç¥ó¤òÁȤ߹ç¤ï¤»¤Æ»È¤¤¤Þ¤¹¡£ */

¤ª¤½¤é¤¯¤³¤Î¥½¡¼¥¹¤ò¤½¤Î¤Þ¤Þ¼Â¹Ô¡Ê¸¡º÷ʸ»ú¤ä¥Ñ¥¹¤Ï½ñ¤­´¹¤¨¤Æ¤¯¤À¤µ¤¤¡Ë¤¹¤ì¤Ð
´üÂÔÄ̤ê¤Î·ë²Ì¤Ë¤Ê¤ë¤«¤È¡£



¤Ö¤Ã¤­¡¼

¥ê¥ó¥¯

2020/6/17(Wed) 11:04:02|NO.90794

¤¢¤é¤äÍÍ

ÌëÃÙ¤¤»þ´Ö¤Ë¤â´Ø¤ï¤é¤º¤µ¤Ã¤½¤¯²óÅú¤¤¤¿¤À¤­¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£
\ÉÕÍ¿¤Ë¤Ä¤¤¤Æ´ðÁäÀ¤È¤Ï»×¤¤¤Þ¤¹¤¬¡¢¶µ¤¨¤Æ¤¤¤¿¤À¤­¤È¤Æ¤â½õ¤«¤ê¤Þ¤·¤¿¡£
¤Þ¤¿¥³¡¼¥Ç¥£¥ó¥°¤Ë¤Ä¤¤¤Æ¤â¶µ¤¨¤Æ¤¤¤¿¤À¤­¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡¢´Êñ¤Ê½ñ¤­´¹¤¨¼Â¹Ô¤Ë¤è¤ê¼ÂÁõ¤Ç¤­¤ë¤³¤È³Îǧ¤Ç¤­¤Þ¤·¤¿¡£

¤¤¤¿¤À¤¤¤¿²óÅú¤ò¸«¤Æ¥Ï¥Ã¤È¤·¤Þ¤·¤Æ¡¢Â¾¤Ë¤â¤ä¤ê¤¿¤«¤Ã¤¿¤³¤È¤Î¥¤¥á¡¼¥¸¤¬µÞ¤Ëͯ¤¤¤Æ¤­¤Þ¤·¤¿¡£
¤·¤Ð¤é¤¯¸½¾ì¤«¤éÎ¥¤ì¤Æ¤¤¤¿¤â¤Î¤Ç¡¢´ðÁäò¼è¤êÌᤷ¤Ê¤¬¤é¿·¤·¤¤¸À¸ì¤ËÄ©À路¤Æ¤ß¤Þ¤¹¡£

°Ê¾å¡¢¤è¤í¤·¤¯¤ª´ê¤¤¤¤¤¿¤·¤Þ¤¹¡£



ONION software Copyright 1997-2023(c) All rights reserved.