Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!newsfeed.xs4all.nl!newsfeed2.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail Return-Path: X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org X-Spam-Status: OK 0.004 X-Spam-Evidence: '*H*': 0.99; '*S*': 0.00; 'skip:[ 20': 0.04; 'syntax': 0.04; 'subject:Python': 0.06; 'automate': 0.07; 'is"': 0.07; '")': 0.09; 'cursor': 0.09; 'line:': 0.09; 'rows': 0.09; 'subject:files': 0.09; 'subject:script': 0.09; 'trailing': 0.09; 'cc:addr:python-list': 0.11; 'python': 0.11; 'posted': 0.15; '"_")': 0.16; '.txt': 0.16; 'email addr:yahoo.com>': 0.16; 'is"': 0.16; 'newlines': 0.16; 'recorded': 0.16; 'subject:txt': 0.16; 'syntaxerror:': 0.16; 'the"': 0.16; 'files.': 0.16; 'folder': 0.16; 'wrote:': 0.18; 'file,': 0.19; 'skip:g 40': 0.19; 'select': 0.22; 'import': 0.22; 'email addr:gmail.com>': 0.22; 'cc:addr:python.org': 0.22; 'error': 0.23; 'replace': 0.24; 'script.': 0.24; 'skip:l 30': 0.24; 'mon,': 0.24; 'file.': 0.24; 'cc:2**0': 0.24; 'script': 0.25; '>': 0.26; 'query': 0.26; 'header:In-Reply-To:1': 0.27; 'am,': 0.29; 'characters': 0.30; 'skip:g 30': 0.30; 'message-id:@mail.gmail.com': 0.30; 'url:mailman': 0.30; 'getting': 0.31; 'lines': 0.31; '"': 0.31; 'subject:that': 0.31; 'txt': 0.31; 'file': 0.32; 'option': 0.32; 'run': 0.32; 'text': 0.33; 'open': 0.33; 'up.': 0.33; 'url:python': 0.33; '-----': 0.33; 'something': 0.35; 'etc': 0.35; 'received:google.com': 0.35; 'there': 0.35; 'done': 0.36; 'url:listinfo': 0.36; 'url:org': 0.36; 'email addr:python.org': 0.37; 'step': 0.37; 'skip:& 10': 0.38; 'thank': 0.38; 'nov': 0.38; 'skip:[ 10': 0.38; 'files': 0.38; 'skip:& 20': 0.39; 'does': 0.39; 'subject:': 0.39; 'delete': 0.39; 'space': 0.40; 'url:mail': 0.40; 'remove': 0.60; 'blank': 0.60; 'skip:\xc2 10': 0.60; 'break': 0.61; 'name:': 0.61; 'kindly': 0.61; 'you.': 0.62; 'save': 0.62; 'email name:python-list': 0.65; 'reply': 0.66; 'invalid': 0.68; 'skip:w 30': 0.69; 'containing': 0.69; 'to:addr:yahoo.com': 0.81; '"contact': 0.84; '10:': 0.84; '11:': 0.84; '12:': 0.84; '13:': 0.84; '14:': 0.84; 'no:': 0.84; 'subject:find': 0.84; 'syed': 0.84; '|house': 0.84; 'opens': 0.91 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=QGP7JAnK8URMfBYmS3K8rqUcsGeWgcR4ViRhduUmHl0=; b=0O/c7gOH1DQ/Jxtupq8O8ekIvOEM577C52v+cfIr4uVtriRMARBAR83cDK+EiTaK0q WDaib4D/trL73q2Apw5/3nws1rUCN0nLQOtluXWSoG9JfXTZljABKoi+s79eCx79oKGq sUjmJ4vTLGcGT50WJ6R6yFsPw2FPJNL2A4AZbMpDgeXpBgkppg2WzQd87gUG54CmbXyh ww3fBnEi7uf6dYF8I9BT++hbG+uEVZ8YMp/S8yr0VVsg11uEbcgT/V2kd+xwMcVkkkXb /LCu5VC7kgGjIQ8Its6utqlpOO7xO0lKCnK13r5yA8x3Fe7SPBDfgDAYDydaY8N0CTw3 GgeQ== MIME-Version: 1.0 X-Received: by 10.152.20.199 with SMTP id p7mr25533863lae.49.1415566355937; Sun, 09 Nov 2014 12:52:35 -0800 (PST) In-Reply-To: <46769509.90793.1415564600851.JavaMail.yahoo@jws10740.mail.gq1.yahoo.com> References: <46769509.90793.1415564600851.JavaMail.yahoo@jws10740.mail.gq1.yahoo.com> Date: Mon, 10 Nov 2014 02:22:35 +0530 Subject: Re: Python script that does batch find and replace in txt files From: Syed Khalid To: Albert-Jan Roskam Content-Type: multipart/alternative; boundary=089e0141a520cd4002050773396c Cc: "python-list@python.org" X-BeenThere: python-list@python.org X-Mailman-Version: 2.1.15 Precedence: list List-Id: General discussion list for the Python programming language List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Newsgroups: comp.lang.python Message-ID: Lines: 196 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1415566358 news.xs4all.nl 2831 [2001:888:2000:d::a6]:40710 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:80441 --089e0141a520cd4002050773396c Content-Type: text/plain; charset=UTF-8 Hi Albert, Thank you for script. I am getting the below error : File "EamClean.log", line 12 with codecs.open(txt + "_out.txt", "wb", encoding="utf-8") as w: ^ SyntaxError: invalid syntax Kindly do the needful. On Mon, Nov 10, 2014 at 1:53 AM, Albert-Jan Roskam wrote: > > > > > ----- Original Message ----- > > From: Syed Khalid > > To: python-list@python.org > > Cc: > > Sent: Sunday, November 9, 2014 8:58 PM > > Subject: Python script that does batch find and replace in txt files > > > > Python script that does batch find and replace in txt files Need a > python script > > that opens all .txt files in a folder find replace/delete text and save > files. > > > > I have text files and I need to perform below steps for each file. > > > > Step 1: Put cursor at start of file and Search for "Contact's > > Name:". Delete all the rows before it. > > Step 2: Put cursor at end of file, Search for "Contact's Name:" > > select option UP. > > Step 3: Search for "Photo of the" Replace with blanks > > Step 4: Search for "Contact is" Replace with blanks > > Step 5: Search for "Contact's Name:" Replace with blanks > > Step 6: Search for "Age:" Replace with blanks > > Step 7: Search for "Sex:" Replace with blanks > > Step 8: Search for "House No:" Replace with blanks > > Step 9: Search for "available" Replace with blanks > > Step 10: Remove Empty Lines Containing Blank Characters from file > > Step 11: Trim Leading Space for each line > > Step 12: Trim Trailing Space after each line > > Step 13: Search for - (hyphen) Replace with _ (underscore) > > > Step 14: Save file. > > something like (untested) > > > import glob, codecs, re, os > > regex = re.compile(r"Age: |Sex: |House No: ") # etc etc > > for txt in glob.glob("/some/path/*.txt"): > with codecs.open(txt, encoding="utf-8") as f: > oldlines = f.readlines() > for i, line in enumerate(oldlines): > if "Contact's Name: " in line: > break > newlines = [regex.sub("", line).strip().replace("-", "_") for line in > oldlines[i:] > with codecs.open(txt + "_out.txt", "wb", encoding="utf-8") as w: > w.write(os.linesep.join(newlines)) > > > > > > > > Currently I have recorded a macro in Notepad++. > > I open each file, run macro and save file. > > As there are many files I was looking for a program to automate the > process. > > > > I posted the same query in Notepad++ forum. I got a reply that it can be > done by > > using Python script. > > > > Kindly do the needful. > > > > Thank you. > > khalidness > > > > -- > > https://mail.python.org/mailman/listinfo/python-list > > > --089e0141a520cd4002050773396c Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Albert,=C2=A0

