VBÖÐ Replace º¯Êý
VBÖÐ Replace º¯Êý
ÃèÊö
·µ»Ø×Ö·û´®£¬ÆäÖÐÖ¸¶¨ÊýÄ¿µÄij×Ó×Ö·û´®±»Ì滻ΪÁíÒ»¸ö×Ó×Ö·û´®¡£
Óï·¨
Replace(expression, find, replacewith[, compare[, count[, start]]])
Replace º¯ÊýµÄÓï·¨ÓÐÒÔϲÎÊý£º
²ÎÊý ÃèÊö
expression ±ØÑ¡¡£×Ö·û´®±í´ïʽ£¬°üº¬ÒªÌæ»»µÄ×Ó×Ö·û´®¡£
find ±ØÑ¡¡£±»ËÑË÷µÄ×Ó×Ö·û´®¡£
replacewith ±ØÑ¡¡£ÓÃÓÚÌæ»»µÄ×Ó×Ö·û´®¡£
start ¿ÉÑ¡¡£expression ÖпªÊ¼ËÑË÷×Ó×Ö·û´®µÄλÖá£Èç¹ûÊ¡ÂÔ£¬Ä¬ÈÏֵΪ 1¡£
count ¿ÉÑ¡¡£Ö´ÐÐ×Ó×Ö·û´®Ìæ»»µÄÊýÄ¿¡£Èç¹ûÊ¡ÂÔ£¬Ä¬ÈÏֵΪ -1£¬±íʾ½øÐÐËùÓпÉÄܵÄÌæ»»¡£
compare ¿ÉÑ¡¡£Ö¸Ê¾ÔÚ¼ÆËã×Ó×Ö·û´®Ê±Ê¹ÓõıȽÏÀàÐ͵ÄÊýÖµ¡£ÓйØÊýÖµ£¬Çë²ÎÔÄ“ÉèÖÔ²¿·Ö¡£
ÉèÖÃ
compare ²ÎÊý¿ÉÒÔÓÐÒÔÏÂÖµ£º
³£Êý Öµ ÃèÊö
vbBinaryCompare 0 Ö´Ðжþ½øÖƱȽϡ£
vbTextCompare 1 Ö´ÐÐÎı¾±È½Ï¡£
vbDatabaseCompare 2 Ö´ÐлùÓÚÊý¾Ý¿â£¨ÔÚ´ËÊý¾Ý¿âÖÐÖ´ÐбȽϣ©Öаüº¬µÄÐÅÏ¢µÄ±È½Ï¡£
·µ»ØÖµ
Replace ·µ»ØÒÔÏÂÖµ£º
Èç¹û Replace ·µ»Ø
expression ΪÁ㳤¶È Á㳤¶È×Ö·û´® ("")¡£
expression Ϊ Null ´íÎó¡£
find ΪÁ㳤¶È expression µÄ¸±±¾¡£
replacewith ΪÁ㳤¶È expression µÄ¸±±¾£¬ÆäÖÐɾ³ýÁËËùÓÐÓÉ find ²ÎÊýÖ¸¶¨µÄÄÚÈÝ¡£
start > Len(expression) Á㳤¶È×Ö·û´®¡£
count Ϊ 0 expression µÄ¸±±¾¡£
˵Ã÷
Replace º¯ÊýµÄ·µ»ØÖµÊǾ¹ýÌæ»»£¨´ÓÓÉ start Ö¸¶¨µÄλÖÿªÊ¼µ½ expression ×Ö·û´®µÄ½á⣩ºóµÄ×Ö·û´®£¬¶ø²»ÊÇÔʼ×Ö·û´®´Ó¿ªÊ¼ÖÁ½áβµÄ¸±±¾¡£
Ïà¹ØÎĵµ£º
Private Function Utf8ToUni(B() As Byte) As String
'²»Ê¹Óà API£¬½« Utf8 ת»»Îª Unicode
Dim BU As Long
On Error Resume Next
BU = -1: BU = UBound(B)
If BU = -1 Then Exit Function
On Error GoTo 0
&n ......
ÈÃVB²ËÄñ×î¿ìд³ö×Ô¼ºµÄÍâ¹Ò.ͨɱËùÓÐÓÎÏ·.ºÇºÇ.
ÕâÄêÍ·,ÔÚÕâ¸öÂÛ̳ÀïÃæÒѾûÓÐʲô¼¼ÊõÌùÁË...ºÇºÇ~·¢Ò»Æª¾ªÌìµØ,Æü¹íÉñµÄÌû×Ó.µ±È»Õâ¸öÖ»ÊÇÄ£Äâ¼üÅ̵ÄÖÕ¼«Ä£Äâ.ºÇºÇ~
¼üÅÌÊÇÎÒÃÇʹÓüÆËã»úµÄÒ»¸öºÜÖØÒªµÄÊäÈëÉ豸ÁË£¬¼´Ê¹ÔÚÊó±ê´óÐÐÆäµÀµÄ½ñÌ죬ºÜ¶à³ÌÐòÒÀÈ»Àë²»¿ª¼üÅÌÀ´²Ù×÷¡£µ«ÊÇ ......
Õ⼸ÌìÔÚÉè¼ÆÔĶÁÆäÖÐÓõ½Á˺ܶàºÃµÄ¼¼Êõ,,ÈÃÎÒÃÇÔÚÉè¼ÆÈí¼þµÄʱºò·½±ã,,¿ì½Ý,,ÃÀ¹Û.Ò²ÊÇÎÒÃǾ³£Óõ½µÄһЩ¿Ø¼þ.
ËùÒÔÔÚÕâÀïÎÒ»áÂ½Ðø°ÑËû·ÖÏí³öÀ´.
ÕâÀïÊÇÔÚ´°ÌåÖиı䴰ÌåµÄ´óС.´°ÌåÄÚ²¿ËùÒԿؼþµÄ´óСͬ±ÈÀýµÄ¸Ä±äµÄÒ»¸ö³ÌÐò
ÕâЩÊÇÔÚ±ê׼ģ¿éÖÐ
'¶¨Òå FormOldWidth, FormOldHeight Ϊȫ¾Ö±äÁ¿£¬ÕâÑùÆäËûÄ£¿é²ÅÄÜ ......
ÕâÀïÊÇ ÀûÓÃreplace º¯Êý ÔÚvbÖÐʵÏÖ Ïû³ý¿ÕÐеÄÒ»¸ö³ÌÐò
ÕâÀïµÄÈÝÆ÷ÊÇrichtext
¿ÉÒÔÀ©³äµ½ÆäËûÈÝÆ÷ ºÍÆäËû×Ö·û ÓÃÓÚ±àд²éÕÒÌæ»»¹¦ÄÜ
'--------------------------------------------------------------------------------------------
' Ïû³ý¿ÕÐÐ , ÀûÓÃinstrº¯Êý, ËÑË÷Îı¾ÀïµÄvbcrlf(»Ø³µ + »»ÐÐ), Á½¸ö»Ø³µÌæ»» ......
VB´´½¨ACCESSÊý¾Ý¿âÈ«½â ¶¯Ì¬´´½¨Êý¾Ý¿â¡¢´´½¨±í£¬´´½¨¼Ç¼ ADO¡¢ADOX2009Äê04ÔÂ20ÈÕ ÐÇÆÚÒ» 10:17ÕªÒª£º ±¾ÎIJûÊöÁËÔÚVB³ÌÐòÖÐÀûÓÃADO¶ÔÏó¶¯Ì¬´´½¨Êý¾Ý¿âºÍÊý¾Ý±íµÄ·½·¨£¬ÕâЩ·½·¨ÔÚ¿ª·¢VBÊý¾Ý¿âÓ¦ÓóÌÐòÖкÜÓÐʵÓüÛÖµ£¬Ëü¿ÉÒÔÌá¸ßÊý¾Ý¿â³ÌÐòÁé»îÐÔ¡£
¡¡¡¡¹Ø¼ü´Ê£ºÊý¾Ý¿â¡¢Êý¾Ý±í¡¢ADO¡¢ADOX
¡¡¡¡1: ÎÊÌâµÄÌá³ö
¡¡¡¡Ô ......