tag:blogger.com,1999:blog-79107024405478719432024-10-25T15:16:39.026+08:00彰化一整天http://www.blogger.com/profile/11001464277385710704noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-7910702440547871943.post-36972425348794464222010-11-12T13:55:00.003+08:002019-04-03T17:37:07.597+08:00變數名稱:<input id="sqlName" name="sqlName" value="strSQL" /> <br /> <br /> <a href="http://272586.blogspot.com/search/label/%E7%B6%B2%E9%A0%81%E5%B7%A5%E5%85%B7">此工具說明文件</a>　　<a href="http://272586.blogspot.com/2007/12/blog-post.html">如何離線使用此工具</a>　　　<a href="http://f272586.googlepages.com/272586.htm">精簡版網址</a><br /> <br /> 來源(分隔符號為Tab,換行符號為Enter):<input name="Run" onclick="clearsource()" type="button" value="清除來源目的區資料" /> <br /> <br /> <br /> <span style="color: red;"><strong>※此工具只可以在Window xp下的IE Browser中正常使用※</strong></span><br /> 若是使用chrome可以參考底下連結<br /> <a href="http://blog.bestdaylong.com/2019/04/chromechromeie.html">http://blog.bestdaylong.com/2019/04/chromechromeie.html</a><br />【chrome教學】如何在chrome使用外掛ie瀏覽舊網頁<br /> <textarea cols="50" id="Source" name="Source" rows="10"></textarea> <br /> <br /> 目的: <br /> <br /> <textarea cols="50" id="Destination" name="Destination" rows="10"></textarea> <br /> <br /> <strong><span style="color: red;">如果要看功能說明,請點按鈕右邊的?，E代表此功能有Excel版本，就可以查看該按鈕使用方法</span></strong> <br /> <br /> 針對Sql語法在微軟程式中無法多行顯示所設計 <br /> <br /> <input name="Run" onclick="trans()" type="button" value="字串轉換" /><a href="http://272586.blogspot.com/2007/07/blog-post_10.html">?</a><input name="Run" onclick="transBefore()" type="button" value="字串還原" /> <a href="http://272586.blogspot.com/2007/07/blog-post_10.html">?</a> <br /> <br /> 針對php設計語法轉換的工具 <br /> <br /> <input name="Run" onclick="transPost()" type="button" value="轉換POST" /> <input name="Run" onclick="transRow()" type="button" value="轉換Row" /> <input name="Run" onclick="transIns()" type="button" value="轉換Insert SQL" /> <input name="Run" onclick="transUpd()" type="button" value="轉換Update SQL" /> <input name="Run" onclick="transForm()" type="button" value="轉換Form" /> <input name="Run" onclick="transFormBR()" type="button" value="轉換Form(無表格)" /><input name="Run" onclick="transNormal()" type="button" value="轉換一般顯示" /><input name="Run" onclick="transXML()" type="button" value="轉換XML" /> <input name="Run" onclick="transTable1()" type="button" value="轉換Table(橫)" /><input name="Run" onclick="transTable2()" type="button" value="轉換Table(直)" /><input name="Run" onclick="transTable3()" type="button" value="轉換條列式(直)" /> <input name="Run" onclick="transString()" type="button" value="轉換字串" /> <input name="Run" onclick="transArray()" type="button" value="轉換陣列" /><br /> <input name="Run" onclick="transFormHidden_php()" type="button" value="轉換隱藏欄位" /><br /> 針對asp設計語法轉換的工具 <br /> <br /> <input name="Run" onclick="transRequest()" type="button" value="Request" /> <input name="Run" onclick="transResponse()" type="button" value="Response" /> <input name="Run" onclick="transRs()" type="button" value="RS" /> <input name="Run" onclick="transToRs()" type="button" value="TO_RS" /> <input name="Run" onclick="transInsAsp()" type="button" value="InsertSQL" /> <input name="Run" onclick="transUpdAsp()" type="button" value="UpdateSQL" /> <input name="Run" onclick="transTable1_asp()" type="button" value="轉換Table(橫)" /><input name="Run" onclick="transTable2_asp()" type="button" value="轉換Table(直)" /><input name="Run" onclick="transFormHidden_asp()" type="button" value="轉換隱藏欄位" /><br /> <br /> <br /> 針對SQL語法轉換的工具 <br /> <br /> <input name="Run" onclick="insertsql()" type="button" value="Insert SQL" /> <a href="http://272586.blogspot.com/2007/08/sqlinsert.html">?</a> <input name="Run" onclick="updatesql()" type="button" value="Update SQL" /> <a href="http://272586.blogspot.com/2007/08/sqlupdate.html">?</a> <input name="Run" onclick="insql()" type="button" value="In SQL" /> <br /> <br /> 針對excel設計語法轉換的工具 <br /> <br /> <input name="Run" onclick="clearformat()" type="button" value="清除格式" /><a href="http://272586.blogspot.com/2007/09/excel_28.html">?</a><input name="Run" onclick="clearrightformat()" type="button" value="清除最後一碼" /><a href="http://272586.blogspot.com/2007/09/excel_21.html">?</a><input name="Run" onclick="clearleftformat()" type="button" value="清除第一碼" /><input name="Run" onclick="yeartochiyear()" type="button" value="西元變民國" /> <input name="Run" onclick="chiyeartoyear()" type="button" value="民國變西元" /><a href="http://272586.blogspot.com/2008/03/blog-post_21.html">?</a><input name="Run" onclick="splitspace()" type="button" value="切割字串(空白隔開)" /><a href="http://272586.blogspot.com/2007/10/excel_23.html">?</a><input name="Run" onclick="string_split()" type="button" value="切割字串(依長度)" /> <input name="Run" onclick="combinestring()" type="button" value="合併字串" /> <a href="http://272586.blogspot.com/2007/12/excel_07.html">?</a> <input name="Run" onclick="addmonth()" type="button" value="產生遞增月份" /> <a href="http://272586.blogspot.com/2007/05/blog-post_17.html">?</a> <input name="Run" onclick="addmail()" type="button" value="Email自動分組(加分號)" /> <a href="http://272586.blogspot.com/2007/05/mail.html">?</a> <input name="Run" onclick="addNewLine()" type="button" value="自動補空白列" /> <a href="http://272586.blogspot.com/2008/03/excelword.html">?</a> ．<a href="http://272586.blogspot.com/2009/08/excelexcel-vba.html" target="_blank">E</a> <input name="Run" onclick="delNewLine()" type="button" value="去除換行" /> <input name="Run" onclick="compareab()" type="button" value="比較ab資料" /> <a href="http://272586.blogspot.com/2007/11/blog-post.html">?</a>．<a href="http://272586.blogspot.com/2009/04/excel.html" target="_blank">E</a> <input name="Run" onclick="level()" type="button" value="行列分割" /> <a href="http://272586.blogspot.com/2007/11/excel_27.html">?</a> <input name="Run" onclick="matrix()" type="button" value="矩陣轉換" /> <a href="http://272586.blogspot.com/2007/12/word.html">?</a> <input name="Run" onclick="formattext()" type="button" value="資料格式化" /> <a href="http://272586.blogspot.com/2008/03/blog-post_13.html">?</a>．<a href="http://272586.blogspot.com/2010/02/excel-vba.html" target="_blank">E</a><input name="Run" onclick="calcdate()" type="button" value="算年齡或年資" /> <a href="http://272586.blogspot.com/2008/05/excel.html">?</a> <input name="Run" onclick="train()" type="button" value="火車時刻表轉換" /> <a href="http://272586.blogspot.com/2008/07/blog-post_18.html">?</a> <input name="Run" onclick="merge_repeat()" type="button" value="合併重覆" /> <a href="http://272586.blogspot.com/2008/10/excel_17.html">?</a>．<a href="http://272586.blogspot.com/2009/09/excel_19.html" target="_blank">E</a> <input name="Run" onclick="unrepeat()" type="button" value="復原合併重覆" /> <input name="Run" onclick="find_column()" type="button" value="大批篩選資料" /> <a href="http://272586.blogspot.com/2008/11/excel.html">?</a>． <a href="http://272586.blogspot.com/2009/12/excel.html">E</a> <input name="Run" onclick="find_column_right()" type="button" value="大批篩選資料(以目的順序排序)" /> <input name="Run" onclick="trim_space()" type="button" value="去除左右空白" /> <br /> <br /> 針對html語法轉換的工具 <br /> <br /> <input name="Run" onclick="splithtml()" type="button" value="轉換hmtl語法" /><a href="http://272586.blogspot.com/2007/07/html.html">?</a><br /> <br /> <strong></strong>彰化一整天http://www.blogger.com/profile/11001464277385710704noreply@blogger.com1