數據如何提取多個數據

❶ 濡備綍浠嶦xcel琛ㄦ牸涓鎻愬彇鎸囧畾鐨勪笁涓鏁版嵁錛

闂棰樻潵鑷涓浣嶇兢鍙嬬殑奼傚姪銆

鍏寮忚В鏋愶細

榪欎釜鍏寮忛噷鐢ㄥ埌浜嗕簲涓鍑芥暟錛屽叾涓鏈夋垜浠姣旇緝鐔熸倝鐨凪ID鍜孋OLUMN錛屼篃鏈夋垜浠涓嶅お甯哥敤鐨凾RIM銆丼UBSTITUTE鍜孯EPT鍑芥暟銆備笅闈㈢畝鍗曟潵瑙ｉ噴涓涓嬭繖涓鍏寮忕殑鎬濊礬銆

鍏寮忕殑鏍稿績閮ㄥ垎鏄瘲UBSTITUTE錛$A2,",",REPT錛"",99錛夛級錛岃繖閮ㄥ垎鐨勪綔鐢ㄦ槸榪涜屾浛鎹銆

SUBSTITUTE鍑芥暟鏍煎紡涓猴細

SUBSTITUTE錛堝湪鍝閲屾浛鎹錛屾浛鎹浠涔堬紝鎹㈡垚浠涔堬紝鎹㈢鍑犱釜錛夈

渚嬪傦細

鍏寮=SUBSTITUTE錛$A2,",","鈥",3錛夌殑鏁堟灉灝辨槸鎶夾2鍗曞厓鏍肩殑絎3涓閫楀彿鎹㈡垚鈥斿彿銆

褰撶渷鐣ョ鍥涘弬鏁扮殑鏃跺欙紝浠ｈ〃閫楀彿鍏ㄩ儴鏇挎崲銆

鏈渚嬩腑鏄鎶夾2涓鐨勯楀彿鎹㈡垚浜哛EPT錛"",99錛夛紝涔熷氨鏄99涓絀烘牸銆

REPT鍑芥暟鐨勬牸寮忎負錛

REPT錛堣侀噸澶嶇殑瀛楃︼紝閲嶅嶆℃暟錛夈

渚嬪傦細

REPT錛堚溾槄鈥濓紝5錛夛紝灝辨槸灝嗏槄閲嶅嶄簲嬈°

鑷充簬鍏寮忎腑涓轟粈涔堣佺敤99涓絀烘牸錛屽畬鍏ㄦ槸涓縐嶅楄礬錛岀戶緇鐪嬪畬鍏寮忕殑鍏朵粬閮ㄥ垎鎴栬稿氨鐞嗚В浜嗐

浣跨敤SUBSTITUTE寰楀埌鐨勬暟鎹榪橀渶瑕佺敤MID鍑芥暟鏉ヨ繘琛屾彁鍙栥侻ID鍑芥暟澶у跺簲璇ユ瘮杈冪啛鎮変簡錛屽熀鏈鏍煎紡涓猴細MID錛堣佹彁鍙栫殑鏁版嵁錛屼粠浠涔堜綅緗寮濮嬪彇錛屽彇鍑犱釜瀛楋級銆

鍦ㄦ湰渚嬩腑瑕佹彁鍙栫殑鏁版嵁灝辨槸SUBSTITUTE錛堬級錛岃岃佹彁鍙栫殑瀹瑰肩殑浣嶇疆鍘熸湰鏄鍦ㄧ2涓閫楀彿涔嬪悗錛岀敱浜庢垜浠鎶婇楀彿鎹㈡垚浜99涓絀烘牸錛岃佹彁鍙栫殑浣嶇疆鍓嶉潰鑷沖皯鏈変袱緇勭┖鏍間篃灝辨槸2*99涓瀛楃︼紱鐩稿簲灝佽呯殑鎻愬彇鐨勪綅緗鏄3*99錛岃愬帇鐨勬槸4*99銆傞噰鐢ㄥ叕寮忓彸鎷夛紝鎵浠ヨ繖閲岀敤COLUMN錛圔1錛*99浣滀負鎻愬彇浣嶇疆銆侻ID鐨勬渶鍚庝竴涓鍙傛暟鏄瑕佸彇鍑犱釜瀛楃︼紝涓轟簡淇濋櫓璧瘋侊紝緇熶竴鎻愬彇99涓瀛椼

