|
Hanyeguxing
银牌会员
正在学习中的菜鸟...
积分 1039
发帖 897
注册 2009-3-1
来自 在地狱中仰望天堂
状态 离线
|
『楼 主』:
[求助]如何从QQ2009的Info.db中将号码提取出来（已解决）
使用 LLM 解释/回答一下
上传的QQ2009信息info.db文件 http://upload.cn-dos.net/img/1348.rar
例如有如下的乱码：
涳艛?忌: J垟麳]CF K-婣硵艛?忌:鉁s?殸⑽矎?
NF
515187266 9TD 傢ろ
04 435853964 -TD 傘18娿
?
5? ｏ欙L( } ~搁搁块€8362-406
務蠚崄u39E拞r 515187266 >TD
ffffTA ?{- %/%//>PWf@=Ｏφ≌οη∠┫
要求：分行显示数字串。
1，由于QQ号码与乱码中的数字可能因为直接过滤其他字符而导致过滤后QQ号码与乱码中的数字连在一起而无法分辨，所以 个人认为应该使用替换。
2，因为乱码存在类似8362-406的数字串，所以在过滤时不能过滤掉-
3，由于该乱码中存在数字，所以少于5位的连续数字串要求被删除。
4，因为乱码存在类似8362-406的数字串，这些不是QQ号码，删除中间含有-的数字串。
5，删除重复的数字串
提取QQ号码后的示例效果如下：
435853964
515187266
Originally posted by HAT at 2009-3-4 05:37:
@echo off
echo 处理中，请稍等几分钟...
sed "s//\n/g" Info.db>%temp%\a.txt
findstr ^*$ %temp%\a.txt>%temp%\b.txt
sort %temp%\b.txt>%temp%\c.txt
type nul>%temp%\d.txt
for /f "delims=" %%a in (%temp%\c.txt) do (
findstr /x /c:"%%a" %temp%\d.txt>nul 2>nul||echo.%%a>>%temp%\d.txt
)
start %temp%\d.txt
Last edited by Hanyeguxing on 2009-6-6 at 01:52 ]
The uploaded QQ2009 information info.db file http://upload.cn-dos.net/img/1348.rar
For example, there are the following garbled codes:
Sky dream? Avoid: J Yang come]CF K- Yin Yan sky dream? Avoid: Zhen s? Dead ⑽ Exquisite?
NF
515187266 9TD Home and abroad
04 435853964 -TD Umbrella 18 Yan
?
5? ｏYun Lei L( } ~ Put and put blocks €8362-406
Duty scold and fear u39E Thump r 515187266 >TD
ffffTA ?{- %/%//>PWf@=Ｏφ≌οη∠┫
Requirement: Display the digital strings line by line.
1. Since the QQ number and the numbers in the garbled code may be connected together due to directly filtering other characters, making it impossible to distinguish, I personally think that replacement should be used.
2. Because there are digital strings like 8362-406 in the garbled code, the - should not be filtered out during filtering.
3. Since there are numbers in this garbled code, the continuous digital strings with less than 5 digits are required to be deleted.
4. Because there are digital strings like 8362-406 in the garbled code, which are not QQ numbers, the digital strings containing - in the middle are deleted.
5. Delete duplicate digital strings
The sample effect after extracting the QQ number is as follows:
435853964
515187266
Originally posted by HAT at 2009-3-4 05:37:
@echo off
echo Processing, please wait for a few minutes...
sed "s//\n/g" Info.db>%temp%\a.txt
findstr ^*$ %temp%\a.txt>%temp%\b.txt
sort %temp%\b.txt>%temp%\c.txt
type nul>%temp%\d.txt
for /f "delims=" %%a in (%temp%\c.txt) do (
findstr /x /c:"%%a" %temp%\d.txt>nul 2>nul||echo.%%a>>%temp%\d.txt
)
start %temp%\d.txt
Last edited by Hanyeguxing on 2009-6-6 at 01:52 ]
|
|
 2009-3-2 10:29 |
