{"id":785,"date":"2024-06-19T09:29:00","date_gmt":"2024-06-19T01:29:00","guid":{"rendered":"http:\/\/www.wyrcad.com\/?p=785"},"modified":"2024-07-25T15:41:05","modified_gmt":"2024-07-25T07:41:05","slug":"%e7%94%9f%e6%88%90%e9%9a%8f%e6%9c%ba%e5%90%8d%e7%a7%b0","status":"publish","type":"post","link":"https:\/\/www.wyrcad.com\/?p=785","title":{"rendered":"\u5b57\u7b26\u4e32\u51fd\u6570\u7cfb\u5217\u4e4b\u4e00"},"content":{"rendered":"\n<p>Public Function SelName(ByVal iNumber As Integer) As String &#8216;\u751f\u6210 iNumber \u4f4d\u6570\u7684\u5b57\u7b26\u4e32<br>Dim I As Integer, J As Integer<br>Dim ReservedArray As Variant<br>ReservedArray = Array(&#8220;MANUALLY&#8221;, &#8220;SUPPORT&#8221;, &#8220;OHTLLINE&#8221;, &#8220;ACAD&#8221;, &#8220;WCAD&#8221;)<br>ERR_AVOID:<br>SelName = &#8220;&#8221;<br>Randomize<br>For I = 1 To iNumber<br>SelName = SelName &amp; Chr((64 + Int((26 * Rnd) + 1)))<br>Next I<br>If <a href=\"https:\/\/www.wyrcad.com\/?p=798\">IsInArray<\/a>(SelName, ReservedArray) Then GoTo ERR_AVOID<br>End Function<\/p>\n\n\n\n<p>Public Function CountStr(ByVal bOverlapable As Boolean, ByVal sMom As String, ByVal sSon As String) As Integer \u2018sSon \u5728 sMom \u4e2d\u51fa\u73b0\u7684\u6b21\u6570<br>CountStr = 0<br>Do While InStr(1, sMom, sSon, vbTextCompare) &gt; 0<br>CountStr = CountStr + 1<br>If bOverlapable Then \u2018\u5141\u8bb8\u91cd\u590d\u8ba1\u6570,\u5982 nnn \u4e2d\u542b\u4e24\u4e2a nn<br>sMom = Right(sMom, Len(sMom) \u2013 InStr(1, sMom, sSon, vbTextCompare))<br>Else \u2018\u4e0d\u5141\u8bb8\u91cd\u590d\u8ba1\u6570,\u5982 nnn \u4e2d\u542b\u4e00\u4e2a nn<br>sMom = Right(sMom, Len(sMom) \u2013 InStr(1, sMom, sSon, vbTextCompare) \u2013 (Len(sSon) \u2013 1))<br>End If<br>Loop<br>End Function<\/p>\n\n\n\n<p>Public Function ExtractDivide(ByVal sLetter As String, ByVal sData As String, ByVal iOrder As Integer) As String \u2018\u8bfb\u51fa\u7531 sLetter \u5206\u5272\u7684\u7b2c IOrder \u8282\u5b50\u5b57\u7b26\u4e32<br>ExtractDivide = \u201c\u201d<br>If sData = \u201c\u201d Then Exit Function<br>If iOrder &lt; 1 Then Exit Function If iOrder &gt; CountStr(False, sData, sLetter) + 1 Then Exit Function<br>sData = Trim(sData)<br>Dim TempArray As Variant<br>TempArray = Split(sData, sLetter, -1, vbTextCompare)<br>ExtractDivide = TempArray(iOrder \u2013 1)<br>ExtractDivide = Trim(ExtractDivide)<br>End Function<\/p>\n\n\n\n<p>Public Function CutLeft(ByVal sOriginal As String, ByVal sCut As String) As String &#8216;\u53bb\u6389\u5de6\u4fa7\u5b57\u7b26 sCut \u4e00\u6b21(\u5982\u679c\u6709)<br>CutLeft = LTrim(sOriginal)<br>If InStr(1, sOriginal, sCut, vbTextCompare) = 1 Then CutLeft = Right(sOriginal, Len(sOriginal) &#8211; Len(sCut))<br>End Function<\/p>\n\n\n\n<p>Public Function CutRight(ByVal sOriginal As String, ByVal sCut As String) As String &#8216;\u53bb\u6389\u53f3\u4fa7\u5b57\u7b26 sCut \u4e00\u6b21(\u5982\u679c\u6709)<br>CutRight = RTrim(sOriginal)<br>If CutRight = &#8220;&#8221; Then Exit Function<br>If InStrRev(sOriginal, sCut, -1, vbTextCompare) = Len(sOriginal) &#8211; Len(sCut) + 1 Then CutRight = Left(sOriginal, Len(sOriginal) &#8211; Len(sCut))<br>End Function<\/p>\n\n\n\n<p>Public Function CutTerminal(ByVal sOriginal As String, ByVal sCut As String) As String &#8216;\u53bb\u6389\u4e24\u7aef\u5b57\u7b26 sCut \u4e00\u6b21(\u5982\u679c\u6709)<br>CutTerminal = Trim(sOriginal)<br>CutTerminal = CutLeft(CutTerminal, sCut)<br>CutTerminal = CutRight(CutTerminal, sCut)<br>End Function<\/p>\n\n\n\n<p>Public Function PurgeLeft(ByVal sOriginal As String, ByVal sPurge As String) As String &#8216;\u53bb\u6389\u5de6\u4fa7\u5b57\u7b26 sPurge(\u6240\u6709)<br>sOriginal = LTrim(sOriginal)<br>If sPurge = vbCr Or sPurge = vbLf Or sPurge = vbCrLf Then<br>Do While Asc(Left(sOriginal, Len(sPurge))) = Asc(sPurge)<br>sOriginal = Right(sOriginal, Len(sOriginal) &#8211; Len(sPurge))<br>sOriginal = LTrim(sOriginal)<br>Loop<br>Else<br>Do While InStr(1, sOriginal, sPurge, vbTextCompare) = 1 And Len(sOriginal) &#8211; Len(sPurge) &gt; -1<br>sOriginal = Right(sOriginal, Len(sOriginal) &#8211; Len(sPurge))<br>sOriginal = LTrim(sOriginal)<br>Loop<br>End If<br>PurgeLeft = sOriginal<br>End Function<\/p>\n\n\n\n<p>Public Function PurgeRight(ByVal sOriginal As String, ByVal sPurge As String) As String &#8216;\u53bb\u6389\u53f3\u4fa7\u5b57\u7b26 sPurge(\u6240\u6709)<br>sOriginal = RTrim(sOriginal)<br>If sPurge = vbCr Or sPurge = vbLf Or sPurge = vbCrLf Then<br>Do While Asc(Right(sOriginal, Len(sPurge))) = Asc(sPurge)<br>sOriginal = Left(sOriginal, Len(sOriginal) &#8211; Len(sPurge))<br>sOriginal = RTrim(sOriginal)<br>Loop<br>Else<br>Do While InStrRev(sOriginal, sPurge, -1, vbTextCompare) = Len(sOriginal) &#8211; Len(sPurge) + 1 And Len(sOriginal) &#8211; Len(sPurge) &gt; -1<br>sOriginal = Left(sOriginal, Len(sOriginal) &#8211; Len(sPurge))<br>sOriginal = RTrim(sOriginal)<br>Loop<br>End If<br>PurgeRight = sOriginal<br>End Function<\/p>\n\n\n\n<p>Public Function PurgeTerminal(ByVal sOriginal As String, ByVal sPurge As String) As String &#8216;\u53bb\u6389\u4e24\u7aef\u5b57\u7b26 sPurge(\u6240\u6709)<br>sOriginal = PurgeLeft(sOriginal, sPurge)<br>sOriginal = PurgeRight(sOriginal, sPurge)<br>PurgeTerminal = sOriginal<br>End Function<\/p>\n\n\n\n<p>Public Function GetAPIString(ByVal sAPI As String) As String &#8216;\u5b57\u7b26\u5305\u88c5\uff0c\u7528\u4e8e\u5904\u7406 API \u8fd4\u56de\u5b57\u7b26<br>On Error Resume Next<br>Dim iZeroPos As Integer<br>iZeroPos = InStr(sAPI, Chr$(0))<br>If iZeroPos &gt; 0 Then<br>GetAPIString = Left$(sAPI, iZeroPos &#8211; 1)<br>Else<br>GetAPIString = sAPI<br>End If<br>On Error GoTo 0<br>End Function<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Public Function SelName(ByVal iNumber As Integer) As St &hellip; <a href=\"https:\/\/www.wyrcad.com\/?p=785\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb<span class=\"screen-reader-text\">\u201c\u5b57\u7b26\u4e32\u51fd\u6570\u7cfb\u5217\u4e4b\u4e00\u201d<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[24,17],"class_list":["post-785","post","type-post","status-publish","format-standard","hentry","category-bianchengyuandi","tag-vb","tag-biancheng"],"_links":{"self":[{"href":"https:\/\/www.wyrcad.com\/index.php?rest_route=\/wp\/v2\/posts\/785","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wyrcad.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wyrcad.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wyrcad.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wyrcad.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=785"}],"version-history":[{"count":12,"href":"https:\/\/www.wyrcad.com\/index.php?rest_route=\/wp\/v2\/posts\/785\/revisions"}],"predecessor-version":[{"id":1423,"href":"https:\/\/www.wyrcad.com\/index.php?rest_route=\/wp\/v2\/posts\/785\/revisions\/1423"}],"wp:attachment":[{"href":"https:\/\/www.wyrcad.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=785"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wyrcad.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=785"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wyrcad.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=785"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}