好友
阅读权限30
听众
最后登录1970-1-1
|
25吾爱币
本帖最后由 pxhzai 于 2020-4-3 21:13 编辑
Key: 8CCNW-FC9RV-GMKTW-CWDXD-T6Q2Y Description: Office19_RTM19_ProPlus2019R_Retail Sub type: X21-74620 Error code: 0xC004C008 Time: 4/3/2020 1:31:33 PM (GMT+7)
这样是一条 提取8CCNW-FC9RV-GMKTW-CWDXD-T6Q2Y
下面文本连一块了 要处理方法 不是结果
Key: 8CCNW-FC9RV-GMKTW-CWDXD-T6Q2Y Description: Office19_RTM19_ProPlus2019R_Retail Sub type: X21-74620 Error code: 0xC004C008 Time: 4/3/2020 1:31:33 PM (GMT+7) Key: 8VC7N-VVXB3-273PT-2YBPW-CPRW6 Description: Office19_RTM19_ProPlus2019MSDNR_Retail Sub type: X21-74618 Error code: 0xC004C008 Time: 4/3/2020 1:31:45 PM (GMT+7) Key: CMQND-GVJGW-P7VDP-GM2HT-RRJJ6 Description: Office19_RTM19_ProPlus2019MSDNR_Retail Sub type: X21-74618 Error code: 0xC004C008 Time: 4/3/2020 1:31:58 PM (GMT+7) Key: FNH9B-MMR9G-YP7JV-BWRJ7-FJTTG Description: Office19_RTM19_ProPlus2019MSDNR_Retail Sub type: X21-74618 Error code: 0xC004C008 Time: 4/3/2020 1:32:10 PM (GMT+7) Key: FPJJV-KN6T3-DJ482-H6PJR-JHXGG Description: Office19_RTM19_ProPlus2019MSDNR_Retail Sub type: X21-74618 Error code: 0xC004C008 Time: 4/3/2020 1:32:19 PM (GMT+7) Key: FTNV6-6QXKD-QCJ82-6T87D-63C6G Description: Office19_RTM19_ProPlus2019MSDNR_Retail Sub type: X21-74618 Error code: 0xC004C008 Time: 4/3/2020 1:32:29 PM (GMT+7) Key: FXWNC-4H2PP-J3R73-K6QWR-X2GTG Description: Office19_RTM19_ProPlus2019MSDNR_Retail Sub type: X21-74618 Error code: 0xC004C008 Time: 4/3/2020 1:32:44 PM (GMT+7) Key: G3XNB-CCPDX-JW24T-Y4QCC-J46TG Description: Office19_RTM19_ProPlus2019MSDNR_Retail Sub type: X21-74618 Error code: 0xC004C008 Time: 4/3/2020 1:32:53 PM (GMT+7) Key: J3CMN-838DX-4BFW6-D4HWJ-JFJJ6 Description: Office19_RTM19_ProPlus2019MSDNR_Retail Sub type: X21-74618 Error code: 0xC004C008 Time: 4/3/2020 1:33:29 PM (GMT+7) Key: J8JNT-QJ3VV-RCRK9-43H83-3PGTG Description: Office19_RTM19_ProPlus2019MSDNR_Retail Sub type: X21-74618 Error code: 0xC004C008 Time: 4/3/2020 1:33:39 PM (GMT+7) Key: JCNVT-X4GYW-T87GK-VJVQ3-3PGTG Description: Office19_RTM19_ProPlus2019MSDNR_Retail Sub type: X21-74618 Error code: 0xC004C008 Time: 4/3/2020 1:33:49 PM (GMT+7) Key: JCX3X-FVNGV-XV7BC-CC376-H8TTM Description: Office19_RTM19_ProPlus2019R_Retail Sub type: X21-74620 Error code: 0xC004C060 Time: 4/28/2019 2:20:01 AM (GMT+7) Key: JGDVQ-NDY6C-GGKCK-8KV82-2DM86 Description: Office19_RTM19_ProPlus2019MSDNR_Retail Sub type: X21-74618 Error code: 0xC004C008 Time: 4/3/2020 1:33:58 PM (GMT+7) Key: JGTXJ-VQNTD-P96WK-KQDMH-JQM86 Description: Office19_RTM19_ProPlus2019MSDNR_Retail Sub type: X21-74618 Error code: 0xC004C008 Time: 4/3/2020 1:34:07 PM (GMT+7) Key: JHNFP-6244D-6JTM7-FQWK2-J46TG Description: Office19_RTM19_ProPlus2019MSDNR_Retail Sub type: X21-74618 Error code: 0xC004C008 Time: 4/3/2020 1:34:16 PM (GMT+7) Key: JN63D-KR23R-DTJ9H-8BDW7-FJTTG Description: Office19_RTM19_ProPlus2019MSDNR_Retail Sub type: X21-74618 Error code: 0xC004C008 Time: 4/3/2020 1:34:26 PM (GMT+7) Key: GFNYQ-9RVMB-49GDQ-HJ7FK-T84XB Description: Office19_RTM19_ProPlus2019R_Retail Sub type: X21-74620 Error code: 0xC004C008 Time: 4/3/2020 1:33:19 PM (GMT+7) Key: JNG2J-7XHB2-V8HFG-WC8Y6-8T26G Description: Office19_RTM19_ProPlus2019MSDNR_Retail Sub type: X21-74618 Error code: 0xC004C008 Time: 4/3/2020 1:35:33 PM (GMT+7) Key: JQJ3N-8T8PT-XJFMP-YVYC6-D3YCT Description: Office19_RTM19_ProPlus2019MSDNR_Retail Sub type: X21-74618 Error code: 0xC004C008 Time: 4/3/2020 1:35:42 PM (GMT+7) Key: K4N8D-FP4VD-FTJJ6-896J3-7VB86 Description: Office19_RTM19_ProPlus2019MSDNR_Retail Sub type: X21-74618 Error code: 0xC004C008 Time: 4/3/2020 1:35:51 PM (GMT+7) Key: KBJNK-JJ8GV-CTMJT-4K2YH-8HXGG Description: Office19_RTM19_ProPlus2019MSDNR_Retail Sub type: X21-74618 Error code: 0xC004C008 Time: 4/3/2020 1:36:01 PM (GMT+7) Key: KHF8N-8YKC4-FR2WF-VGP4V-6XY86 Description: Office19_RTM19_ProPlus2019MSDNR_Retail Sub type: X21-74618 Error code: 0xC004C008 Time: 4/3/2020 1:36:10 PM (GMT+7) Key: KVVJ3-WXNRT-XJ2DB-3GVDJ-D9P6G Description: Office19_RTM19_ProPlus2019MSDNR_Retail Sub type: X21-74618 Error code: 0xC004C008 Time: 4/3/2020 1:36:20 PM (GMT+7) Key: QCNM6-YCY7H-CMVQP-XYGMP-HH8KB Description: Office19_RTM19_ProPlus2019R_Retail Sub type: X21-74620 Error code: 0xC004C008 Time: 4/3/2020 1:37:55 PM (GMT+7) Key: QTDPN-J9W32-MXGHF-VTX3K-6CRXB Description: Office19_RTM19_ProPlus2019R_Retail Sub type: X21-74620 Error code: 0xC004C008 Time: 4/3/2020 1:38:54 PM (GMT+7) Key: RWW6Q-29N43-YFB63-PVVXV-MBKGG Description: Office19_RTM19_ProPlus2019MSDNR_Retail Sub type: X21-74618 Error code: 0xC004C008 Time: 4/3/2020 1:45:48 PM (GMT+7) Key: T7MRN-99CWB-RH7K8-3JMVX-3RVPY Description: Office19_RTM19_ProPlus2019R_Retail Sub type: X21-74620 Error code: 0xC004C008 Time: 4/3/2020 1:45:58 PM (GMT+7) Key: TN399-4Y32M-386MK-YJMR9-2YWJ6 Description: Office19_RTM19_ProPlus2019MSDNR_Retail Sub type: X21-74618 Error code: 0xC004C008 Time: 4/3/2020 1:46:09 PM (GMT+7) Key: WRGW8-N4X8Q-66T84-D9T77-4626G Description: Office19_RTM19_ProPlus2019MSDNR_Retail Sub type: X21-74618 Error code: 0xC004C008 Time: 4/3/2020 1:46:30 PM (GMT+7) |
最佳答案
查看完整内容
1、先把上述文字复制到word中，按ctrl+H开始替换，查找内容（Key:），替换为（^pKey:），注：查找和替换内容不包含括号
此时或得了以Key:开头分行的文本内容
2、将上述内容复制到Excel中粘贴至A列，对A列进行分列，①选分割符号，下一步；②勾选空格选项，下一步；③得到的B列即符合要求
以上是用office解决的方式，不知我说明白了吗，如不明白的话我给你截图，也可以有其它很多软件解决
|
发帖前要善用【论坛搜索】功能，那里可能会有你要找的答案或者已经有人发布过相同内容了，请勿重复发帖。 |
|
|
|
|
发表于 2020-4-3 21:12
|
发表于 2020-4-3 21:28
