Отпарсить *.sql файл и сохранить результат >result.txt

#!/usr/bin/python
# -*- coding: utf8 -*-

import sys, os, os.path, random, re
from optparse import OptionParser
from lib.lib_emails_extract import *




def run_using_args():
    parser = OptionParser()
    parser.add_option("--in", dest="in_file", help="Input file", metavar="FILE")
    parser.add_option("--out", dest="out_file", help="Output file", metavar="FILE")
    (options, args) = parser.parse_args()
    if options.in_file is None or options.out_file is None:
        parser.error('options --in and --out is required')
    if options.in_file == options.out_file:
        parser.error('options --in and --out must be different!')

    op = ExtractEmailsOperation(
        in_filename = options.in_file,
        out_filename = options.out_file)
    op.do()

def run_in_folder_mode():
    files_found = 0
    files_processed = 0
    suffix = '.emails'
    if not os.path.isdir('./workdir'):
        os.mkdir('./workdir')
    for fn in os.listdir('./workdir'):
        if fn.startswith('.'): continue
        if fn.endswith(suffix): continue
        files_found += 1
        if os.path.exists('./workdir/%s' % fn + suffix):
            print 'Skip: \'%s\' (already processed)' % fn
            continue
        print 'Extracting: \'%s\' ... ' % fn,
        op = ExtractEmailsOperation(
            in_filename = './workdir/%s' % fn,
            out_filename = './workdir/%s%s' % (fn, suffix))
        op.do()
        files_processed += 1
        print 'Ok'

    if files_found <= 0:
        print 'No valid files found in \'./workdir/\''
    elif files_processed <= 0:
        print 'There is nothing to do'
    else:
        print 'Done.'


def main():
    if len(sys.argv) > 1:
        run_using_args()
    else:
        run_in_folder_mode()

if __name__ == "__main__":
    main()

perl -e 'while (<>) { /.*?\s+<?(\S+?)>?\s+F=/; print "$1\n" }' filename.sql

perl -le 'while (<>) { print for /(\b[\w\.-]+@[\w\.-]+\.\w{2,4}\b)/g; }' FILENAME.EXT