- ©«¤l
- 17
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 55
- ÂI¦W
- 0
- §@·~¨t²Î
- [²¤]
- ³nÅ骩¥»
- [²¤]
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-3-22
- ³Ì«áµn¿ý
- 2022-8-17
|
¦^´_ 6# bobomi
¬Ý¨ì¬ü¤k¦Ñ®v¦^ÂСA·íµMn¦^¡A
©êºp©êºp¡A³ÌªñÂø¨Æ¤ñ¸û¦h¡A¤ñ¸ûºC¦^ >_<...
==
A = Trim(TB5 + TB6)
B = Trim(TB7 + TB8)
If A <> "" And B <> "" OR A ="" And B = "" Then
MsgBox "½Ð¾Ü¤@¿é¤J"
GoTo END1
End If
¦³ÂIÃøO_O...
¸ÕµÛ¦A¸ÑÄÀ¤@¦¸¦n¤F¡C
¦pªGTB5©ÎTB6³£¤£¬OªÅ¥Õ¦Ó¥BTB7¤ÎTB8³£¤£¬OªÅ¥Õ...
©Î¬O¡F
¦pªGTB5©ÎTB6³£¬OªÅ¥Õ¦Ó¥BTB7¤ÎTB8³£¬OªÅ¥Õ¡AµM«á... MsgBox "½Ð¾Ü¤@¿é¤J"
¤£µMTrim(TB5 + TB6)©Î¬OTrim(TB7 + TB8)¨ä¤¤¤@Ӫťէ¡¬OEnd If
³o¼Ë½Ķ·Pı¦³¶¶ò....¡]¦Û§Ú·Pı¨}¦nXD...¡^
+¦b³o¸ÌÀ³¸Ó¬O¬°¤FnÅýTB5¤ÎTB6¦¨¤@Ó¸s²Õ¡H
µM«á¦A¤À§O§PÂ_ªº·N«ä¶Ü¡H©Ò¥H¥i¥H¸ÑÄÀ¬°¡u©Î¡vªº·N«ä¶Ü¡H
==
A = Trim(TB5 + TB6)
B = Trim(TB7 + TB8)
If NOT (A = "" XOR B = "" ) Then
MsgBox "½Ð¾Ü¤@¿é¤J"
GoTo END1
End If
³oÓ¼gªk¤ñ¸ûµu¡A¤ñ¸û¦n¡C
¹ï¨âÓ Boolean ¹Bºâ¦¡°õ¦æÅ޿褬¥¸ (Logical Exclusion)¡A©Î¹ï¨âÓ¼ÆȹBºâ¦¡°õ¦æ¦ì¤¸¤¬¥¸ (Bitwise Exclusion)¡C
¦pªG expression1 ¬°¥B expression2 ¬Oresult ªºÈ¬°
True True False
True False True
False True True
False False False
·Ó¤W±ªº»¡ªk¡A¦pªG¥HA¨Ó»¡¡G
TB5="" ©MTB6="" ¬° False
TB5<>"" ©MTB6="" ¬° True
TB5="" ©MTB6<>"" ¬° True
TB5<>"" ©MTB6<>"" ¬° False
YA©MB¬Û¤ñªº¸Ü¡A
¨º»òA©MB§¡¬°ªÅ¥Õ®É¡A«h¬°False¡F
§¡¤£µ¥©óªÅ¥Õ®É¡A¤]¬OFalse¡F
©Ò¥HIf NOT TRUE THEN MsgBox "½Ð¾Ü¤@¿é¤J"
¬O³o¼Ë¸ÑÄÀ¶Ü¡H
¨º°ÝÃD¤S¨Ó¤F¡A
¤GÓ°ÝÃD¡G
¤@¡B
¬°¦ón¥ÎA = Trim(TB5 + TB6)
¦Ó¤£¥Î A= TB5+TB6 ©O¡H
¦n¹³¤@ª½³Q Trim ³oÓ¨ç¼Æ¥d¨ì...
¤G¡B
(A = "" XOR B = "" )³oÓ¦¡¤l¤¤¡A
¬O¬°¤FnÅý TB5 ©M TB6 ¤À§O¥hÀ˵ø¬O§_©MA=""¬Û¦P¬O¶Ü¡H
Á|¨Ò¨Ó»¡¡G
TB5="" A="" ³o¼Ë¨âÓ³£¬O""¡A©Ò¥H¬°False
TB5<>"" A="" ³o¼Ë¬°True
¦]¬°è¤~¤Wºô§äXORªº¤º®e¦n¹³¬On¹Bºâ¦¡¡A
©Ò¥H¤~nµ¹¥L¤@Óµ¥©ó¡]=¡^¥h°µ¹Bºâªº·Pı¡C
è¤~¸Õ¤F¤@¤U¡A¤]¥i¥H¥Î (A<>"" XOR B<>"") C...
¦n¹³¬O¨S¤°»ò·N¸qªº¸Õ¥Î¡A¥u¬O¦b´ú¸Õ XOR ªº·N«ä¦Ó¤w...
==
Trim( ) : ¦pªG§A¿é¤Jªº¬O¥þ³¡¬OªÅ¥Õ, ¤]ºâ¬Oµ¥©ó§A¨S¦³¿é¤J¥ô¦óÈ
¦pªG§A¤¹³\¿é¤J¥i¥H¬O¥þ³¡¬OªÅ¥Õ, ¨º´N§â Trim() ½ð°£±¼
½ð°£±¼ Trim À³¸Ó´N¦n²z¸Ñ¤F
©Ò¥H¦pªG¬O¥HTrim(TB5 + TB6)ªº¨ç¼Æ¨Ó»¡ªº¸Ü¡A
¦pªG¸Ì±ªºÈTB5="" TB6<>"" ³o¼Ën«ç»ò¸ÑÄÀ©O¡H
¦pªG¸Ì±ªºÈTB5="" TB6=""¤Sn«ç»ò¸ÑÄÀ©O¡H
¬ü¤k¦Ñ®v¡A¯u¬O©êºp¡A
¦]¬°ªì¾Ç¡A¤£À´ªº¹ê¦b¬O¤ñ¸û¦hXD...
¦p±z¦³ªÅ¡B¦³¶¢®É¡A¦A³Â·Ð±z¬Ý¤@¤U°ÝÃD§Y¥i¡A
ÁÂÁ±z¡I |
|