Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.python > #80443

Re: Python script that does batch find and replace in txt files

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 <khalidness@gmail.com>
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; '&quot;)': 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&gt;': 0.16; 'is&quot;': 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&gt;': 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; '&gt;': 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; '&quot;': 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 <CABHN3iHHHdDg9-yOR6z12o5ujx-iWCa2hn8UCrkzQ98CKjv4xg@mail.gmail.com>
References <e9ee1f6f-9397-4dc5-a357-381ebc9b6e57@googlegroups.com> <46769509.90793.1415564600851.JavaMail.yahoo@jws10740.mail.gq1.yahoo.com> <CABHN3iHHHdDg9-yOR6z12o5ujx-iWCa2hn8UCrkzQ98CKjv4xg@mail.gmail.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 <khalidness@gmail.com>
To Albert-Jan Roskam <fomcl@yahoo.com>
Content-Type multipart/alternative; boundary=047d7b3a8cf45766470507739c4a
Cc "python-list@python.org" <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 <python-list.python.org>
List-Unsubscribe <https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive <http://mail.python.org/pipermail/python-list/>
List-Post <mailto:python-list@python.org>
List-Help <mailto:python-list-request@python.org?subject=help>
List-Subscribe <https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups comp.lang.python
Message-ID <mailman.15609.1415568017.18130.python-list@python.org> (permalink)
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

Show key headers only | View raw


[Multipart message — attachments visible in raw view] - view raw

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 <khalidness@gmail.com> 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 <fomcl@yahoo.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
>> 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
>> >
>>
>
>

Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Python script that does batch find and replace in txt files Syed Khalid <khalidness@gmail.com> - 2014-11-09 11:58 -0800
  Re: Python script that does batch find and replace in txt files Mark Lawrence <breamoreboy@yahoo.co.uk> - 2014-11-09 20:17 +0000
  Re: Python script that does batch find and replace in txt files Albert-Jan Roskam <fomcl@yahoo.com> - 2014-11-09 20:23 +0000
  Re: Python script that does batch find and replace in txt files Syed Khalid <khalidness@gmail.com> - 2014-11-10 02:22 +0530
    Re: Python script that does batch find and replace in txt files Syed Khalid <khalidness@gmail.com> - 2014-11-09 13:08 -0800
      RE: Python script that does batch find and replace in txt files "Clayton Kirkwood" <crk@godblessthe.us> - 2014-11-09 15:03 -0800
  Re: Python script that does batch find and replace in txt files Syed Khalid <khalidness@gmail.com> - 2014-11-10 02:50 +0530
  Re: Python script that does batch find and replace in txt files MRAB <python@mrabarnett.plus.com> - 2014-11-09 21:44 +0000
  Re: Python script that does batch find and replace in txt files Syed Khalid <khalidness@gmail.com> - 2014-11-10 03:21 +0530
  Re: Python script that does batch find and replace in txt files Denis McMahon <denismfmcmahon@gmail.com> - 2014-11-11 20:04 +0000

csiph-web