涔熷氨鏄璇達紝緇忚繃MID錛圫UBSTITUTE錛堬級錛孋OLUMN錛圔1錛*99錛99錛夎繖閮ㄥ垎鍏寮忚繍綆楀悗錛屽緱鍒扮殑緇撴灉鏄鎴戜滑瀹為檯闇瑕佺殑瀹瑰兼暟鎹鍖呭惈鍦ㄥ墠鍚庣┖鏍間腑銆備負浜嗕究浜庡ぇ瀹剁悊瑙ｏ紝涓存椂灝嗙┖鏍兼崲鎴愨旓紝鍙浠ョ洿瑙傚湴鐪嬪嚭鏁堟灉銆

鎴戜滑鑲瀹氫笉甯屾湜寰楀埌鐨勭粨鏋滀腑鍖呭惈鏈夊ぇ閲忔棤鐢ㄧ殑絀烘牸錛屽洜姝ゅ湪鏈澶栧眰濂椾竴涓猅RIM灝卞彲浠ュ幓鎺夎繖浜涚┖鏍箋俆RIM鍑芥暟鍙鏈変竴涓鍙傛暟錛屽姛鑳藉氨鏄鍘繪帀瀛楃︿覆涓澶氫綑鐨勭┖鏍箋

鏈渚嬩嬌鐢ㄧ殑瀹為檯涓婁篃鏄闈炲父緇忓吀鐨勪竴涓鍏寮忕粍鍚堬細TRIM鈥擬ID鈥擲UBSTITUTE鈥擱EPT緇勫悎銆傚叕寮忕悊瑙ｈ搗鏉ラ渶瑕佷竴瀹氱殑鍩虹錛屾柊鎵嬫殏鏃舵棤娉曠悊瑙ｇ殑鏃跺欙紝鍙浠ュ厛鎺屾彙鍏寮忕殑濂楄礬錛屾牴鎹鑷宸辯殑闇瑕佷慨鏀瑰弬鏁般

闂茶█濡勮錛

涓鍫嗘婚奔錛屽瘑瀵嗛夯楹伙紝涓涓闈犱竴涓銆傜幇鍦ㄧ粰浣犱竴涓綃撳瓙錛圡ID鍑芥暟錛夎佷綘浠庢婚奔涓鎶婂叾涓鐨勭孩楸兼崬鍑烘潵銆傝佹眰鏄涓嶈佺板埌鍏朵粬楸箋傚暦涓鍔烇紵鎶婇奔鍒嗗紑錛圫UBSTITUTE鍑芥暟鏇挎崲閫楀彿澧炲ぇ闂磋窛錛夊憖錛佸拫涓鍒嗗紑錛熷啿姘達紙鍔犵┖鏍礆級鍛錛屼嬌鍔插啿姘達紙鐢99涓絀烘牸錛屽姴澶熷ぇ浜嗭級錛岄奔鍒嗗紑浜嗭紝鐒跺悗涓綃撳瓙灝辨妸綰㈣壊姝婚奔鎹炶搗鏉ヤ簡錛岃櫧鐒舵崬楸肩殑鏃跺欐按錛堢┖鏍礆級鑲瀹氫篃浼氬甫涓婏紝浣嗘按椹涓婂氨浠庣綉瀛旓紙TRIM鍑芥暟錛変腑婕忔帀錛堣鎺掗櫎浜嗭級浜嗭紝鍙鍓╅渶瑕佺殑綰㈤奔銆

涓哄暐鐢ㄦ按錛堢┖鏍礆級鑰屼笉鏄鍏朵粬涓滆タ錛堣濡傞楀彿錛夋潵澧炲姞闂磋窛鍛錛熺綉瀛旓紙TRIM鍑芥暟錛夊彧閫傚悎婊ゆ按錛堥楀彿灝辨護涓嶈蛋錛夊憖銆備負鍟ヨ佸啿閭ｄ箞澶氭按錛99涓絀烘牸錛夛紵鍥犱負鍒嗗緱瓚婂紑錛岃秺鍙浠ュ拷鐣ュ叾浠栭奔鐨勫獎鍝嶏紙瀛楃︽暟涓嶇瓑鐨勫獎鍝嶏級錛岀瘬瀛愶紙MID鍑芥暟錛夌殑鍙ｅ緞錛堝彇瀛楃︾殑瀛楃︽暟錛夊氨鍙浠ヨ秺澶э紙99錛夛紝鍙闇瑕佺粰涓涓涓嬬瘬瀛愮殑澶ф備綅緗錛堝苟闈炵孩楸肩殑鍑嗙『浣嶇疆錛岀敱COLUMN錛圔1錛*99瀹炵幇錛夛紝灝辮偗瀹氬彧鎹炲埌姘村拰綰㈤奔銆