VB / VBA 字串函數
<div class="post-body entry-content" style="line-height: 1.4; width: 520px; font-size: 13px; position: relative; color: rgb(50, 50, 50); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: -webkit-auto; ">最近用c#在寫 code，已經有一段時間沒有寫 VB Code，最近寫一些 VBA 程式連一些很基本字串函數快要忘光或搞混掉。順便作一下筆記整理整理，以便以後不時之需。<br><br>計算字串長度<br><div class="hlb" style="border: 1px solid rgb(255, 240, 185); background-color: rgb(255, 255, 221); padding-top: 9px; padding-bottom: 9px; padding-left: 9px; color: rgb(204, 102, 0); ">Len<span class="GRcorrect" id="GRmark_1d43454c49818803cb8b5362b753132fc120987d_(:0" grphrase="1d43454c49818803cb8b5362b753132fc120987d" grtype="null">(</span>string<span class="GRcorrect" id="GRmark_1d43454c49818803cb8b5362b753132fc120987d_):1" grphrase="1d43454c49818803cb8b5362b753132fc120987d" grtype="null">)</span>--------->return 整數值<br><br>範例<br>Dim x As String<br>Dim <span class="GRcorrect" id="GRmark_19e5212b0a494466033e6987b8774163ef066b4e_i:0" grphrase="19e5212b0a494466033e6987b8774163ef066b4e" grtype="null">i</span> As Integer<br><span class="GRcorrect" id="GRmark_d57b2bd096eec251cfaab79ff46663d7ebe851ba_i:0" grphrase="d57b2bd096eec251cfaab79ff46663d7ebe851ba" grtype="null">i</span> = Len<span class="GRcorrect" id="GRmark_d57b2bd096eec251cfaab79ff46663d7ebe851ba_(:1" grphrase="d57b2bd096eec251cfaab79ff46663d7ebe851ba" grtype="null">(</span>"string"<span class="GRcorrect" id="GRmark_d57b2bd096eec251cfaab79ff46663d7ebe851ba_):2" grphrase="d57b2bd096eec251cfaab79ff46663d7ebe851ba" grtype="null">)</span>---------> i=6<br></div><br>轉換英文字母大小寫<br><div class="hlb" style="border: 1px solid rgb(255, 240, 185); background-color: rgb(255, 255, 221); padding-top: 9px; padding-bottom: 9px; padding-left: 9px; color: rgb(204, 102, 0); ">UCase<span class="GRcorrect" id="GRmark_2dff71c6bca82930e3b760998d76f5c92785cb31_(:0" grphrase="2dff71c6bca82930e3b760998d76f5c92785cb31" grtype="null">(</span>string<span class="GRcorrect" id="GRmark_2dff71c6bca82930e3b760998d76f5c92785cb31_):1" grphrase="2dff71c6bca82930e3b760998d76f5c92785cb31" grtype="null">)</span>---------->將字串的小寫英文字母轉換成大寫<br>LCase<span class="GRcorrect" id="GRmark_784a5f2cf24f962a63defd9e5b2f2fbc6b9bf7a8_(:0" grphrase="784a5f2cf24f962a63defd9e5b2f2fbc6b9bf7a8" grtype="null">(</span>string<span class="GRcorrect" id="GRmark_784a5f2cf24f962a63defd9e5b2f2fbc6b9bf7a8_):1" grphrase="784a5f2cf24f962a63defd9e5b2f2fbc6b9bf7a8" grtype="null">)</span>---------->將字串的大寫英文字母轉換成小寫<br><br>範例<br><span class="GRcorrect" id="GRmark_8f1bc66ddbe2c0f0e24b93a4c2a9d0355a47f0a9_UCase:0" grphrase="8f1bc66ddbe2c0f0e24b93a4c2a9d0355a47f0a9" grtype="null">UCase</span><span class="GRcorrect" id="GRmark_8f1bc66ddbe2c0f0e24b93a4c2a9d0355a47f0a9_(:1" grphrase="8f1bc66ddbe2c0f0e24b93a4c2a9d0355a47f0a9" grtype="null">(</span>"<span class="GRcorrect" id="GRmark_8f1bc66ddbe2c0f0e24b93a4c2a9d0355a47f0a9_Abc:2" grphrase="8f1bc66ddbe2c0f0e24b93a4c2a9d0355a47f0a9" grtype="null">Abc</span>"<span class="GRcorrect" id="GRmark_8f1bc66ddbe2c0f0e24b93a4c2a9d0355a47f0a9_):3" grphrase="8f1bc66ddbe2c0f0e24b93a4c2a9d0355a47f0a9" grtype="null">)</span>--------->return ABC<br><span class="GRcorrect" id="GRmark_63b14ebc6cc3ccc96dc218270c655c73eaba90f4_LCase:0" grphrase="63b14ebc6cc3ccc96dc218270c655c73eaba90f4" grtype="null">LCase</span><span class="GRcorrect" id="GRmark_63b14ebc6cc3ccc96dc218270c655c73eaba90f4_(:1" grphrase="63b14ebc6cc3ccc96dc218270c655c73eaba90f4" grtype="null">(</span>"<span class="GRcorrect" id="GRmark_63b14ebc6cc3ccc96dc218270c655c73eaba90f4_Abc:2" grphrase="63b14ebc6cc3ccc96dc218270c655c73eaba90f4" grtype="null">Abc</span>"<span class="GRcorrect" id="GRmark_63b14ebc6cc3ccc96dc218270c655c73eaba90f4_):3" grphrase="63b14ebc6cc3ccc96dc218270c655c73eaba90f4" grtype="null">)</span>--------->return <span class="GRcorrect" id="GRmark_63b14ebc6cc3ccc96dc218270c655c73eaba90f4_abc:4" grphrase="63b14ebc6cc3ccc96dc218270c655c73eaba90f4" grtype="null">abc</span><br></div><br>取字串<br><div class="hlb" style="border: 1px solid rgb(255, 240, 185); background-color: rgb(255, 255, 221); padding-top: 9px; padding-bottom: 9px; padding-left: 9px; color: rgb(204, 102, 0); ">Left<span class="GRcorrect" id="GRmark_5a5cd05c6f8cdb5f8d33b3d3da13a9adeacc9c90_(:0" grphrase="5a5cd05c6f8cdb5f8d33b3d3da13a9adeacc9c90" grtype="null">(</span>string<span class="GRcorrect" id="GRmark_5a5cd05c6f8cdb5f8d33b3d3da13a9adeacc9c90_,:1" grphrase="5a5cd05c6f8cdb5f8d33b3d3da13a9adeacc9c90" grtype="null">,</span>n<span class="GRcorrect" id="GRmark_5a5cd05c6f8cdb5f8d33b3d3da13a9adeacc9c90_):2" grphrase="5a5cd05c6f8cdb5f8d33b3d3da13a9adeacc9c90" grtype="null">)</span>-------->從字串左邊取出n個字元<br>Right<span class="GRcorrect" id="GRmark_6d782c9b1f84b576b31df05e07b3cbb1011ea438_(:0" grphrase="6d782c9b1f84b576b31df05e07b3cbb1011ea438" grtype="null">(</span>string<span class="GRcorrect" id="GRmark_6d782c9b1f84b576b31df05e07b3cbb1011ea438_,:1" grphrase="6d782c9b1f84b576b31df05e07b3cbb1011ea438" grtype="null">,</span>n<span class="GRcorrect" id="GRmark_6d782c9b1f84b576b31df05e07b3cbb1011ea438_):2" grphrase="6d782c9b1f84b576b31df05e07b3cbb1011ea438" grtype="null">)</span>------->從字串右邊取出n個字元<br>Mid(string,n)--------->從字串第n個字元開始，取出所有字元<br>Mid(string,n,m)------->從字串第n個字元開始，取出m個字元<br><br>範例<br>Left<span class="GRcorrect" id="GRmark_6d66b10baa8a700841fce1c4f9d62bf93b5d48e9_(:0" grphrase="6d66b10baa8a700841fce1c4f9d62bf93b5d48e9" grtype="null">(</span>"123456"<span class="GRcorrect" id="GRmark_6d66b10baa8a700841fce1c4f9d62bf93b5d48e9_,:1" grphrase="6d66b10baa8a700841fce1c4f9d62bf93b5d48e9" grtype="null">,</span>3<span class="GRcorrect" id="GRmark_6d66b10baa8a700841fce1c4f9d62bf93b5d48e9_):2" grphrase="6d66b10baa8a700841fce1c4f9d62bf93b5d48e9" grtype="null">)</span>-------->return 123<br>Right<span class="GRcorrect" id="GRmark_70c2de878b0ec68689821c645a1685010efd2208_(:0" grphrase="70c2de878b0ec68689821c645a1685010efd2208" grtype="null">(</span>"123456"<span class="GRcorrect" id="GRmark_70c2de878b0ec68689821c645a1685010efd2208_):1" grphrase="70c2de878b0ec68689821c645a1685010efd2208" grtype="null">)</span>--------->return 456<br>Mid<span class="GRcorrect" id="GRmark_dd3a46ba5adeda021d57ef3d1370a50ae291bad0_(:0" grphrase="dd3a46ba5adeda021d57ef3d1370a50ae291bad0" grtype="null">(</span>"123456"<span class="GRcorrect" id="GRmark_dd3a46ba5adeda021d57ef3d1370a50ae291bad0_,:1" grphrase="dd3a46ba5adeda021d57ef3d1370a50ae291bad0" grtype="null">,</span>3<span class="GRcorrect" id="GRmark_dd3a46ba5adeda021d57ef3d1370a50ae291bad0_):2" grphrase="dd3a46ba5adeda021d57ef3d1370a50ae291bad0" grtype="null">)</span>--------->return 3456<br>Mid<span class="GRcorrect" id="GRmark_3d91fd070e06979c19d2af9ec01a8a5a7cf70147_(:0" grphrase="3d91fd070e06979c19d2af9ec01a8a5a7cf70147" grtype="null">(</span>"123456"<span class="GRcorrect" id="GRmark_3d91fd070e06979c19d2af9ec01a8a5a7cf70147_,:1" grphrase="3d91fd070e06979c19d2af9ec01a8a5a7cf70147" grtype="null">,</span>3,3<span class="GRcorrect" id="GRmark_3d91fd070e06979c19d2af9ec01a8a5a7cf70147_):2" grphrase="3d91fd070e06979c19d2af9ec01a8a5a7cf70147" grtype="null">)</span>------->return 345<br></div><br>字串取代<br><div class="hlb" style="border: 1px solid rgb(255, 240, 185); background-color: rgb(255, 255, 221); padding-top: 9px; padding-bottom: 9px; padding-left: 9px; color: rgb(204, 102, 0); ">Replace(字串,被取代的字串, 取代的字串)--------->將字串中某些字串取代成別的字串<br><br>範例<br>Replace<span class="GRcorrect" id="GRmark_2be7749153d8078d5f37f331609f4f715fabf6be_(:0" grphrase="2be7749153d8078d5f37f331609f4f715fabf6be" grtype="null">(</span>"AA_BB_CC","_","-"<span class="GRcorrect" id="GRmark_2be7749153d8078d5f37f331609f4f715fabf6be_):1" grphrase="2be7749153d8078d5f37f331609f4f715fabf6be" grtype="null">)</span>--------->return "AA-BB-CC"<br></div><br>尋找字串<br><div class="hlb" style="border: 1px solid rgb(255, 240, 185); background-color: rgb(255, 255, 221); padding-top: 9px; padding-bottom: 9px; padding-left: 9px; color: rgb(204, 102, 0); ">InStr(字串,尋找的字串)------------>從前面尋找字串第一次出現的位置<br>InStrRev(字串,尋找的字串)-------->從後面尋找字串第一次出現的位置<br><br>範例<br><span class="GRcorrect" id="GRmark_1904485b107e10dabde6c54de5b7261ffae7c126_InStr:0" grphrase="1904485b107e10dabde6c54de5b7261ffae7c126" grtype="null">InStr</span><span class="GRcorrect" id="GRmark_1904485b107e10dabde6c54de5b7261ffae7c126_(:1" grphrase="1904485b107e10dabde6c54de5b7261ffae7c126" grtype="null">(</span>"AA_BB_CC", "_"<span class="GRcorrect" id="GRmark_1904485b107e10dabde6c54de5b7261ffae7c126_):2" grphrase="1904485b107e10dabde6c54de5b7261ffae7c126" grtype="null">)</span>-------->return 3<br><span class="GRcorrect" id="GRmark_1a00fe748d6b39badb02ea124c91772d35f53aae_InStrRev:0" grphrase="1a00fe748d6b39badb02ea124c91772d35f53aae" grtype="null">InStrRev</span><span class="GRcorrect" id="GRmark_1a00fe748d6b39badb02ea124c91772d35f53aae_(:1" grphrase="1a00fe748d6b39badb02ea124c91772d35f53aae" grtype="null">(</span>"AA_BB_CC", "_"<span class="GRcorrect" id="GRmark_1a00fe748d6b39badb02ea124c91772d35f53aae_):2" grphrase="1a00fe748d6b39badb02ea124c91772d35f53aae" grtype="null">)</span>---->return 6<br></div><br>反轉字串<br><div class="hlb" style="border: 1px solid rgb(255, 240, 185); background-color: rgb(255, 255, 221); padding-top: 9px; padding-bottom: 9px; padding-left: 9px; color: rgb(204, 102, 0); ">StrReverse(字串)------------->將字串反轉<br><br>範例<br><span class="GRcorrect" id="GRmark_2c6e2617fa5756bdcd966b9213221b8043a96d30_StrReverse:0" grphrase="2c6e2617fa5756bdcd966b9213221b8043a96d30" grtype="null">StrReverse</span><span class="GRcorrect" id="GRmark_2c6e2617fa5756bdcd966b9213221b8043a96d30_(:1" grphrase="2c6e2617fa5756bdcd966b9213221b8043a96d30" grtype="null">(</span>"AA_BB_CC"<span class="GRcorrect" id="GRmark_2c6e2617fa5756bdcd966b9213221b8043a96d30_):2" grphrase="2c6e2617fa5756bdcd966b9213221b8043a96d30" grtype="null">)</span>------>return CC_BB_AA<br></div><br>產生空白字串<br><div class="hlb" style="border: 1px solid rgb(255, 240, 185); background-color: rgb(255, 255, 221); padding-top: 9px; padding-bottom: 9px; padding-left: 9px; color: rgb(204, 102, 0); ">Space<span class="GRcorrect" id="GRmark_372d93c9b3d21b9388461b0552be19e3b654e8f4_(:0" grphrase="372d93c9b3d21b9388461b0552be19e3b654e8f4" grtype="null">(</span>n<span class="GRcorrect" id="GRmark_372d93c9b3d21b9388461b0552be19e3b654e8f4_):1" grphrase="372d93c9b3d21b9388461b0552be19e3b654e8f4" grtype="null">)</span>---------->產生n個字元空白字串<br><br>範例<br>x= "AA" + Space<span class="GRcorrect" id="GRmark_d132853da851e3d0990947448b6b596a421fa6c3_(:0" grphrase="d132853da851e3d0990947448b6b596a421fa6c3" grtype="null">(</span>2) + "BB"--------->return AA BB<br></div><div style="clear: both; "></div></div><div class="post-footer" style="line-height: 1.6; margin: 20px -2px 0px; padding: 5px 10px; color: rgb(104, 104, 104); background-color: rgb(249, 249, 249); border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(238, 238, 238); font-size: 12px; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: -webkit-auto; "><div class="post-footer-line post-footer-line-1"><br></div></div>
頁:
[1]