åŠçäžãã¡ã€ã«æžåŒ | ç¶æ ååŸæžåŒ | ãŠãŒã¶ãŒããŒã¿æžåŒ | ã°ããŒãã«ããŒã¿æžåŒ | æ¥ä»æžåŒ | æååæžåŒ | æ°åŠæžåŒ | å¶åŸ¡æžåŒ | ãã¡ã€ã«ã·ã¹ãã æžåŒ | ããã¹ããã¡ã€ã«æžåŒ | ããŒã¿ããŒã¹æžåŒ | ããã»ã¹æžåŒ | WebæžåŒ | DocuWorksæžåŒ | DocuWorksæžåŒ (ã¢ãããŒã·ã§ã³é¢é£) | ç»ååŠçæžåŒ | ExcelæžåŒ | ãã®ä»ã®æžåŒ
ããã¹ãèªã¿èŸŒã¿ã§èªã¿èŸŒãã ããã¹ãã1è¡ååŸããŸããåŠçåã«å¯Ÿè±¡ãšãªãããã¹ãèªã¿èŸŒã¿ã®åŠçåãæå®ããŠãã ããã
{%MSGBOX({%GET_LINE(ããã¹ãèªã¿èŸŒã¿1)})}
ããã¹ãèªã¿èŸŒã¿ã§èªã¿èŸŒãã ããã¹ããåã¯ãSQLå®è¡ã®SLELCTæã®çµæã¬ã³ãŒããååŸããŸããåŠçåã«å¯Ÿè±¡ãšãªãããã¹ãèªã¿èŸŒã¿ãåã¯ãSQLå®è¡ã®åŠçåãæå®ããŠãã ããã
åçªå·ã¯ã察象ã®é ç®çªå·ãæå®ããŸãã
{%MSGBOX({%GET_FIELD_VALUE(ããã¹ãèªã¿èŸŒã¿1,2)})}
ããã¹ãèªã¿èŸŒã¿ã§èªã¿èŸŒãã ããã¹ãã®é åã«å€ãã»ããããŸããåŠçåã«å¯Ÿè±¡ãšãªãããã¹ãèªã¿èŸŒã¿ãæå®ããŠãã ããã
åçªå·ã¯ã察象ã®é ç®çªå·ãæå®ããŸãã
æ¬ãã¯ãã¯ãããã¹ãèªã¿èŸŒã¿ã§èªã¿èŸŒãã ããŒã¿ãéšåçã«å€æŽãããå Žåã«äœ¿çšããŸãã
{%SET_FIELD_VALUE(ããã¹ãèªã¿èŸŒã¿1,3,28)}
{%MSGBOX({%GET_FIELD_VALUE(ããã¹ãèªã¿èŸŒã¿1,3)})}
ããã¹ãèªã¿èŸŒã¿ã§èªã¿èŸŒãã ããã¹ããåã¯ãSQLå®è¡ã®SLELCTæã®çµæã¬ã³ãŒããCSV(ã«ã³ãåºåã)ã§ååŸããŸããåŠçåã«å¯Ÿè±¡ãšãªãããã¹ãèªã¿èŸŒã¿ãåã¯ãSQLå®è¡ã®åŠçåãæå®ããŠãã ããã
åçªå·ã¯ã察象ã®é ç®çªå·ãæå®ããŸããåçªå·ã¯è€æ°èšè¿°ããããšãå¯èœã§ããäŸãã°1çªç®ãš2çªç®ã®é ç®ãååŸãããå Žåã¯ã1,2ãšèšè¿°ããŸãã2çªç®ïœ5çªç®ã®é ç®ãååŸãããå Žåã¯ã2-5ãšèšè¿°ããŸãã1,3-5ã®ããã«ã«ã³ããšãã€ãã³ãçµã¿åãããŠæå®ããããšãå¯èœã§ãã1-ã-3ã®ããã«ãéå§ãçµäºã®åçªå·ãçç¥ããããšãå¯èœã§ãã
ååŸãããããã¹ãã¯CSV圢åŒã«ãªããŸããè€æ°ã®é ç®ãã«ã³ãã§åºåãããé ç®äžã«ã«ã³ããããå Žåã¯ãé ç®ãâã§å²ãããŸããåäžã®åãååŸããå Žåã§ããé ç®äžã«ã«ã³ããããå Žåã¯ãé ç®ãâã§å²ãããŸãã
é ç®äžã«"ãããå Žåã¯ã""ãš2ã€ç¶ããŠèšè¿°ãããé ç®ãâã§å²ãããŸãã
{%MSGBOX({%GET_FIELD_VALUES_IN_CSV(ããã¹ãèªã¿èŸŒã¿1,2,4)})}
{%MSGBOX({%GET_FIELD_VALUES_IN_CSV(ããã¹ãèªã¿èŸŒã¿1,1-3)})}
{%MSGBOX({%GET_FIELD_VALUES_IN_CSV(ããã¹ãèªã¿èŸŒã¿1,1,4)})}
{%MSGBOX({%GET_FIELD_VALUES_IN_CSV(ããã¹ãèªã¿èŸŒã¿1,1,4,5)})}
ããã¹ãèªã¿èŸŒã¿ã§èªã¿èŸŒãã ããã¹ããåã¯ãSQLå®è¡ã®SLELCTæã®çµæã¬ã³ãŒããTSV(ã¿ãåºåã)ã§ååŸããŸããåŠçåã«å¯Ÿè±¡ãšãªãããã¹ãèªã¿èŸŒã¿ãåã¯ãSQLå®è¡ã®åŠçåãæå®ããŠãã ããã
è¿åŽæååãã¿ãåºåããšãªã以å€ã¯ãCSVããã¹ãååŸãã¯ããšåã仿§ãšãªããŸãã
ããã¹ãèªã¿èŸŒã¿ã§èªã¿èŸŒãã ããã¹ããåã¯ãSQLå®è¡ã®SLELCTæã®çµæã¬ã³ãŒããåŒæ°ã§æå®ãããåºåãæååºåãã§ååŸããŸããåŠçåã«å¯Ÿè±¡ãšãªãããã¹ãèªã¿èŸŒã¿ãåã¯ãSQLå®è¡ã®åŠçåãæå®ããŠãã ããã
åºæ¬çãªåäœã¯CSVããã¹ãååŸãã¯ããšåãã§ãããåºåãæåããšã¹ã±ãŒãåŠçã®æç¡ãå²ãæåãå šãŠã®é ç®ã«å²ãæåãä»äžãããã©ãããæå®å¯èœã§ãã
ãšã¹ã±ãŒãåŠçã¯ãé ç®äžã«åºåãæåãå«ãŸããŠããå Žåã«ãå²ãæåã§é ç®ãå²ããŸãããŸããé ç®äžã«å²ãæåãå«ãŸããŠããå Žåã«å²ãæåã2ã€ç¶ããŠèšè¿°ããå²ãæåã§é ç®ãå²ããŸãã
äŸãã°1çªç®ã®ããŒã¿ãã123ãã2çªç®ã®ããŒã¿ããA,BCãã®å Žåãã123,"A,BC"ããšååŸãããŸãã
1çªç®ã®ããŒã¿ãã123ãã2çªç®ã®ããŒã¿ããA"BCãã®å Žåãã123,"A""BC"ããšååŸãããŸãã
å šé ç®å²ãæåä»äžæç¡ã«ãæããæå®ãããå Žåã¯ãå šé ç®ãå²ãæåã§å²ãããŸãããšã¹ã±ãŒãåŠçã§ã¯ãªãã®ã§ãåæã«ãšã¹ã±ãŒãåŠçãè¡ãããå Žåã¯ããšã¹ã±ãŒãæç¡ã«ãæããåãããŠæå®ããŠãã ããã
{%MSGBOX({%GET_FIELD_VALUES_IN_SV(ããã¹ãèªã¿èŸŒã¿1,||,æ,",æ,1-)})}
{%MSGBOX({%GET_FIELD_VALUES_IN_SV(ããã¹ãèªã¿èŸŒã¿1,|,,ç¡,',ç¡,1-5)})}
{%MSGBOX({%GET_FIELD_VALUES_IN_SV(ããã¹ãèªã¿èŸŒã¿1,|,,æ,',ç¡,1-5)})}
GET_FIELD_VALUE ãšåãã§ãããé ç®ãååã§æå®ã§ããŸããäœãããããæ å ±ãããããã¹ããèªã¿èŸŒãã å Žåã®ã¿äœ¿çšã§ããŸããSQLå®è¡ã®SELECTæã®çµæã¬ã³ãŒãã«å¯ŸããŠã¯äœ¿çšã§ããŸããã
{%MSGBOX({%GET_FIELD_VALUE(ããã¹ãèªã¿èŸŒã¿1,æ§å¥)})}
GET_FIELD_VALUES_IN_CSV ãšåãã§ãããé ç®ãååã§æå®ã§ããŸããäœãããããæ å ±ãããããã¹ããèªã¿èŸŒãã å Žåã®ã¿äœ¿çšã§ããŸããSQLå®è¡ã®SELECTæã®çµæã¬ã³ãŒãã«å¯ŸããŠã¯äœ¿çšã§ããŸããã
{%MSGBOX({%GET_FIELD_VALUES_IN_CSV_BY_NAME(ããã¹ãèªã¿èŸŒã¿1,æ§å¥,äœæ)})}
GET_FIELD_VALUES_IN_TSV ãšåãã§ãããé ç®ãååã§æå®ã§ããŸããäœãããããæ å ±ãããããã¹ããèªã¿èŸŒãã å Žåã®ã¿äœ¿çšã§ããŸããSQLå®è¡ã®SELECTæã®çµæã¬ã³ãŒãã«å¯ŸããŠã¯äœ¿çšã§ããŸããã
GET_FIELD_VALUES_IN_SV ãšåãã§ãããé ç®ãååã§æå®ã§ããŸããäœãããããæ å ±ãããããã¹ããèªã¿èŸŒãã å Žåã®ã¿äœ¿çšã§ããŸããSQLå®è¡ã®SELECTæã®çµæã¬ã³ãŒãã«å¯ŸããŠã¯äœ¿çšã§ããŸããã
ããã¹ããã¡ã€ã«ããããã¹ããèªã¿èŸŒã¿ãŸããæ¬ãã¯ãã¯ããã¹ãèªã¿èŸŒã¿åŠçãšé¢ä¿ãªãåç¬ã§äœ¿çšã§ããŸããæåã³ãŒãã¯ãSJISãããUTF-8ãããUTF-16ãããUTF-16BEãããEUCãããJISãããèªåãã®äœãããæå®ããŸãã
ãŠãŒã¶ãŒããŒã¿åã§æå®ããããŠãŒã¶ãŒããŒã¿ãäœæããŠãèªã¿èŸŒãã ããã¹ããæ ŒçŽããŸããè¡ã¢ãŒãããLINEãã®å Žåãè¡åäœã«èªã¿èŸŒã¿è¡çªå·ãããŒãšããŠãŠãŒã¶ãŒããŒã¿ã«æ ŒçŽããŸããè¡ã¢ãŒãããALLãã®å Žåãå šè¡ãèªã¿èŸŒã¿ãããŒã1ããšããŠãŠãŒã¶ãŒããŒã¿ã«æ ŒçŽããŸãã
è¡ã¢ãŒãããLINEãã®å Žåãèªã¿èŸŒã¿åŸã®ããã¹ãã®æ¹è¡ã³ãŒãã¯CRLFã«ãªããŸãã
è¡ã¢ãŒãããALLãã®å Žåãèªã¿èŸŒã¿åŸã®ããã¹ãã®æ¹è¡ã³ãŒãã¯ããã¹ããã¡ã€ã«ã®æ¹è¡ã³ãŒããšåãã«ãªããŸãã
æå®ããããã¡ã€ã«ãèŠã€ãããªãå Žåã¯ãæ»ãå€ã«Falseãè¿ããŸããåŠçãæ£åžžã«çµäºããå Žåã¯Trueãè¿ããŸãã
{%READ_FILE(D:\data.txt,text,SJIS,ALL)} {%SET_CLIPBOARD_TEXT({%GET_USER_DATA(text,1)})}
{%READ_FILE(D:\data.txt,text,SJIS,LINE)} {%SET_CLIPBOARD_TEXT({%GET_USER_DATA(text,2)})}
ãŠãŒã¶ãŒããŒã¿ã®1éå±€ç®ã®1èŠçŽ ã1è¡ãšããŠãå šèŠçŽ ããã¡ã€ã«ã«æžã蟌ã¿ãŸãã
ãŠãŒã¶ãŒããŒã¿ã¯1éå±€ã®ã¿å¯Ÿè±¡ãšããŠããŸãã(2é局以éã®ããŒã¿ã¯ç¡èŠãããŸã)
ãšã³ã³ãŒãã£ã³ã°ã®ãUTF-8ã ã¯ãBOMç¡ãUTF-8ããUTF-8WBã ã¯ãBOMæãUTF-8ã衚ããŠããŸãã
æžã蟌ã¿ã¢ãŒãããNewãã®å Žåã¯æ°èŠã§ãã¡ã€ã«ãäœæããŸããååã®ãã¡ã€ã«ãããå Žåã¯äžæžãããŸãã
æžã蟌ã¿ã¢ãŒãããAppendãã®å Žåã¯è¿œå æžã蟌ã¿ããŸãããã¡ã€ã«ããªãå Žåã¯æ°èŠäœæããŸãã
æžã蟌ã¿ã¢ãŒããçç¥ãããå Žåã¯NewãšãªããŸãã
{%ADD_USER_DATA(writeData,WRITE_FILEãã¯ãã«ã€ããŠ)} {%ADD_USER_DATA(writeData,ãŠãŒã¶ãŒããŒã¿ã®å 容ããã¡ã€ã«ã«ä¿åããŸãã)} {%WRITE_FILE(D:\test.txt,writeData,SJIS,New)}
CSVãã¡ã€ã«ããããã¹ããèªã¿èŸŒã¿ãŸããæ¬ãã¯ãã¯ããã¹ãèªã¿èŸŒã¿åŠçãšé¢ä¿ãªãåç¬ã§äœ¿çšã§ããŸããæåã³ãŒãã¯ãSJISãããUTF-8ãããUTF-16ãããUTF-16BEãããEUCãããJISãããèªåãã®äœãããæå®ããŸãã
ãŠãŒã¶ãŒããŒã¿åã§æå®ããããŠãŒã¶ãŒããŒã¿ãäœæããŠãèªã¿èŸŒãã ããã¹ããæ ŒçŽããŸããè¡åäœã«èªã¿èŸŒã¿ãè¡çªå·ãåé¡ããŒã§äœæããé ç®æ¯ã«ãŠãŒã¶ãŒããŒã¿ã«æ ŒçŽããŸãã
ãããè¡ã«ã¯ãããã®è¡çªå·ãæå®ããŸãããããè¡ããªãå Žåã¯0ãæå®ããŸãã
ããŒã¿éå§è¡ã«ã¯ãããŒã¿è¡ã®å é ã®è¡çªå·ãæå®ããŸãã
è¡ããŒã«ã¯ãããŒãšãªãé ç®çªå·(1ïœ)ãæå®ããŸããããŒãè€æ°æå®ããå Žåã¯ãã1-2ãã®ããã«ãã€ãã³ã§åºåããŸãã
è¡ããŒã«é ç®çªå·ãæå®ããå Žåãæå®ãããé ç®ã®ããŒã¿ã«éè€ãããå ŽåãæåŸã«èªã¿èŸŒãã ããŒã¿ã§äžæžããããŸãããŸããé ç®ã空æåã ã£ãå Žåã¯éè€ããªãé£çªãèªåä»äžããããŒãäœæãããŸãã
è¡ããŒã«0ãæå®ãããšè¡ã®ããŒã¯çªå·(1ïœ)ã«ãªããŸãã
é ç®ããŒã¿ã€ãã«é ç®åãæå®ããå Žåã¯ããããè¡ã«1以äžã®æ°åãæå®ããå¿ èŠããããŸãããããè¡ã«æå®ãããè¡ã®é ç®åãããŒãšããŠäœ¿çšããŸãããããè¡ã0ã®å Žåã¯é ç®åã¯çªå·ãšãªããŸãã
é ç®ããŒã¿ã€ãã«çªå·ãæå®ããå Žåã¯é ç®çªå·ãããŒãšãªããŸãã
åºåãæåã¯çç¥å¯èœã§ããæå®ããå Žåã¯æå®ããæåãåºåãæåãšããŠåŠçããŸããã¿ããæå®ãããå Žåã¯ã<Tab>ããæå®ããŸãã
æå®ããããã¡ã€ã«ãèŠã€ãããªãå Žåã¯ãæ»ãå€ã«Falseãè¿ããŸããåŠçãæ£åžžã«çµäºããå Žåã¯Trueãè¿ããŸãã
{%READ_CSV_FILE(D:\data.csv,csv,SJIS,0,1,0,çªå·)} {%LOOP L1 {%GET_USER_DATA_KEY_COUNT(csv)}( {%LOOP L2 {%GET_USER_DATA_KEY_COUNT(csv,[L_IDX(L1)])}( {%WRITE_LOG({%GET_U(csv,[L_IDX(L1)],[L_IDX(L2)])})} )} )}
{%READ_CSV_FILE(D:\data.csv,csv,SJIS,1,2,0,é ç®å)} {%LOOP L1 {%GET_USER_DATA_KEY_COUNT(csv)}( {%WRITE_LOG({%GET_U(csv,[L_IDX(L1)],æ°å)})} {%WRITE_LOG({%GET_U(csv,[L_IDX(L1)],幎霢)})} {%WRITE_LOG({%GET_U(csv,[L_IDX(L1)],é»è©±çªå·)})} )}
{%READ_CSV_FILE(D:\data.csv,csv,SJIS,1,2,1,é ç®å)} #åŠççªå·ã0003ã®ããŒã¿ãåºåãã {%WRITE_LOG({%GET_U(csv,0003,æ°å)})} {%WRITE_LOG({%GET_U(csv,0003,幎霢)})} {%WRITE_LOG({%GET_U(csv,0003,é»è©±çªå·)})}
ãŠãŒã¶ãŒããŒã¿ã®1éå±€ç®ã®1èŠçŽ ã1è¡ã2éå±€ç®ã®1èŠçŽ ãé ç®ãšããŠãå šãŠã®è¡ãå šãŠã®é ç®ããã¡ã€ã«ã«æžã蟌ã¿ãŸãã
ãŠãŒã¶ãŒããŒã¿ã®ããŒã¯åç §ããŸãããããŒã«äœãæ ŒçŽãããŠããŠãåäœã«åœ±é¿ã¯ãããŸããã
ãšã³ã³ãŒãã£ã³ã°ã®ãUTF-8ã ã¯ãBOMç¡ãUTF-8ããUTF-8WBã ã¯ãBOMæãUTF-8ã衚ããŠããŸãã
æžã蟌ã¿ã¢ãŒãããNewãã®å Žåã¯æ°èŠã§ãã¡ã€ã«ãäœæããŸããååã®ãã¡ã€ã«ãããå Žåã¯äžæžãããŸãã
æžã蟌ã¿ã¢ãŒãããAppendãã®å Žåã¯è¿œå æžã蟌ã¿ããŸãããã¡ã€ã«ããªãå Žåã¯æ°èŠäœæããŸãã
æžã蟌ã¿ã¢ãŒããçç¥ãããå Žåã¯NewãšãªããŸãã
{%ADD_USER_DATA(writeData,1,瀟å¡çªå·)} {%ADD_USER_DATA(writeData,1,æ°å)} {%ADD_USER_DATA(writeData,2,0001)} {%ADD_USER_DATA(writeData,2,ç¹ç°ä¿¡é·)} {%ADD_USER_DATA(writeData,3,0002)} {%ADD_USER_DATA(writeData,3,æŠç°ä¿¡ç)} {%WRITE_CSV_FILE(D:\data.csv,writeData,SJIS)}
çµæ 瀟å¡çªå·,æ°å 0001,ç¹ç°ä¿¡é· 0002,æŠç°ä¿¡ç
{%SET_U(writeData,1,1,瀟å¡çªå·)} {%SET_U(writeData,1,2,æ°å)} {%WRITE_CSV_FILE(D:\data.csv,writeData,SJIS,New)} {%SET_U(writeData,1,1,0001)} {%SET_U(writeData,1,2,ç¹ç°ä¿¡é·)} {%WRITE_CSV_FILE(D:\data.csv,writeData,SJIS,Append)} {%SET_U(writeData,1,1,0002)} {%SET_U(writeData,1,2,æŠç°ä¿¡ç)} {%WRITE_CSV_FILE(D:\data.csv,writeData,SJIS,Append)}
çµæ 瀟å¡çªå·,æ°å 0001,ç¹ç°ä¿¡é· 0002,æŠç°ä¿¡ç
SQLå®è¡ã§çµæãè¿ãSQL(SELECT)ãå®è¡ããçµæã®ã¬ã³ãŒãã¯ãããã¹ããã¡ã€ã«æžåŒã®ãGET_FIELD_VALUES_IN_CSVãããGET_FIELD_VALUES_IN_TSVãããGET_FIELD_VALUES_IN_SVããã¯ãã䜿ã£ãŠååŸã§ããŸãã
SQLãå®è¡ããŠæ¡ä»¶ã«ãããããã¬ã³ãŒãããŠãŒã¶ãŒããŒã¿ã«ã»ããããŸããæ€çŽ¢ã®çµæã¬ã³ãŒããè€æ°ãããããŠãæåã®1ã¬ã³ãŒãã®ã¿ååŸããŸãã çµæã¯æå®ãããŠãŒã¶ãŒããŒã¿åã«1ããå§ãŸãçªå·ãããŒã«ããŠé ç®å€ãæ ŒçŽãããŸãã
{%GET_RECORD(DBæ¥ç¶1,RET,select count(id) from id_summary_tbl where id={%GET_FIELD_VALUES_IN_SQL_VALUES(ããã¹ãèªã¿èŸŒã¿1,1)};)}
äžèšã®ãã¯ããå®è¡ããçµæããid_summary_tblãããŒãã«ã«è©²åœã®idãèŠã€ãã£ãå Žåã1以äžã®æ°åããŠãŒã¶ãŒããŒã¿ã«ã»ãããããŸããèŠã€ãããªãå Žåã¯0ãã»ãããããŸãã®ã§ã以äžã®æ¡ä»¶åŒã§Trueãè¿åŽããããšãã§ããŸãã
{%IF({%GET_USER_DATA(RET,1)}=0,True,False)}
ããã¹ãèªã¿èŸŒã¿ã§èªã¿èŸŒãã ããã¹ããåã¯ãSQLå®è¡ã®SLELCTæã®çµæã¬ã³ãŒããSQLçšã®ã«ã³ãåºåãããã¹ããšããŠååŸããŸããæ¬ãã¯ãã§ã¯ãSQLã«å¿ èŠãªãšã¹ã±ãŒãåŠçãè¡ããŸãã
INSERT INTO id_summary_tbl (id,id_count) VALUES({%GET_FIELD_VALUES_IN_SQL_VALUES(ããã¹ãèªã¿èŸŒã¿1,1)},1);
GET_FIELD_VALUES_IN_SQL_VALUES ãšåãã§ãããé ç®ãååã§æå®ã§ããŸããäœãããããæ å ±ãããããã¹ããèªã¿èŸŒãã å Žåã®ã¿äœ¿çšã§ããŸããSQLå®è¡ã®SELECTæã®çµæã¬ã³ãŒãã«å¯ŸããŠã¯äœ¿çšã§ããŸããã
åŒæ°ã§æå®ããããŠãŒã¶ãŒããŒã¿ã®å šé ç®å€ãSQLçšã®ã«ã³ãåºåãããã¹ããšããŠååŸããŸããæ¬ãã¯ãã§ã¯ãSQLã«å¿ èŠãªãšã¹ã±ãŒãåŠçãè¡ããŸãã
INSERT INTO id_summary_tbl (id,id_count) VALUES({%GET_USER_DATA_IN_SQL_VALUES(RET)},1);
åŒæ°ã§æå®ãããDBæ¥ç¶ã®ãã©ã³ã¶ã¯ã·ã§ã³ãéå§ããŸãã
{%BEGIN_TRANSACTION(DBæ¥ç¶1)}
åŒæ°ã§æå®ãããDBæ¥ç¶ã®ãã©ã³ã¶ã¯ã·ã§ã³ãã³ãããããŸãã
{%COMMIT(DBæ¥ç¶1)}
åŒæ°ã§æå®ãããDBæ¥ç¶ã®ãã©ã³ã¶ã¯ã·ã§ã³ãããŒã«ããã¯ããŸãã
{%ROLLBACK(DBæ¥ç¶1)}
åŒãæ°ã§æå®ããç»åãã¡ã€ã«ã®è§£å床ãçžŠå¹ ãæšªå¹ ãååŸããŸããååŸã§ããæ å ±ã¯ä»¥äžã®éãã§ãçµæã¯çµææ ŒçŽçšãŠãŒã¶ãŒããŒã¿ã«æ ŒçŽãããŸãã
BMP,Tiff,JPEGçã®ç»åãã¡ã€ã«ã«å¯Ÿå¿ããŠããŸãããã«ãããŒãžTiffã¯1ããŒãžç®ã®ç»åæ å ±ãååŸããŸãã
ã㌠| å€ |
---|---|
Width | ç»åãã¡ã€ã«ã®æšªå¹ ã(åäœ:mm) |
Height | ç»åãã¡ã€ã«ã®çžŠå¹ ã(åäœ:mm) |
VerRes | ç»åãã¡ã€ã«ã®åçŽæ¹åã®è§£å床ã(åäœ:dpi) |
HorRes | ç»åãã¡ã€ã«ã®æ°Žå¹³æ¹åã®è§£å床ã(åäœ:dpi) |
Resolution | ç»åãã¡ã€ã«ã®åçŽæ¹åãšæ°Žå¹³æ¹åã®è§£å床ã®é«ãæ¹ã(åäœ:dpi) |
{%GET_IMAGE_INFORMATION({%GET(FullPathFileName)},ImageInformation)} {%WRITE_LOG(Width:{%GET_U(ImageInformation,Width)})} {%WRITE_LOG(Height:{%GET_U(ImageInformation,Height)})} {%WRITE_LOG(VerRes:{%GET_U(ImageInformation,VerRes)})} {%WRITE_LOG(HorRes:{%GET_U(ImageInformation,HorRes)})} {%WRITE_LOG(Resolution:{%GET_U(ImageInformation,Resolution)})}
åŒæ°ã®ã¡ãã»ãŒãžããã€ã¢ãã°ã«è¡šç€ºããŸãã
{%SET_USER_DATA(Wk,Name,äŒè€)}
{%MSGBOX({%GET_USER_DATA(Wk,Name)})}
åŒæ°ã®ã¡ãã»ãŒãžãå ¥åãã€ã¢ãã°ã«è¡šç€ºããŠãå ¥åå€ãè¿åŽããŸãã
{%SET_USER_DATA(Wk,Name,{%INPUTBOX(æ°åãå ¥åããŠãã ããã)})}
æååãã¯ãªããããŒãã«èšæ¶ããŸãã
{%SET_CLIPBOARD_TEXT(ABC)}
ã¯ãªããããŒãã«èšæ¶ãããæååãååŸããŸãã
{%GET_CLIPBOARD_TEXT()}
ãšã©ãŒãçºçãããŸããéåžžã®ãšã©ãŒãšåæ§ã«ãåŠçäžã®åŠçãäžæããŸããåŒæ°ã«ãšã©ãŒã¡ãã»ãŒãžãæå®ããããšãã§ããŸãã
IFãã¯ããšäœµçšããæ¡ä»¶ã«ãããšã©ãŒãçºçãããŠäœ¿ããŸãã
{%IF(({%EXISTS_USER_DATA(ååããŒã¿,A001-00123)}=True,,{%RAISE_ERROR(nameãèŠã€ãããŸãã)})}
ãã°åºåãã¯ã(WRITE_LOG)ãåã³ãšã©ãŒãã°åºåãã¯ã(WRITE_ERROR_LOG)ã§åºåãããã°ã®ãã©ãŒããããèšå®ããŸãã
åŒæ°æååã«{0}ãå«ããŠãã ããããã°ã®åºåæã«ãã°åºåãã¯ãã§æå®ããã¡ãã»ãŒãžã®å 容ã{0}ã®äœçœ®ã«åºåãããŸãã
åŒæ°æååã«ãã¯ããæå®ããå Žåã¯ãSET_LOG_FORMATãå®è¡ããããšãã«ã¯ãã¯ãã®å®è¡ã¯è¡ãããŸããããã°ãåºåãããšãã«æå®ãããã¯ããå®è¡ãããŸãã
ãã°ã®åºåã§è¡ããããã¯ãã®å®è¡ã§ãšã©ãŒãçºçããå Žåã¯å šãŠç¡èŠãããŸãã
ãã®ãã¯ãã¯äžåºŠèšå®ãããšã¡ã¢ãªã«ä¿æãããã¢ããªã±ãŒã·ã§ã³ã®çµäºãŸã§æå¹ãšãªããŸãã
ãã®ãã¯ããäœåºŠãå®è¡ããå Žåã¯ãåŒã³åºã床ã«èšå®å€ãäžæžããããŸãã
ã¹ã±ãžã¥ãŒã©ãŒã®å ±éèšå®ã®ç£èŠéå§æã®ãã¯ãã«èšè¿°ãããšãµãŒãã¹éå§æãã¹ã±ãžã¥ãŒã©ãŒã®ç£èŠéå§æã«å®è¡ããã以åŸã®ãã°åºåãã¯ããã¹ãŠã«é©çšãããŸãã
{%SET_LOG_FORMAT(â {%GET(SettingName)} {0})} {%WRITE_LOG(å€å®:{%GET_U(屿§,å€å®)})} èšå®åããQRã³ãŒãèªã¿åãããå€å®ã®å 容ããTrueãã®å Žåã以äžã®ããã«åºåãããŸãã 2024/05/01 15:23:29 44 æ£åžž â QRã³ãŒãèªã¿åã å€å®:True ãã¯ãå[WRITE_LOG] {%WRITE_LOG(åŠçãå®è¡ããŸããã)}
åŠççµæã«ã¡ãã»ãŒãžãåºåããŸãããã°èšå®ãæå¹ã«ãªã£ãŠããã°ãéåžžã®ãã°ãšäžç·ã«åºåãããŸãã
{%WRITE_LOG(åŠçãå®è¡ããŸããã)}
åŠççµæã«ãšã©ãŒã¡ãã»ãŒãžãåºåããŸãããã°èšå®ãæå¹ã«ãªã£ãŠããã°ãéåžžã®ãšã©ãŒãã°ãšäžç·ã«åºåãããŸããæ¬ãã¯ãã¯ãšã©ãŒãã°ãåºåããã ãã§ããšã©ãŒã¯çºçããŸããããšã©ãŒãçºçããããå Žåã¯RAISE_ERRORãã¯ãã䜿çšããŠãã ããã
{%WRITE_ERROR_LOG(ãšã©ãŒãçºçããŸããã)}
åŒæ°ã§æå®ãããç§æ°ã ãåŸ æ©ããŸããåŒæ°ã¯ããªç§ã§æå®ããŸãã
{%SLEEP(1000)}
SMTPãµãŒãã®æ å ±ã¯ãã¡ãŒã«ãµãŒããŒèšå®ããå³ã¯ãªãã¯ã§ã¡ãŒã«ãµãŒããŒã远å ããèšå®ãè¡ã£ãŠãã ããã SMTPãµãŒãã®èšå®ãè¡ãããŠããªãå Žåã¯ã¡ãŒã«éä¿¡ãã§ããŸãããã¡ãŒã«éä¿¡ãã¯ãã䜿çšããå Žåã¯ãå¿ ãèšå®ããŠãã ããã
åŒæ°ã®èª¬æã¯ä»¥äžã®éãã§ãã
åŒæ° | å 容 |
---|---|
ã¡ãŒã«ãµãŒããŒèšå®å | ã¡ãŒã«ãµãŒããŒèšå®ã®ã¡ãŒã«ãµãŒããŒåãæå®ããŸãã |
ããŒã¿å(å®å ) | ãŠãŒã¶ãŒããŒã¿åãæå®ããŸããäºåã«ãŠãŒã¶ãŒããŒã¿ã«å®å ã®ã¡ãŒã«ã¢ãã¬ã¹ãå€ã«èšå®ããŸããããŒã¯äœã§ãOKã§ãã |
éä¿¡å ã¡ãŒã«ã¢ãã¬ã¹ | éä¿¡å ã¡ãŒã«ã¢ãã¬ã¹ãæå®ããŸãã |
ããŒã¿å(CC) | ãŠãŒã¶ãŒããŒã¿åãæå®ããŸããäºåã«ãŠãŒã¶ãŒããŒã¿ã«CCã®å®å ã®ã¡ãŒã«ã¢ãã¬ã¹ãå€ã«èšå®ããŸããããŒã¯äœã§ãOKã§ããçç¥å¯ã |
ããŒã¿å(BCC) | ãŠãŒã¶ãŒããŒã¿åãæå®ããŸããäºåã«ãŠãŒã¶ãŒããŒã¿ã«BCCã®å®å ã®ã¡ãŒã«ã¢ãã¬ã¹ãå€ã«èšå®ããŸããããŒã¯äœã§ãOKã§ããçç¥å¯ã |
ä»¶å | ä»¶åãæå®ããŸãã |
æ¬æ | æ¬æãæå®ããŸãã |
ããŒã¿å(ãã¡ã€ã«) | ãŠãŒã¶ãŒããŒã¿åãæå®ããŸããäºåã«ãŠãŒã¶ãŒããŒã¿ã«æ·»ä»ãã¡ã€ã«ã®ãã«ãã¹ãå€ã«èšå®ããŸããããŒã¯äœã§ãOKã§ããçç¥å¯ã |
ããŒã¿å(ãšã©ãŒååŸçš) |
ãŠãŒã¶ãŒããŒã¿åãæå®ããŸãããã®åŒæ°ãæå®ãããšãã¡ãŒã«éä¿¡æã«ã¡ãŒã«ãµãŒããŒãããšã©ãŒãè¿ã£ãŠçãå Žåã«ãšã©ãŒãçºçããããåŠçãç¶è¡ããŸãã çç¥å¯ã ã¡ãŒã«ãµãŒããŒããè¿ããããšã©ãŒã¡ãã»ãŒãžã¯ãæå®ãããŠãŒã¶ãŒããŒã¿ã®Messageã«æ ŒçŽãããŸãã |
ã¡ãŒã«éä¿¡æã«ãã¡ãŒã«ãµãŒãã®ç°åžžãªã©ã§éä¿¡ãšã©ãŒãçºçããå Žåã¯ãåŠçããšã©ãŒã«ãªããŸãããã¯ãã®æ»ãå€ã¯ãæ£åžžæã«ãTureããè¿åŽããããšã©ãŒæã¯ãã¯ãåŠçãäžæãããæåŸãŸã§åŠçãè¡ãããŸããã(ãšã©ãŒååŸçšã®ãŠãŒã¶ãŒããŒã¿ãåŒæ°ã«æå®ããå Žåã¯ããã¯ãã¯äžæããããæ»ãå€ã«ãFalseããè¿åŽãããŸãã)
{%SET_U(å®å ,1,tom@test.com)} {%SET_U(æ·»ä»ãã¡ã€ã«,1,{%GET(FullPathFileName)})} {%SEND_MAIL(ã¡ãŒã«ãµãŒããŒ1,å®å ,jerry@test.com,,,èªåéä¿¡ã¡ãŒã«,ãã®ã¡ãŒã«ã¯eDocArrangementããã®èªåéä¿¡ã¡ãŒã«ã§ãã,æ·»ä»ãã¡ã€ã«)}
{%SET_U(å®å ,1,tom@test.com)} {%IF({%SEND_MAIL(ã¡ãŒã«ãµãŒããŒ1,å®å ,jerry@test.com,,,èªåéä¿¡ã¡ãŒã«,ãã®ã¡ãŒã«ã¯eDocArrangementããã®èªåéä¿¡ã¡ãŒã«ã§ãã,,CatchError)}=False, {%WRITE_LOG({%GET_U(CatchError,Message)})} ,)}
å ¥åãã¡ã€ã«åã«æå®ããããã¹ããã¡ã€ã«ãããå¶åŸ¡ã³ãŒããé€å»ããåºåãã¡ã€ã«åã«æå®ãããã¡ã€ã«ã«åºåããŸãã
åŠçå¯èœãªããã¹ããã¡ã€ã«ã®æåã³ãŒãã¯SJISã®ã¿ã§ããé€å»ã®å¯Ÿè±¡ãšãªãæåã³ãŒãã¯16é²ã³ãŒãã§00ïœ1F,7Fã§ããäœããæ¹è¡(0A)ãã¿ã(09)ã埩垰(0D)ã¯é€å»ããŸããã
åºåãã¡ã€ã«ããããã¯ãŒã¯ãã©ã«ãã«æå®ãããšãåŠçé床ãé ããªããŸãã®ã§ãããŒã«ã«ãã©ã«ãã«åºåããããã«ããŠãã ããã
{%REMOVE_CONTROL_CHAR(C:\Test\Test.csv,C:\Test\Test_Out.csv)}
ã³ãã³ããå®è¡ããŸããæ»ãå€ã«å®è¡ããã³ãã³ãã®ãªã¿ãŒã³ã³ãŒããè¿ããŸãã
Asyncãæå®ããªãå Žåã¯ãå®è¡ããã³ãã³ããçµäºãããŸã§åŸ æ©ããŸããã³ãã³ããçµäºããªãå Žåã¯æ°žä¹ ã«åŸ æ©ããŠããŸããŸãã®ã§ããããªã£ãå Žåã¯ã¿ã¹ã¯ãããŒãžã£ãŒã§eDocArrangementã匷å¶çµäºããŠäžããã
Asyncãæå®ããå Žåã¯ãã³ãã³ãå®è¡åŸã«çŽãã«å¶åŸ¡ãæ»ããŸããã³ãã³ãã¯éåæã§å®è¡ãããŸãã
éåæã§åŠçãè¡ãå Žåã¯ãåŠçã®å 容ãååã«çè§£ããåæã«åŠçãè¡ãããããšã§åé¡ãçããªãããã«ããå¿ èŠããããŸãããã©ãã«ã®çºçæã«ã¯éåæåŠçã®åé¡è§£æ±ºã¯ãããé«åºŠãªã¹ãã«ãå¿ èŠã«ãªããŸããéåæåŠçã®å 容çè§£ãååã§ãªãå Žåã¯éåæåŠçã䜿çšããªãã§ãã ããã
{%COMMAND(C:\Home\Demo\System\picturetool.exe,-i C:\Home\Demo\in\in.jpg -o C:\Home\Demo\out\out.png -t 100|,100|,200|,200)}
ããã¹ããã¡ã€ã«ã«èšè¿°ããããã¯ããèªã¿èŸŒã¿ãå®è¡ããŸãã
ãšã³ã³ãŒããæå®ã§ããŸããçç¥ãããšSJISã§èªã¿èŸŒã¿ãŸãã
æ¬ãã¯ãã¯å ¥åãã¡ã€ã«çãåŠçãããšãæªæã®ããã³ãŒããå®è¡ããããšãã§ããŠããŸããŸããã»ãã¥ãªãã£ãŒã«ååæ³šæããŠäœ¿çšããŠãã ããã
{%LOAD_MACRO(D:\Home\Macro\macro.txt)}
ããŒéä¿¡ãè¡ããŸãã
åããŒã¯ã1ã€ãŸãã¯è€æ°ã®æåã§è¡šãããŸãã 1ã€ã®ããŒããŒãæåãæå®ããã«ã¯ãæåèªäœã䜿çšããŸãã ããšãã°ãæå A ã衚ãã«ã¯ãæåå "A" ãã¡ãœããã«æž¡ããŸãã AãBãããã³ C ãšããæåã衚ãã«ã¯ãåŒãæ°ã« "ABC" æå®ããŸãã
æ£ç¬Šå· (+)ããã£ã¬ãã (^)ãããŒã»ã³ãèšå· (%)ããã«ã (~)ãããã³ãã£ã () ã¯ãç¹å¥ãªæå³ãæã¡ãŸãã ãããã®æåã®ãããããæå®ããã«ã¯ãäžãã£ã{}ã§å²ã¿ãŸãã ããšãã°ããã©ã¹èšå·ãæå®ããã«ã¯ã"{+}" ã䜿çšããŸãã äžãã£ãæåãæå®ããã«ã¯ã"{{}" ããã³ "}" ã䜿çšããŸãã è§ãã£ã[]ã¯ç¹å¥ãªæå³ãæã¡ãŸããã
ã㌠| ã³ãŒã |
---|---|
BackSpace | {BACKSPACE} ãŸã㯠{BS} |
DELETE | {DELETE} ãŸã㯠{DEL} |
äžæ¹åã㌠| {UP} |
峿¹åã㌠| {RIGHT} |
äžæ¹åã㌠| {DOWN} |
å·Šæ¹åã㌠| {LEFT} |
ENTER | {ENTER}ãŸãã¯~ |
ESC | {ESCAPE} ãŸã㯠{ESC} |
Tab | {TAB} |
äžæ¹åã㌠| {DOWN} |
F1 ~ F15 | {F1} ãã {F15} ãŸã§ |
Altã㌠| % |
Ctrlã㌠| ^ |
Shftã㌠| +() |
{%SEND_KEYS(test{TAB})}
{%SEND_KEYS(^a)}
{%SEND_KEYS(+(^a))}
åŒæ°ã®ã¿ã€ãã«ãšåããŠã€ã³ããŠãæ¢ããŠåé¢ã«ããã
{%SET_FOREGROUND_WINDOW(ç¡é¡ - ã¡ã¢åž³)}
ããªã³ã¿ãŒãæå¹ã§ããå Žåã¯Trueãè¿åŽããŸãã
å€å®åŠçãšããŠã¯ãããªã³ã¿ãŒãããžã§ãæ°ãæ£åžžã«ååŸã§ãããã®ãã§ãã¯ãè¡ã£ãŠããŸãã
ããªã³ã¿ãŒãå¿çäžèœãªã©ã®ç¶æ ã«ãªã£ãå Žåã¯ãããªã³ã¿ãŒã®ç¶æ ãååŸããåŠçã§äŸå€ãçºçããããã«ãªããŸãã
ãã®äŸå€ãæ€ç¥ããå Žåã¯Falseãè¿åŽããŸãã
ããªã³ã¿ãŒãäžæåæ¢ãªã©ã®ã¹ããŒã¿ã¹çã¯èª¿ã¹ãŠãããŸãããããªã³ã¿ãŒã®ããããã£ãäžæåæ¢äžããç©çããªã³ã¿ãŒã®ç¶æ ãšã©ãŒã®å Žåã§ããããªã³ã¿ãŒãç°åžžç¶æ ã§ãªããã°Trueãè¿åŽãããŸãã
ãMicrosoft Print to PDFãããDocuWorks PDFããªã©ã®ä»®æ³ããªã³ã¿ãŒã¯äžæåæ¢äžã§ãã£ãŠãPDFåºåã¯è¡ãããããã§ãã
ååšããªãããªã³ã¿ãŒåãæå®ããå Žåã¯ãšã©ãŒãçºçããŸãã
ãã®ãã¯ããFalseãè¿åŽããå Žåã¯ãæå®ããããªã³ã¿ãŒã䜿çšäžå¯èœãªç¶æ ã«ãªã£ãŠãããPCãåèµ·åãããŸã§åŸ©æ§ããªãå¯èœæ§ãé«ãã§ãã
{%PRINTER_IS_ENABLED(DocuWorks PDF)}
eDocArrangement2ã®èšå®ãã¡ã€ã«ã®ãã©ã«ããã¹ãååŸããŸãã
ãã°ãªã³äžã®ãŠãŒã¶ãŒåãååŸããŸãã(ãµãŒãã¹ããå®è¡ããŠããå Žåã¯ãµãŒãã¹ã®ã³ã³ãããŒã«ããã«ã®ãã°ãªã³ã¿ãã§èšå®ãããŠãŒã¶ãŒã«ãªããŸãã)