使ç¨InStr å½æ°ï¼è¿å Variant (Long)ï¼æå®ä¸å符串å¨å¦ä¸å符串ä¸æå åºç°çä½ç½®ã
InStr å½æ°ç¤ºä¾
æ¬ç¤ºä¾ä½¿ç¨ InStr å½æ°æ¥æ¥æ¾æå符串å¨å¦ä¸ä¸ªå符串ä¸é¦æ¬¡åºç°çä½ç½®ã
Dim SearchString, SearchChar, MyPos
SearchString ="XXpXXpXXPXXP" ' 被æç´¢çå符串ã
SearchChar = "P" ' è¦æ¥æ¾å符串 "P"ã
' ä»ç¬¬å个å符å¼å§ï¼ä»¥ææ¬æ¯è¾çæ¹å¼æ¾èµ·ãè¿åå¼ä¸º 6ï¼å°å pï¼ã
' å°å p å大å P å¨ææ¬æ¯è¾ä¸æ¯ä¸æ ·çã
MyPos = Instr(4, SearchString, SearchChar, 1)
' ä»ç¬¬ä¸ä¸ªå符å¼ä½¿ï¼ä»¥äºè¿å¶æ¯è¾çæ¹å¼æ¾èµ·ãè¿åå¼ä¸º 9ï¼å¤§å Pï¼ã
' å°å p å大å P å¨äºè¿å¶æ¯è¾ä¸æ¯ä¸ä¸æ ·çã
MyPos = Instr(1, SearchString, SearchChar, 0)
' 缺ççæ¯å¯¹æ¹å¼ä¸ºäºè¿å¶æ¯è¾ï¼æåä¸ä¸ªåæ°å¯çç¥ï¼ã
MyPos = Instr(SearchString, SearchChar) ' è¿å 9ã
MyPos = Instr(1, SearchString, "W") ' è¿å 0ã
使ç¨Mid å½æ°ï¼
è¿å Variant
(String)ï¼å
¶ä¸å
å«å符串ä¸æå®æ°éçå符ã
Mid å½æ°ç¤ºä¾
æ¬ç¤ºä¾ä½¿ç¨ Mid è¯å¥æ¥å¾å°æ个å符串ä¸çå 个å符ã
Dim MyString, FirstWord, LastWord, MidWords
MyString = "Mid Function Demo" 建ç«ä¸ä¸ªå符串ã
FirstWord = Mid(MyString, 1, 3) ' è¿å "Mid"ã
LastWord = Mid(MyString, 14, 4) ' è¿å "Demo"ã
MidWords = Mid(MyString, 5) ' è¿å "Funcion Demo"ã
ç»å两个å½æ°ä½¿ç¨ï¼å è·åæ个å符å¨å符串ä½ç½®ï¼åç¨Midå½æ°è·å该å符ä¹åçææå符ï¼è§ä¸è¡ä¾å¥ã