[閒聊] 各位主購有遇過團員id後面多填空格嗎
如題
最近幾團都有這樣的狀況
整單第一步核對推文id & 填單id
http://web.archive.org/web/20090221170100/http://wish.kuso.cc/ptt.html
(使用vlook函數 如果像是填錯id和推文不同就會顯示N/A)
發現一些帳號沒推文就刪單
結果我整單完才發現那些顯示N/A的團員
很多是在填G單時在自己的ID後面多打按了空白鍵
(我是人工核對才發現的)
覺得好像也不是真的ID填錯 刪單有點可憐
但因為我發現時已經整好單了 所以還是刪了
我只是想問一下版上的主購
這種多打空格的你們會刪單嗎QQ
因為 =vlookup(搜尋目標, 搜尋範圍,2,false)需要完全相同才會回傳
但打true的話要是剛好兩個團員id很像不知道會不會有問題
想問問看大家有遇過這樣多打空格的團員嗎 是怎麼處理的呀~
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 140.112.218.107
※ 文章網址: https://www.ptt.cc/bbs/Chat82gether/M.1466344454.A.083.html
推
06/19 22:04, , 1F
06/19 22:04, 1F
→
06/19 22:06, , 2F
06/19 22:06, 2F
→
06/19 22:07, , 3F
06/19 22:07, 3F
→
06/19 22:07, , 4F
06/19 22:07, 4F
推
06/19 22:10, , 5F
06/19 22:10, 5F
好~下次用用看這個移除空白字元的函數
感謝提供~
推
06/19 22:11, , 6F
06/19 22:11, 6F
但是我就是核對推文時誤以為他沒有推
還是大家發現N/A的都還會手動一個個查?!(跪)
※ 編輯: ruby40861 (140.112.218.107), 06/19/2016 22:16:21
推
06/19 22:14, , 7F
06/19 22:14, 7F
→
06/19 22:15, , 8F
06/19 22:15, 8F
→
06/19 22:15, , 9F
06/19 22:15, 9F
→
06/19 22:27, , 10F
06/19 22:27, 10F
→
06/19 22:27, , 11F
06/19 22:27, 11F
推
06/19 22:30, , 12F
06/19 22:30, 12F
→
06/19 22:30, , 13F
06/19 22:30, 13F
→
06/19 22:31, , 14F
06/19 22:31, 14F
→
06/19 22:32, , 15F
06/19 22:32, 15F
推
06/19 22:34, , 16F
06/19 22:34, 16F
→
06/19 22:34, , 17F
06/19 22:34, 17F
推
06/19 22:37, , 18F
06/19 22:37, 18F
推
06/19 22:41, , 19F
06/19 22:41, 19F
→
06/19 22:41, , 20F
06/19 22:41, 20F
推
06/19 22:46, , 21F
06/19 22:46, 21F
→
06/19 22:46, , 22F
06/19 22:46, 22F
→
06/19 22:46, , 23F
06/19 22:46, 23F
今日最佳解給你!!!!!!
同理應該也可以讓團員手機、退款帳號一定要打"-"
感謝你讓我發現新的小天地ˊˇˋ
※ 編輯: ruby40861 (140.112.218.107), 06/19/2016 22:51:10
推
06/19 22:52, , 24F
06/19 22:52, 24F
※ 編輯: ruby40861 (140.112.218.107), 06/19/2016 22:52:50
→
06/19 22:52, , 25F
06/19 22:52, 25F
→
06/19 22:52, , 26F
06/19 22:52, 26F
推
06/20 00:08, , 27F
06/20 00:08, 27F
→
06/20 00:09, , 28F
06/20 00:09, 28F
→
06/20 00:10, , 29F
06/20 00:10, 29F
→
06/20 00:11, , 30F
06/20 00:11, 30F
→
06/20 00:12, , 31F
06/20 00:12, 31F
→
06/20 00:12, , 32F
06/20 00:12, 32F
推
06/20 21:30, , 33F
06/20 21:30, 33F
→
06/20 21:30, , 34F
06/20 21:30, 34F
→
06/20 21:31, , 35F
06/20 21:31, 35F
推
06/20 23:06, , 36F
06/20 23:06, 36F
→
06/20 23:07, , 37F
06/20 23:07, 37F
→
06/20 23:07, , 38F
06/20 23:07, 38F
→
06/20 23:07, , 39F
06/20 23:07, 39F
推
06/21 11:57, , 40F
06/21 11:57, 40F
→
06/21 11:58, , 41F
06/21 11:58, 41F
→
06/21 11:58, , 42F
06/21 11:58, 42F
→
06/21 11:58, , 43F
06/21 11:58, 43F
→
06/21 11:58, , 44F
06/21 11:58, 44F