We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
6 days, 14 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Contact Extraction from defunct Exchange priv1.edb database
Posted on 2004-10-13
Hello,
I have a 700 MB priv1.edb exchange database which is corrupt, however I have used various tools such as bintext, and hex editors and such and I CAN see the pieces of exchange information plain as day. The info is even in order memory wise!
I notice a unique 7 digit number prior to the individual sections that I would like to extract.
My need is to have a perl, or some other method, script to find that 7 digit number and then extract certain fields after that. I would like to send these extractions to a separate file. Delimited text file would be fine, and then I will import them into excel or whatever.
Can be done???
JM
tia
I have a 700 MB priv1.edb exchange database which is corrupt, however I have used various tools such as bintext, and hex editors and such and I CAN see the pieces of exchange information plain as day. The info is even in order memory wise!
I notice a unique 7 digit number prior to the individual sections that I would like to extract.
My need is to have a perl, or some other method, script to find that 7 digit number and then extract certain fields after that. I would like to send these extractions to a separate file. Delimited text file would be fine, and then I will import them into excel or whatever.
Can be done???
JM
tia
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
3
7 Comments
So the beginning the fields are identified by a 7 digit number, how are the ends of the field identified?
3124745 (binary crap) John Q. Public 123 Main Street Acity Astate (binary crap) 3124745 (binary crap) Person 2 info ............. (binary crap) 3124745 (binary crap) person 3 .......... (bc) .....etc...
I would like to find the number 3124745, then skip over the binary crap, extract info, and then find next number and repeat.
If I have to live with the bc that comes between the user info and the following #, that's fine, but I would like to be able to skip the bc that comes between the # and the user info.
jm
I would like to find the number 3124745, then skip over the binary crap, extract info, and then find next number and repeat.
If I have to live with the bc that comes between the user info and the following #, that's fine, but I would like to be able to skip the bc that comes between the # and the user info.
jm
ozo,
I would settle for something like (x non binary crap bytes in a row)
where x= maybe 10 or so, or 5, or whatever. (Basically to indicate that I am within usable ascii information. I dont expect this to be totally precise science. I will modify code accordingly to see what fits. My initial goal is to extract "most" (as much as possible) of the human readable text from this 700MB file, and save it into a separate much smaller file. I am sure I will then run extractions against that file to fine tune, etc...
So, I suppose something like /a-bA-B0-9/ and 'space'/'tab' for x sequential bytes would be a starting place for the regex to isolate the readable text?
This initial code can be dirty(filthy even :) ), just to get a smaller working set which contains all my ascii that I want to extract. I will then look at that file's structure and see what I should do from there.
Thanx
JM
I would settle for something like (x non binary crap bytes in a row)
where x= maybe 10 or so, or 5, or whatever. (Basically to indicate that I am within usable ascii information. I dont expect this to be totally precise science. I will modify code accordingly to see what fits. My initial goal is to extract "most" (as much as possible) of the human readable text from this 700MB file, and save it into a separate much smaller file. I am sure I will then run extractions against that file to fine tune, etc...
So, I suppose something like /a-bA-B0-9/ and 'space'/'tab' for x sequential bytes would be a starting place for the regex to isolate the readable text?
This initial code can be dirty(filthy even :) ), just to get a smaller working set which contains all my ascii that I want to extract. I will then look at that file's structure and see what I should do from there.
Thanx
JM
Featured Post
![[Webinar] Learn How Hackers Steal Your Credentials](https://filedb.experts-exchange.com/files/public/2017/5/21/e0b7778f-e79e-4b5d-9ec6-5496e40be42e.png)
Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
On Microsoft Windows, if  when you click or type the name of a .pl file, you get an error "is not recognized as an internal or external command, operable program or batch file", then this means you do not have the .pl file extension associated with …
There are many situations when we need to display the data in sorted order. For example: Student details by name or by rank or by total marks etc. If you are working on data driven based projects then you will use sorting techniques very frequently.…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions.
Consider email address RFCs:
Look at HTML5 form input element (with type=email) regex pattern:
T…
Suggested Courses
Course of the Month6 days, 14 hours left to enroll
726 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.