Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.mixmin.net!feeds.phibee-telecom.net!newsfeed.xs4all.nl!newsfeed4.news.xs4all.nl!xs4all!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.003 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; 'executed': 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; 'code': 0.31; '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; '8bit%:9': 0.36; '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=zcG4/RAHVNSng29P3TQ7qkJ9srsjQYDY+Qo8q90197g=; b=tlx22duaw+yXgK+yN8bVDECRaU4F6wbYZNfiSC4VciXxdNdjD7xQX02Uu7PQoKYtPB OW/1/8kG8aCLOukZer8eIVnX62RtUtkUvnVxYe8CQVA6Uw3Vyrs6F3HDXJ9XPQ57w+FT XL2yi14Jsk3Lr+h9MDIW6Le4+Yg70pY1ymYjOcQEetwDD9FjsGv7SzR8aS4qRSujS5VO rvZb3FfgrbcJ8XLnJ7dDgwb9MI8u/7DDRTAQ4JZctgKkgLljBxdFRJ3IJu4IwspjqQ5x HEZnuxjYjnPMaqT+d9L93PEa/RMeczLPN4lVKEFIq/5fDqoptzqyn6Y6WsuAUXRyhNZS FakA== MIME-Version: 1.0 X-Received: by 10.112.147.225 with SMTP id tn1mr25501443lbb.37.1415568009158; Sun, 09 Nov 2014 13:20:09 -0800 (PST) In-Reply-To: References: <46769509.90793.1415564600851.JavaMail.yahoo@jws10740.mail.gq1.yahoo.com> Date: Mon, 10 Nov 2014 02:50:09 +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=047d7b3a8cf45766470507739c4a 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: 259 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1415568017 news.xs4all.nl 2938 [2001:888:2000:d::a6]:46975 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:80443 --047d7b3a8cf45766470507739c4a Content-Type: text/plain; charset=UTF-8 Code after adding path of .txt files : import glob, codecs, re, os regex = re.compile(r"Age: |Sex: |House No: ") # etc etc for txt in glob.glob("D:/Python/source/*.txt"): with codecs.open(txt, encoding="utf-8") as f: oldlines = f.readlines() for i, line in enumerate(oldlines): if "Elector'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)) I executed code in edit rocket. Error message : File "EamClean.log", line 12 with codecs.open(txt + "_out.txt", "wb", encoding="utf-8") as w: ^ SyntaxError: invalid syntax On Mon, Nov 10, 2014 at 2:22 AM, Syed Khalid wrote: > 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 >> > >> > > --047d7b3a8cf45766470507739c4a Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Code after adding path of .txt files :=

import glob, codecs, re, os

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

for txt in glob.glob("D:/Python/source/*.tx= t"): =C2=A0=C2=A0
=C2=A0 =C2=A0 with codecs.open(txt, encodi= ng=3D"utf-8") as f:
=C2=A0 =C2=A0 =C2=A0 =C2=A0 oldline= s =3D f.readlines()
=C2=A0 =C2=A0 for i, line in enumerate(oldlin= es):
=C2=A0 =C2=A0 =C2=A0 =C2=A0 if "Elector's Name:&quo= t; 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().repl= ace("-", "_") for line in oldlines[i:]
=C2=A0= =C2=A0 with codecs.open(txt + "_out.txt", "wb", encodi= ng=3D"utf-8") as w:
=C2=A0 =C2=A0 =C2=A0 =C2=A0 w.write= (os.linesep.join(newlines))


I= executed code in edit rocket.

Error message : =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^
SyntaxError: invalid syntax





On Mon, Nov 10, 2014 at 2:22 AM, Syed K= halid <khalidness@gmail.com> wrote:
Hi Albert,=C2=A0

Thank yo= u for script.=C2=A0

I am getting the below error :=

=C2=A0 File "EamClean.log", line 1= 2
=C2=A0 =C2=A0 with codecs.open(txt + "_ou= t.txt", "wb", encoding=3D"utf-8") as w:
=C2=A0 =C2=A0 =C2=A0 =C2=A0^
SyntaxError: invalid syntax

Kindly do the needful.

On Mon, Nov 10, 2014 at 1:53 AM, Albert-Jan Roskam <fomcl@yah= oo.com> wrote:




----- Original Message -----
> From: Syed Khalid <khalidness@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
>


--047d7b3a8cf45766470507739c4a--