Thank you for script.= =C2=A0

I am getting the below error :
=C2=A0 File "EamClean.log", line 12
= =C2=A0 =C2=A0 with codecs.open(txt + "_out.txt", "wb", = encoding=3D"utf-8") as w:
=C2=A0 =C2=A0 =C2=A0 =C2=A0^<= /div>
SyntaxError: invalid syntax

Kindly= do the needful.

On Mon, Nov 10, 2014 at 1:53 AM, Albert-Jan Roskam <fomcl@yahoo.c= om> wrote:




----- Original Message -----
> From: Syed Khalid <khalidne= ss@gmail.com>
> To: python-list@python.org
> Cc:
> Sent: Sunday, November 9, 2014 8:58 PM
> Subject: Python script that does batch find and replace in txt files >
> Python script that does batch find and replace in txt files Need a pyt= hon script
> that opens all .txt files in a folder find replace/delete text and sav= e files.
>
> I have text files and I need to perform below steps for each file.
>
> Step 1: Put cursor at start of file and Search for "Contact's=
> Name:". Delete all the rows before it.
> Step 2: Put cursor at end of file, Search for "Contact's Name= :"
> select option UP.
> Step 3: Search for "Photo of the" Replace with blanks
> Step 4: Search for "Contact is" Replace with blanks
> Step 5: Search for "Contact's Name:" Replace with blanks=
> Step 6: Search for "Age:" Replace with blanks
> Step 7: Search for "Sex:" Replace with blanks
> Step 8: Search for "House No:" Replace with blanks
> Step 9: Search for "available" Replace with blanks
> Step 10: Remove Empty Lines Containing Blank Characters from file
> Step 11: Trim Leading Space for each line
> Step 12: Trim Trailing Space after each line
> Step 13: Search for - (hyphen) Replace with _ (underscore)

> Step 14: Save file.

something like (untested)


import glob, codecs, re, os

regex =3D re.compile(r"Age: |Sex: |House No: ") # etc etc

for txt in glob.glob("/some/path/*.txt"):
=C2=A0 =C2=A0 with codecs.open(txt, encoding=3D"utf-8") as f:
=C2=A0 =C2=A0 =C2=A0 =C2=A0 oldlines =3D f.readlines()
=C2=A0 =C2=A0 for i, line in enumerate(oldlines):
=C2=A0 =C2=A0 =C2=A0 =C2=A0 if "Contact's Name: " in line: =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 break
=C2=A0 =C2=A0 newlines =3D [regex.sub("", line).strip().replace(&= quot;-", "_") for line in oldlines[i:]
=C2=A0 =C2=A0 with codecs.open(txt + "_out.txt", "wb", = encoding=3D"utf-8") as w:
=C2=A0 =C2=A0 =C2=A0 =C2=A0 w.write(os.linesep.join(newlines))




>
> Currently I have recorded a macro in Notepad++.
> I open each file, run macro and save file.
> As there are many files I was looking for a program to automate the pr= ocess.
>
> I posted the same query in Notepad++ forum. I got a reply that it can = be done by
> using Python script.
>
> Kindly do the needful.
>
> Thank you.
> khalidness
>
> --
> https://mail.python.org/mailman/listinfo/python-list
>

--089e0141a520cd4002050773396c--