How to extract QQ numbers from Info.db of QQ2009 (Solved) - China DOS Union Forum

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 ]

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 ]

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 ]

sed -i "s//A/g" a.txt

-_-_ 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

That's because you haven't found the right version ^_^

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.

Batch processing room attachment collection special post http://www.cn-dos.net/forum/viewthread.php?tid=25914

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 ]

Is it really that difficult to pack them together and send them over?

::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 ]

@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

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

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 ]

Floor1　Hanyeguxing	Posted 2009-03-02 10:29
银牌会员　Posts 897　Credits 1,039　From 在地狱中仰望天堂
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 ]

Floor2　yishanju	Posted 2009-03-02 19:49
银牌会员　Posts 1,357　Credits 1,488
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 ]

Floor3　yishanju	Posted 2009-03-02 19:53
银牌会员　Posts 1,357　Credits 1,488
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 ]

Floor4　HAT	Posted 2009-03-02 23:10
版主　Posts 5,017　Credits 9,023
sed -i "s//A/g" a.txt

Floor5　yishanju	Posted 2009-03-03 06:21
银牌会员　Posts 1,357　Credits 1,488
-_-_ 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

Floor6　HAT	Posted 2009-03-03 06:43
版主　Posts 5,017　Credits 9,023
That's because you haven't found the right version ^_^

Floor7　yishanju	Posted 2009-03-03 06:45
银牌会员　Posts 1,357　Credits 1,488
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.

Floor8　HAT	Posted 2009-03-03 08:01
版主　Posts 5,017　Credits 9,023
Batch processing room attachment collection special post http://www.cn-dos.net/forum/viewthread.php?tid=25914

Floor9　Hanyeguxing	Posted 2009-03-03 12:42
银牌会员　Posts 897　Credits 1,039　From 在地狱中仰望天堂
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 ]

Floor10　yishanju	Posted 2009-03-03 13:18
银牌会员　Posts 1,357　Credits 1,488
Is it really that difficult to pack them together and send them over?

Floor11　netbenton	Posted 2009-03-03 13:36
银牌会员　Posts 752　Credits 1,916　From 广西
::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 ]

Floor12　netbenton	Posted 2009-03-03 14:01
银牌会员　Posts 752　Credits 1,916　From 广西
@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

Floor13　Hanyeguxing	Posted 2009-03-03 14:16
银牌会员　Posts 897　Credits 1,039　From 在地狱中仰望天堂
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

Floor14　yishanju	Posted 2009-03-03 14:23
银牌会员　Posts 1,357　Credits 1,488
FR download link: http://baiy.cn/utils/fr/index.htm

Floor15　Hanyeguxing	Posted 2009-03-03 14:41
银牌会员　Posts 897　Credits 1,039　From 在地狱中仰望天堂
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 ]