|
|
yishanju
银牌会员
[b]看你妹啊[/b]
积分 1488
发帖 1357
注册 2006-5-20
状态 离线
|
『第 2 楼』:
使用 LLM 解释/回答一下
真4想要玩死人不是
用FR 工具替换就一句命令
fr -ric:"" -t:"A" 1.txt
得到像下面的结果
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAA515187266AAA9AAAAAAAAAAAAAAA
04AAAAAAAAAAAAAAAAAAA435853964AAAAAAAAAAAAAA18AA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAA5AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAA39AAAAAAAAAAAAAAAAA515187266AAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
Last edited by yishanju on 2009-3-2 at 19:52 ]
Really 4 wants to play dead people or not
Use the FR tool to replace with just one command
fr -ric:"" -t:"A" 1.txt
Get the result like the following
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAA515187266AAA9AAAAAAAAAAAAAAA
04AAAAAAAAAAAAAAAAAAA435853964AAAAAAAAAAAAAA18AA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAA5AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAA39AAAAAAAAAAAAAAAAA515187266AAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
Last edited by yishanju on 2009-3-2 at 19:52 ]
|
有问题请发论坛或者自行搜索,再短消息问我的统统是SB |
|
|
2009-3-2 19:49 |
|
|
yishanju
银牌会员
[b]看你妹啊[/b]
积分 1488
发帖 1357
注册 2006-5-20
状态 离线
|
『第 3 楼』:
使用 LLM 解释/回答一下
改一下，空格,不替换成A
fr -ric:"" -t:"A" 1.txt
结果如下：
AAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAA
AAAAA A
A 515187266 9AAAAA AA AAAAAA
04A A 435853964 AAAAAA AAAA18AA
AAA
A A5AAA AAAAAAA A AA A AAAAAAAAAAAAAAAA
AAAAAAA39AAAAAA 515187266 AAAAAA AA
AAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
Last edited by yishanju on 2009-3-2 at 20:40 ]
Modify, do not replace spaces and with A
fr -ric:"" -t:"A" 1.txt
The result is as follows:
AAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAA
AAAAA A
A 515187266 9AAAAA AA AAAAAA
04A A 435853964 AAAAAA AAAA18AA
AAA
A A5AAA AAAAAAA A AA A AAAAAAAAAAAAAAAA
AAAAAAA39AAAAAA 515187266 AAAAAA AA
AAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
Last edited by yishanju on 2009-3-2 at 20:40 ]
|
有问题请发论坛或者自行搜索,再短消息问我的统统是SB |
|
|
2009-3-2 19:53 |
|
|
HAT
版主
积分 9023
发帖 5017
注册 2007-5-31
状态 离线
|
|
|
2009-3-2 23:10 |
|
|
yishanju
银牌会员
[b]看你妹啊[/b]
积分 1488
发帖 1357
注册 2006-5-20
状态 离线
|
『第 5 楼』:
使用 LLM 解释/回答一下
-_- 以前我也想用SED，不过后来发现处理过的文档的回车换行全变成黑方块，
恶心坏了
就没再用过SED
-_-_ I also wanted to use SED before, but later I found that the carriage returns and line feeds of the processed document all turned into black squares, which was really disgusting, so I didn't use SED anymore
|
有问题请发论坛或者自行搜索,再短消息问我的统统是SB |
|
|
2009-3-3 06:21 |
|
|
HAT
版主
积分 9023
发帖 5017
注册 2007-5-31
状态 离线
|
『第 6 楼』:
Re 5楼
使用 LLM 解释/回答一下
那是因为你没有找到合适的版本^_^
That's because you haven't found the right version ^_^
|
 |
