vb ÖÐ - VB / »ù´¡Àà
dim a as string,b as string£¬c as string
a="¹¤³Ì±àºÅ,µ¥Î»¹¤³ÌÃû³Æ,·Ö²¿¹¤³Ì±àºÅ"
b="µ¥Î»¹¤³ÌÃû³Æ"
c="µ¥Î»"
Ôõô²ÅÄÜÅжϳöa×Ö·û´®ÖдæÔÚb×Ö·û´®£¬¶ø²»´æÔÚc×Ö·û´®
¿´¿´instr
»Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡»Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡»Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡»Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡
Ï£Íû×îºÃÓоßÌå´úÂë £¬±¾ÈËÊÇÐÂÊÖ£¬Ð»Ð»
Äã˵µÄ¡®´æÔÚb×Ö·û´®£¬¶ø²»´æÔÚc×Ö·û´®¡¯
ÊÇÈ«²¿»¹ÊDz¿·Ö£¿
if instr(a,b)<>0 and instr(a,c)=0 then
'aÖаüÀ¨bµ«²»°üÀ¨c
end if
if instr(a,b) and instr(a,c)=0 then
'....
end if
ÎÒµÄa¡¢bºÍc¶¼ÊDz»¹Ì¶¨µÄ£¬ÎÒÉÏÃæ¸ø³öµÄÖ»ÊÇÁгöµÄÒ»¸öÀý×Ó
instrº¯Êý
»òÕßÓÃsplitº¯Êý½«a×Ö·û´®°´ÕÕ¡°£¬¡±·ÖÀ뿪À´£¬È»ºóÅжÏ×Ö·û´®ÊÇ·ñÏàµÈ
×îºÃÊÇinstrº¯ÊýÁË
VB code:
Option Explicit
Function StringComp(ByVal s As String, sFind1 As String, sFind2 As String) As Long
'µÚÒ»¸ö´æÔÚ·µ»Ø1,µÚ¶þ¸ö´æÔÚ·µ»Ø2,¶þ¸ö¶¼´æÔÚ·µ»Ø3,¶þ¸ö¶¼²»´æÔÚ,·µ»Ø0
Const SEPARATOR = ","
s = SEPARATOR & s & SEPARATOR
sFind1 = SEPARATOR & sFind1 & SEPARATOR
sFind2 = SEPARATOR & sFind2 & SEPARATOR
StringComp = -(InStr(s, sFind1) > 0) + -2 * (InStr(s, sFind2) > 0)
End Function
Private Sub Command1_Click()
Dim a As String, b As String, c As String
a = "¹¤³Ì±àºÅ,µ
Ïà¹ØÎÊ´ð£º
ÎÒÔÚÀàÖÐÓÐÒ»¸öº¯Êý
Public Function DownloadAdditionalSite(SiteName As siteconfig, Directory As String, ymd As String) As Boolean
siteconfigÊÇÎÒ×Ô¶¨ÒåÀàÐ͵ÄÊý¾Ý£¬ÎªÊ²Ã´»áÌáʾ¡°Ö»ÓÐÔÚ¹«¹²¶ÔÏóÄ£¿éÖж ......
DIM ds as new DataSet
ÎÒÕâÑùÉùÃ÷ ÔõÀÏÊDZ¨ Óû§¶¨ÒåÀàÐÍ䶨Ò壿 Õâ¸öÐèÒªÒýÓÃʲôÂ𣿣¿
ǰÌáÊÇDataSet¶ÔÏóÒª´æÔÚ,¾ÍÊǶÔÏóä¯ÀÀÆ÷ÖÐÓÐËü.ûÓоÍÒªÒýÓÃ.
datasetÊÇADO.NET¶ÔÏó
Èç¹ûÄãÓõÄÊÇvb.net£¬ÄÇôÔÚ´ ......
Private Sub Command1_Click()
Dim MyString() As String
Open "a.xml" For Binary As #1 ' ´ò¿ª¸Õ´´½¨µÄÎļþ¡£
ReDim MyString(LOF(1) - 1)
Put #1, , MyRecord ' ¶ÁÈëËùÓÐ×Ö·ûµ½±äÁ¿ÖÐ ......
ÏÖÔÚÓиöxmlÎļþÊÇ<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xm ......