ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ½Ð°ÝMID¨ç¼Æ­n¥[¦b­þ?

¥»©«³Ì«á¥Ñ luhpro ©ó 2024-10-25 00:25 ½s¿è

¦^´_ 1# lky12345
¦]¬°§A¨S¦³µ¹½d¨Òµ{¦¡, ¨ü­­©ó®É¶¡¤£¤Ó°÷, ©Ò¥H§Ú¥u¯àÁ|¨Òµ¹§A°Ñ¦Ò¬Ý¬Ý:

MID¨ç¼Æ ªº¥Îªk¦p¤U :

MID(¤å¦r¦ê¦WºÙ, °_©l¦ì¸m, §ì¨úªº¤å¦r­Ó¼Æ)

°²³]¤@­Ó¤å¦r¦ê : sStr = "w30amkra-03rtkq-"
­Y·Q§ì¨ú²Ä1­Ó¦r¤¸°_ºâ6­Ó¤å¦r,
¥i¨Ï¥Î : sTar = MID(sStr, 1, 6) (¨ä¹ê­Y¬O±q¶}ÀY°_ºâ®É, ¥i¥H¥Î LEFT(sStr, 6) §Y¥i)
«h sTar = "w30amk"
ÃöÁä¬O§Aªº¨º¦ê«ü¥O¬O­n©ñ¦b¤W¦¡¤¤ªº sStr  ªº¦ì¸m.

TOP

        ÀR«ä¦Û¦b : ¬Ý§O¤H¤£¶¶²´¡A¬O¦Û¤v­×¾i¤£°÷¡C
ªð¦^¦Cªí ¤W¤@¥DÃD