|
|
2009-3-3 06:43 |
|
|
yishanju
银牌会员
[b]看你妹啊[/b]
积分 1488
发帖 1357
注册 2006-5-20
状态 离线
|
『第 7 楼』:
使用 LLM 解释/回答一下
给传个呗
我在GUNWIN32 上下的sed 4.15
Please clarify the specific content that needs to be translated. The current text "给传个呗 我在GUNWIN32 上下的sed 4.15" is not a complete and clear sentence with specific technical content for a straightforward translation. Please provide more context or clarify the exact text to be translated precisely.
|
有问题请发论坛或者自行搜索,再短消息问我的统统是SB |
|
|
2009-3-3 06:45 |
|
|
HAT
版主
积分 9023
发帖 5017
注册 2007-5-31
状态 离线
|
|
|
2009-3-3 08:01 |
|
|
Hanyeguxing
银牌会员
正在学习中的菜鸟...
积分 1039
发帖 897
注册 2009-3-1
来自 在地狱中仰望天堂
状态 离线
|
『第 9 楼』:
使用 LLM 解释/回答一下
谢谢各位大大高人，俺只是想用一个批处理来完成，不借助其他工具可以吗？
这是给别人弄的。俺总不能给别人发段批处理脚本，然后再传给别人个文件吧。。。
鄙视一下自己，呵呵。
操作系统：XP SP2 或 SP3
Last edited by Hanyeguxing on 2009-3-3 at 12:46 ]
Thanks to all great experts, I just want to use a batch script to complete it. Can it be done without relying on other tools?
This is for someone else. I can't just send someone a batch script and then send them a file...
Disdain myself, hehe.
Operating system: XP SP2 or SP3
Last edited by Hanyeguxing on 2009-3-3 at 12:46 ]
|
|
|
2009-3-3 12:42 |
|
|
yishanju
银牌会员
[b]看你妹啊[/b]
积分 1488
发帖 1357
注册 2006-5-20
状态 离线
|
『第 10 楼』:
使用 LLM 解释/回答一下
打个包一起传过很难么？
Is it really that difficult to pack them together and send them over?
|
有问题请发论坛或者自行搜索,再短消息问我的统统是SB |
|
|
2009-3-3 13:18 |
|
|
netbenton
银牌会员
批处理编程迷
积分 1916
发帖 752
注册 2008-12-28
来自 广西
状态 离线
|
『第 11 楼』:
使用 LLM 解释/回答一下
::处理60K以内的文件，大了搞不定,汇编语言部分由批处理com开发工具辅助写的。
::在%1指定要修改的文件
@echo off
goto :begin
a 80
push bx
push cx
mov si,100
mov di,si
lodsb
cmp al,30
jb 0090
cmp al,39
jb 0092
mov al,41
stosb
loop 0087
pop cx
pop bx
nop
t=80
g 97
w
q
q
:begin
debug %1<%~nx0
Last edited by netbenton on 2009-3-3 at 11:37 ]
::Process files within 60K, can't handle larger ones. The assembly language part is assisted by batch processing COM development tools.
::Specify the file to modify at %1
@echo off
goto :begin
a 80
push bx
push cx
mov si,100
mov di,si
lodsb
cmp al,30
jb 0090
cmp al,39
jb 0092
mov al,41
stosb
loop 0087
pop cx
pop bx
nop
t=80
g 97
w
q
q
:begin
debug %1<%~nx0
Last edited by netbenton on 2009-3-3 at 11:37 ]
|
精简
=> 个人 网志  |
|
|
2009-3-3 13:36 |
|
|
netbenton
银牌会员
批处理编程迷
积分 1916
发帖 752
注册 2008-12-28
来自 广西
状态 离线
|
『第 12 楼』:
这样也可以
使用 LLM 解释/回答一下
@echo off
goto :bengin
a 80
db, 53 51 BE 00 01 89 F7 AC 3C 30 72 04 3C 39 72 02 B0 41 AA E2
db, F2 59 5B 90
t=80
g 97
w
q
q
:bengin
debug %1<%~nx0
@echo off
goto :bengin
a 80
db, 53 51 BE 00 01 89 F7 AC 3C 30 72 04 3C 39 72 02 B0 41 AA E2
db, F2 59 5B 90
t=80
g 97
w
q
q
:bengin
debug %1<%~nx0
|
精简
=> 个人网志 |
|
|
2009-3-3 14:01 |
|
|
Hanyeguxing
银牌会员
正在学习中的菜鸟...
积分 1039
发帖 897
注册 2009-3-1
来自 在地狱中仰望天堂
状态 离线
|
『第 13 楼』:
使用 LLM 解释/回答一下
Originally posted by netbenton at 2009-3-3 13:36:
::处理60K以内的文件，大了搞不定,汇编语言部分由批处理com开发工具辅助写的。
::在%1指定要修改的文件
@echo off
goto :begin
a 80
push bx
push cx
mov si,10 ...
这个要处理的文件至少170kb，350kb都很常见。
Originally posted by yishanju at 2009-3-3 13:18:
打个包一起传过很难么？
大大，给个fr工具的下载地址哈，俺就用他了，谢谢
Originally posted by netbenton at 2009-3-3 13:36:
::Process files within 60K or less; larger ones can't be handled. The assembly language part is assisted by batch processing com development tools to write.
::Specify the file to be modified at %1
@echo off
goto :begin
a 80
push bx
push cx
mov si,10...
This file to be processed is at least 170kb, and 350kb is very common.
Originally posted by yishanju at 2009-3-3 13:18:
Is it very difficult to upload all together?
Sir, give a download address of the fr tool, I'll use it, thank you
|
|
|
2009-3-3 14:16 |
|
|
yishanju
银牌会员
[b]看你妹啊[/b]
积分 1488
发帖 1357
注册 2006-5-20
状态 离线
|
|
|
2009-3-3 14:23 |
|
|
Hanyeguxing
银牌会员
正在学习中的菜鸟...
积分 1039
发帖 897
注册 2009-3-1
来自 在地狱中仰望天堂
状态 离线
|
『第 15 楼』:
使用 LLM 解释/回答一下
Originally posted by yishanju at 2009-3-3 14:23:
fr下载地址：
http://baiy.cn/utils/fr/index.htm
现在开始学习fr和sed，呵呵
使用fr，依然残留少量的小黑块5555555555555555
楼上的大大，用QQ2009版里的info.db测试就知道了
Last edited by Hanyeguxing on 2009-3-3 at 14:59 ]
Originally posted by yishanju at 2009-3-3 14:23:
fr download address:
http://baiy.cn/utils/fr/index.htm
Now start learning fr and sed, hehe
Using fr, there are still a small number of black blocks left 5555555555555555
Dear upstairs, test with info.db in QQ2009 version to know
Last edited by Hanyeguxing on 2009-3-3 at 14:59 ]
|
|
|
2009-3-3 14:41 |
|
