Python Regex And encode

Question

I Am trying to find and print all the Phone numbers in this file. But the file got a lot of unreadable text. The file looks like this but then really big: e

How Can I decode this and find all the numbers? I now have the following code:

import glob
import re

path = "C:\\Users\\Joey\\Downloads\\db_sdcard\\mysql\\ibdata1"
files= glob.glob(path)
for name in files:
        with open(name, 'r') as f:
            for line in f:
                print line
                match = re.search(r'(/b/d{2}-/d{8}/b)', line)
                if match:
                    found = match.group()
                    print found

When I run my script i get the following output:

ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ

Where do I have to put the .decode('utf8') And is my code for the rest good?

Zach Gates · Accepted Answer · 2015-12-01 23:08:16Z

2

Try using the following to find your numbers:

re.findall("\d{2}-\d{8}", line)

It creates a list of all of the matching substrings that fit the format xx-xxxxxxxx, where x is a digit.

When using the last line from your question as an example:

>>> line = '   P t\xe2\x82\xac         \xc5\x92  \xc3\x98p\xe2\x82\xac Q~\xc3\x80t\xc3\xb406-23423230xx06-34893646xx secure_encryptedsecure_encrypted\xe2\x82\xac  -\xe2\x82\xac  -\xe2\x82\xac  \n'
>>> re.findall("\d{2}-\d{8}", line)
['06-23423230', '06-34893646']

Here it is in the full statement:

for name in files:
    with open(name, 'r') as f:
        for line in f:
            matches = re.findall("\d{2}-\d{8}", line)
            for mt in matches:
                print mt

This will print each match on separate lines.

You could even findall the matches in the whole file at once:

for name in files:
    with open(name, 'r') as f:
        matches = re.findall("\d{2}-\d{8}", f.read())
        for mt in matches:
            print mt

edited Dec 1, 2015 at 23:08

answered Dec 1, 2015 at 22:58

Zach Gates

4,1651 gold badge29 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

10 Comments

joey Over a year ago

Hey Tnx for taking the time to help me. But when I run your script it doenst print anything

Zach Gates Over a year ago

Did you substitute it into your existing code, or run it as-is? @joey

joey Over a year ago

Yes, When I try to print matches I only get [] So I dont think he finds anything

Zach Gates Over a year ago

The matches are ['06-23423230', '06-34893646'] for the last line. I use that to say, this does work, but I'm not sure how you are testing it. @joey

joey Over a year ago

I am just running the script on the file. Where the first output is from

|

Collectives™ on Stack Overflow

Python Regex And encode

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related